Pleas help me sort this one. Its regarding Searching.
I have created a form with search text field and menu drop down which lists 4 types of criteria that users can search by before submitting. so user may choose to search by ISBN, Title, author or Price and once user chooses how he/she wants to search by he/she types the search request in the search text field.
Please send me solution if you know. I appreciate any bit help.

Bye


with regards
salman.

Your SQL should look like:
<%
SQL = "SELECT * FROM TableName Where " & Request.QueryString("mnuSearchField" & " = " & Request.QueryString("mnuSearchValue"
%>

Just replace TableName with name of your table, mnuSearchField with form field where you choose type criteria and mnuSearchValue with form field for search request.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Pleas help me sort this one. Its regarding Searching.
I have created a form with search text field and menu drop down which lists 4 types of criteria that users can search by before submitting. so user may choose to search by ISBN, Title, author or Price and once user chooses how he/she wants to search by he/she types the search request in the search text field.
Please send me solution if you know. I appreciate any bit help.

Bye


with regards
salman.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Thanks for your feedback but its not exactly what i meant. yes they have click isbn if they want to search by isbn but hen user will be inputing isbn no in search txt box or putting in title if user selects title from the drop down list menu.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Your SQL should look like:
&lt;%
SQL = "SELECT * FROM TableName Where " & Request.QueryString("mnuSearchField" & " = " & Request.QueryString("mnuSearchValue"
%&gt;

Just replace TableName with name of your table, mnuSearchField with form field where you choose type criteria and mnuSearchValue with form field for search request.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Pleas help me sort this one. Its regarding Searching.
I have created a form with search text field and menu drop down which lists 4 types of criteria that users can search by before submitting. so user may choose to search by ISBN, Title, author or Price and once user chooses how he/she wants to search by he/she types the search request in the search text field.
Please send me solution if you know. I appreciate any bit help.

Bye


with regards
salman.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

with regards
salman.

yes thats fine but how do i do that in ultradev. i might need to send you a image of what i want my search to look like so that you get a clearer oicture. Bye now. appreciate your help thank you.

with regards
salman.