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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
