Query Results as Hyplerlink to another

Results 1 to 2 of 2

Thread: Query Results as Hyplerlink to another

  1. #1
    Rob Akafekwa Guest

    Default Query Results as Hyplerlink to another

    I am new to asp and have so far got may database queries to return results on the web.<BR><BR>The query returns a list of companies registered on my web page. I need this result to be returned as a link of some sort (hyperlink) that will run another query to return a list of products available for that company.<BR><BR>How do i do this? Where can i get resources for mor help with this one?<BR><BR><BR>Many thanks in advance.<BR><BR>Rob A

  2. #2
    Join Date
    Dec 1969
    Posts
    590

    Default RE: Query Results as Hyplerlink to another

    Feed the results into a hyperlink:<BR>&#060;a ref="CoProducts.asp?Co=&#060;%="rs("CoName")%&#062 ;"&#062;&#060;%=rs(CoName")&#062;&#060;/a&#062;<BR>Then in CoProducts.asp use something like:<BR>Co = Request.querystring("Co")<BR>SELECT * FROM TableName WHERE CoName =" & Co<BR>This should do it.

Posting Permissions

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