|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Search |
|
From: |
Glenn |
|
Date: |
9/30/2002 3:39:16 AM |
|
IP: |
202.57.89.218 |
ive been doin a simple search function using asp(i thnk its not), my sql statement does not filter any of my queries...
'key = words to be search catd=category id
set srchrs = conn.execute ("select * from FAQList where FAQtitle like '%" & key & "%' or FAQText like '%" & key & "%' and catid like '%"& catd & "%'")
if not srchrs.eof then
while not srchrs.eof
response.write "srchrs<%=id%>" and so on
srchrs.movenext
wend
Response.Write "Search did not find any matching Items"
end if
srchrs.close
set srchrs=nothing
dbclose
luckily thres no error but i keeps diisplaying everyhting from the database.. cud anyone help me.. pls pls pls or any1 give me a code. Thnks
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
