Forums
This topic is locked
filter recordset
Posted 11 Jun 2001 11:33:50
1
has voted
11 Jun 2001 11:33:50 gianluca jean posted:
What is the sql stantement to filter more fieldsthe stantement for me don't work well because
Suppose we have a table (Tabella) and 2 fields (ID, Descriptions)
Tabella:
ID Descriptions
1 asd
2 gffaf
3 ffsag
4 fgfgs
5 fwsfs
search is: 2
the query is
"SELECT *
FROM Tabella
WHERE ID OR Descriptions = ' " + Request.Form("search" + " ' "
results:
1 asd
2 gffaf
3 ffsag
4 fgfgs
5 fwsfs
right results [for me]
2 gffaf
Thanks to all