hi,
As you can see the program bycolor.asp, byweight.asp

http://internal.quickentextiles.com....om/bycolor.asp

http://internal.quickentextiles.com....m/byweight.asp

HOw can I create a single search button to search let say I input 10 on by
weight and input blue on the by color search and can search this combine criteria with only this two matched criteria result.

Any solution.
thanks
man
Email : wwmg@netvigator.com

Gary,

You need to have a single search page. That search page has several input fields. The user enters several values and clicks Submit. When submitted, your single results page simply looks at all the fields that were submitted and builds the SQL string.

In your code, you have a separate search page, form tag, and result page for every search type. You only need one search page containing one form tag, and one result page.

Gary,

Post back to the forum instead of emailing me. It'll help you where many other developers can review your question, and it'll help others who may have the same question.

Thanks for your reply. I still can't get the syntax of how to do. To create a form. How can I link back to each individual asp program with SQL. Do I need to modify the SQL statement too.
Please help.
Do you have any step or hints I can work this multiple searching by criteria as well.

thanks

gar

hi,
As you can see the program bycolor.asp, byweight.asp

http://internal.quickentextiles.com...oom/bycolor.asp

http://internal.quickentextiles.com...om/byweight.asp

HOw can I create a single search button to search let say I input 10 on by
weight and input blue on the by color search and can search this combine criteria with only this two matched criteria result.

Any solution.
thanks
man
Email : wwmg@netvigator.com