I know that if you are using access this should work.
> <CFQUERY NAME="dbname" DATASOURCE="dbsource">
> SELECT MyDate
> FROM Table
> WHERE MyDate Is Not Null
> </CFQUERY>
Hope that helps,
-Michael
========================================
Michael Imhoff :::: www.omnicypher.com :::: icq: 10495667
[EMAIL PROTECTED] (home) :::: (320) 255-4447 (home)
[EMAIL PROTECTED] (cell) :::: (612) 247-8159 (cell)
Allaire Alliance Consulting Partner
----- Original Message -----
From: Chris Giminez <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 3:26 AM
Subject: Getting only records with a date
> 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.
------------------------------------------------------------------------------
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.
