I'm failing to write a query that will get all records from a table when they have a
date entered
into a particular field. I want to exclude Null values.
This doesn't work. Still getting all the NULL records. What does work?
<CFQUERY NAME="dbname" DATASOURCE="dbsource">
SELECT MyDate
FROM Table
WHERE (MyDate <> NULL)
</CFQUERY>
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.