<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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
