Send Search Results to another Asp Page

[danieljoo]

I have a db that I am using to search conference attendees. The users are able to search the db using an asp page, based on a company name, city or company number (using like). From the results that are returned, I would like the users to be able to click on the desired result and open another window containg that companies attendees. Somehow I would need to create a hyperlink that sends a query using the company number, but not sure of the syntax:

a href ="select all from Attendess where CustomerNumber = 'the company that was selected'"

 

[Skee777]

Try sending your link to another asp page that runs the query.

<a href='query.asp?companynumber=&quot; & RS(&quot;companynumber&quot;) & &quot;'> text here </a>&quot;

Where RS("companynumber') is, insert your company number from your record set

Pass this to a new asp page that runs another query using the request("companynumber&quot in the where statement

"Select * from Attendees where companynumber = " & request("companynumber")

The request("companynumber&quot will insert the variable that was passed in the link.

Why isn't phonetic spelled the way it sounds?