JeevesBond — Sun, 07 Jan 2007 10:20:45 +0000

The answer would probably be something like this, the problem is I don't know what you're linking to, or what field needs to be passed to the new page.

Is the rent column set as type 'hyperlink'? I expect 'hyperlink' is just a text field.

What you want will look something like this:

Response.write "<td height=118 ><a href=" & chr(34) & "thepage.asp?id=" & objRS("Id") & chr(34) & ">" & objRS("Rent") & "</a></td></tr>"

INEEDHELP — Sat, 06 Jan 2007 18:10:55 +0000

~~this is my coding below~~

Response.Write "" & objRS("Make/Model") & ""

Response.Write "" & objRS("Description")& ""

strPicture = objRS("Image")
Response.Write "" & "" & ""

Response.write "" & objRS ("Rent") & ""

Response.Write "Price:" & objRS("Price") &""&""

Response.Write "Deposit:" & objRS ("Deposit") & ""
objRS.MoveNext
loop

the column in bold is the one i wud like to make a link, but i have done this using the but it will not let me create a individual link for each column that i read from the database.

THANKS

JeevesBond — Sat, 06 Jan 2007 07:42:11 +0000

Well I don't know what special 'stuff' making the column type 'hyperlink' does, not much I'd imagine.
It's still just a string really, and to make it a link in your code you need to put it in an 'a' tag.

Could we see what code you've got so far? Then we can make it work.