Re: Query-of-Query All but [empty string]

2003-01-07 Thread Todd Rafferty
something <> '' ...? ~Todd At 05:19 PM 1/7/2003 +0100, you wrote: >Dwayne Cole wrote: > > >>try != (not equal): > >> > >> > > > >I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but > != '' does not. I wonder if this is a Q-of-Q bug. > > > > >not email is null > >? > >Jesse

Re: Query-of-Query All but [empty string]

2003-01-07 Thread Jesse Houwing
Dwayne Cole wrote: >>try != (not equal): >> >> > >I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but != '' does >not. I wonder if this is a Q-of-Q bug. > > not email is null ? Jesse ~| Archives: htt

Re: Query-of-Query All but [empty string]

2003-01-06 Thread Dwayne Cole
>try != (not equal): I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but != '' does not. I wonder if this is a Q-of-Q bug. == >> >> SELECT PERSON, >> EMAIL >> >> FROM qry_PERSON >> >> WHERE EMAIL <> '' >> >> >> This query w

Re: Query-of-Query All but [empty string]

2003-01-06 Thread Marius Milosav
l Message - From: "Dwayne Cole" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 06, 2003 11:39 PM Subject: Query-of-Query All but [empty string] > > SELECT PERSON, > EMAIL > > FROM qry_PERSON > > W

Query-of-Query All but [empty string]

2003-01-06 Thread Dwayne Cole
SELECT PERSON, EMAIL FROM qry_PERSON WHERE EMAIL <> '' This query wont work. When I query the database directy the WHERE clause in the SQL statement works fine but when I query a query object it ignors the WHERE clause. How do I reference [empty string] cells in query o