try
WHERE WhenSubmitted IS NULL
----- Original Message -----
From: "Gene Kraybill" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 20, 2000 7:19 PM
Subject: NULL problem in Query
> Mystery. Can someone tell me what I'm missing?
>
> I have an Access date field called WhenSubmitted. I start with the field
populated.
> Then I run this test:
>
> <CFQUERY NAME="SetNull" DATASOURCE="vasco1new">
> UPDATE Orders
> SET WhenSubmitted=NULL
> WHERE OrderID=4
> </CFQUERY>
>
> I manually check the field. It is now empty, presumably set to NULL. But
when I run
> the following, I get a record count of 0.
>
> <CFQUERY NAME="GetNull" DATASOURCE="vasco1new">
> SELECT *
> FROM Orders
> WHERE WhenSubmitted=NULL;
> </CFQUERY>
>
> <CFOUTPUT>#GetNull.RecordCount#</CFOUTPUT>
>
> Gene Kraybill
> ---------------------------------
> Gene Kraybill
> LPW & Associates LLC
> www.lpw.net
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
