|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
