How to get Link to pass value from Recordset
Help of yesterday a great help, thanks.
I now have an ASP page that produces a list of Recording Artist names by grabbing all the Artists beginning with 'B' from the database for instance. Beautiful!!! My recordset also returns the 'ArtistID' number used as the primary key in the database.
I want to make each one of the Recording Artists in the list its own link and in the target page use the ArtistID to produce a list of all the recordings in stock by that artist.
My question is, how do I get the link to pass the ArtistID in the URL so I can use Request.QueryString in the target page to base a recordset on it?
As an example, I like to code mine this way -- so that I can still use my WYSIWYG editor to design the table layout:
In the details.asp page:
Do While Not rs.EOF
artistID = rs.Fields("id").Value
artistName = rs.Fields("name").Value
artistID = Request.QueryString("id")
You're more competent than me!
This is coming slowly back to me now and your solution is just what I needed.
How we can do the same in ASP.net and pass that value to database and do a select ? Thanks
Sorry, I don't touch ASP.NET.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)