...

View Full Version : how to link from recordset display



skalag
02-01-2003, 03:10 PM
Hi again, Im stuck once more, this time i want to display on a page, one instance of each (often repetitive) value from a column in a database, so that a user can click on that value and then be processed to go to a specific .htm page that matches that value.
ie.
DB Field name yogibear will appear...
yogibear ... and will link to yogibear.htm

I have been trying to pass id nos but i either get an error or select all the names in a field. I dont know anything about arrays but is this the time i have to learn? Can anyone tell me how i should do this?

angiras
02-04-2003, 02:59 PM
you can call the page itself (yogibear.asp (or aspx)) and pass values


by querystring

yogibear.asp?val=10

by session

session("val")=10

by transfer

val=10
server.transfer(yogibear.asp)

and then you get the value as you like to do

SELECT * FROM myTable WHERE ID= val

skalag
02-04-2003, 07:41 PM
thanks for the reply , i will try and see if i can get it to do what i want, though i must say i have no idea what im doing or where im going but i suppose ive got his far by knowing nowt so i may as well continue....



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum