Listing with response.redirect links

[jacquelinewalton]

Thanks in advance to any help which to some is probably simple.. to me .. horrifying.

I have an asp page that queries a database and gets all the Title, ItemID, and Expiration Fields where a username is true. (I alreadyhave the SQL for this)

BUT... now that I have that info,I can not figure out for the life of me how to display it where it looks like the following in 3 columns:

Title(Hyperlink to

http://www.mydomain.com/videos/&itemid&/)

Item ID Expiration

but the URL for the title where it says &itemid& is a variable for that item only. ItemID and Expiration is not a link

Then it displays the next item and it does this until itts done.

I can get it to list all the items in the columns its the URL with the variable I am having trouble with and the syntax on that. PLEASE help!

 

[mbiro]

SQL="SELECT itemid,title,expiration from db"
SET RS= connstr.execute("SQL")
While not RS.eof

Response.write "A href=""

http://www.mydomain.com/videos/"

& RS("itemid") & """>" & RS("title") & "</a> " & RS("itemid") & "&nbsp;&nbsp;" & RS("expiration") & "<BR>"

RS.movenext
Wend
SET RS=nothing
connstr.close

 

[jacquelinewalton]

THank you so much... MUCH MUCH MUCH better.... thanks