the set itself
WHERE fooId IN (fooId)
Adolfo
-Original Message-
From: Peter Abilla [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:43 PM
To: [EMAIL PROTECTED]
Subject: sql:WHERE IN SYNTAX
Question about SQL WHERE IN syntax:
I know that something like
]
Subject: sql:WHERE IN SYNTAX
Question about SQL WHERE IN syntax:
I know that something like this is fine to do:
(1)
SELECT foo
FROM bar
WHERE fooID in ('1','2')
In the example above, the parenthesis includes the itemized
fooID's. But, I want to do a similar thing where instead
I have this query built from a web form. The form will add to the query
depending on what search criteria has been chosen. what happens is if they
choose the criteria in the query below, it stops comparing the other
criteria such as listed date and price range. Also the = operator does not
return
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
I have this query built from a web form. The form