search page

W

Wayne

Can anyone explain to me how to setup a search page (to search a database)
using multi variables to search by.

Thanks
Wayne
 
R

Ravi Anguluri

The link is a step by step guide for create a search page in FrontPage 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;825487
Hope this Information helps.

Regards
Ravi Anguluri
MSFT

This posting is provided "as is" with no warranties and confers no rights

--------------------
||
| Can anyone explain to me how to setup a search page (to search a database)
| using multi variables to search by.
|
| Thanks
| Wayne
|
|
|
|
| ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
| http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000
Newsgroups
|
|
 
W

Wayne

I was wanting to use checkboxes as the variables. Is this asking to much.

Thanks
Wayne Elder
 
S

Stefan B Rusynko

No
Get your checkbox form values as

strQueryText1 = Request("QUERYTEXT1")
strQueryField1 = Request("QUERYFIELD1")
strQueryText2 = Request("QUERYTEXT2")
strQueryField2 = Request("QUERYFIELD2")

Then use the info in the KB but modify the script to get the variables from your check box values
In the strSQL Replace (using AND or OR)
(" & strQueryField & " LIKE '%" & strQueryText & "%')
with
(" & strQueryField1 & " LIKE '%" & strQueryText1 & "%') AND (" & strQueryField2 & " LIKE '%" & strQueryText2 & "%')



| I was wanting to use checkboxes as the variables. Is this asking to much.
|
| Thanks
| Wayne Elder
|
|
| | > The link is a step by step guide for create a search page in FrontPage
| 2003
| > http://support.microsoft.com/default.aspx?scid=kb;en-us;825487
| > Hope this Information helps.
| >
| > Regards
| > Ravi Anguluri
| > MSFT
| >
| > This posting is provided "as is" with no warranties and confers no rights
| >
| > --------------------
| > ||
| > | Can anyone explain to me how to setup a search page (to search a
| database)
| > | using multi variables to search by.
| > |
| > | Thanks
| > | Wayne
| > |
| > |
| > |
| > |
| > | ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
| > News==----
| > | http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000
| > Newsgroups
| > |
| > |
| >
|
|
|
|
|
|
|
 
Top