Topic Options
Rate This Topic
#141641 - 02/08/11 01:04 PM search assistance required
Mtop Offline
Stealth Member

Registered: 11/08/08
Posts: 19
I have to contruct a search but have only got half way

I need to search on a form and get results for
(fieldA = a, fieldA = b, fieldA = c, fieldA = d) OR (fieldB = e or fieldB = f)

which is the easy bit
I now have to run an extended search with a NOT for the same fieldA and FieldB

(fieldA = g, fieldA = h, fieldA = i, fieldA = j) OR (fieldB = k or fieldB = l)

Is it an OR NOT or and AND NOT

(fieldA = a, fieldA = b, fieldA = c, fieldA = d) OR (fieldB = e or fieldB = f) but not these
(fieldA = g, fieldA = h, fieldA = i, fieldA = j) OR (fieldB = k or fieldB = l)

Top
#141642 - 02/08/11 01:35 PM Re: search assistance required [Re: Mtop]
Mtop Offline
Stealth Member

Registered: 11/08/08
Posts: 19
the first part it is actually coded as
(fieldA = a or fieldA = b or fieldA = c or fieldA = d) OR (fieldB = e or fieldB = f)

dont know if I need to do anything clever with the brackets either

((fieldA = a or fieldA = b or fieldA = c or fieldA = d) OR (fieldB = e or fieldB = f))

Top
#141643 - 02/11/11 02:27 AM Re: search assistance required [Re: Mtop]
Mtop Offline
Stealth Member

Registered: 11/08/08
Posts: 19
well we got the above sorted and then a request was issued for a select with NULLs OR NULLS which we then pointed out was rather silly as the data extract went from a few to a few thousand so they gave up and the request was withdrawn .......

Top