Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jan 2003
    Location
    N. Ireland
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to link from recordset display

    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?
    ska

  • #2
    Regular Coder
    Join Date
    Dec 2002
    Location
    France
    Posts
    522
    Thanks
    0
    Thanked 0 Times in 0 Posts

    transfer querystring or session

    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

  • #3
    New Coder
    Join Date
    Jan 2003
    Location
    N. Ireland
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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....
    ska


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •