Passing database values through hyperlinks

[csiwa28]

I just started developing in ASP and I have some questions that I can't find answers to online and I am looking for help.

I have a database with a table - Product

Name Type
Product A Type A
Product A Type B
Product B Type A

My first asp page will read from the database and list all the products as hyperlinks. Then when the user clicks on a hyperlink, then a second page will display the different types of that product.

My question is how do I pass a value from a hyperlink? Here's what I have so far.

Dim objRec
Set objRec = Server.CreateObject ("ADODB.Recordset&quotobjRec.Open "Product",strConnect,adOpenStatic,adLockReadOnly,adCmdTable

'loop through the products table
Response.Write &quot;Select Product Type:<BR>&quot;
While Not objRec.EOF
Response.Write &quot;<a href= type.asp>&quot; & objRec(&quot;Name&quot & &quot;</a>&quot; & &quot;<BR>&quot;

objRec.MoveNext
Wend

 

[timtom]

I do it with QueryStrings - like this...

<a href=&quot;type.asp?<%=&quot;NAME=&quot; & objRec(&quot;NAME&quot%>&quot;>


Type.asp then includes a suitable SQL query selecting * from product where name = request.querystring(&quot;NAME&quot

Or something like that.

Cheers
Sarah