try != (not equal):
<cfquery dbtype = "query" name = "qEMAIL" >
SELECT PERSON,
EMAIL
FROM qry_PERSON
WHERE EMAIL != ''
</cfquery>
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm
----- Original 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]
> <cfquery dbtype = "query" name = "qEMAIL" >
> SELECT PERSON,
> EMAIL
>
> FROM qry_PERSON
>
> WHERE EMAIL <> ''
> </cfquery>
>
> 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 object?
>
>
>
> Dwayne Cole, MS in MIS, MBA
> Florida A&M University
> Certified Advanced ColdFusion Developer
> 850-591-0212
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
