Re: UdmSearch: Webboard: More details about result error in phpwith"NOT( X or Y)

[Matthew Sullivan]

Hi,

Filip Sergeys wrote:

> HOWEVER :
> Search on winter NOT (timber OR tracks)
> returns : 6 results => not as expected 152 - 6 = 146
> ! this is the same result as for (timber OR tracks) AND winter.
>
> I also redid the query with: winter & ~(timber | tracks)
> result : An error occured at '&&'

Switch on the debug and it should tell you what the SQL command it's trying to use it 
- this will help fix the problem.

--
Yours

Matthew

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Ahhh...I see the f*<%-up fairy has visited us again...


begin:vcard 
n:Sullivan;Matthew
tel;cell:+61 (0)414 861 744
tel;fax:+61 (0)3 9693 7699
tel;home:+61 (0)3 9397 4859
tel;work:+61 (0)3 9693 7640
x-mozilla-html:TRUE
url:http://people.netscape.com/matthews/
org:<TABLE cols=2 width=350 spacing=0 rows=1><TR><TD width=50><img src="http://people.netscape.com/matthews/penguin.gif"></TD><TD><TABLE width=250 spacing=0 border=0><TR><TD><FONT SIZE=2>Senior Technical Support Engineer<TR><TD><FONT SIZE=2>iPlanet E-Commerce Solutions<TR><TD><FONT SIZE=2>Netscape Communications Australia Pty Ltd<TR><TD><FONT SIZE=2>A division of America On Line Inc.</TABLE></TABLE>
version:2.1
email;internet:[EMAIL PROTECTED]
adr;quoted-printable:;;Netscape Communications Australia=0D=0A;Level 1, The Tea House, 28 Clarendon Street;South Melbourne;VIC 3205;Australia
x-mozilla-cpt:nemesis.netscape.com;28656
fn:Matthew Sullivan
end:vcard

S/MIME Cryptographic Signature