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

Re: NULL problem in Query

WHERE WhenSubmitted=NULL; should be WHERE WhenSubmitted IS NULL - Original Message - From: "Gene Kraybill" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 12:19 PM Subject: NULL problem in Query Mystery. Can someone tell me w

Re: NULL problem in Query

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 Acce