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 fields


the 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



Reply to this topic