Have you tried
INSERT
INTO tblTable (nullColumnValue, ...)
VALUES (NULL, ...)
-- The trick is not to cast NULL as a string. Don't wrap it in single
quotes.
JME
-----Original Message-----
From: Greg Zentkovich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 3:47 PM
To: Fusebox
Subject: INSERTING Null Values?
>From the SQL7.0 Enterprise Mgr i can use CTRL + 0 to insert a <NULL> value,
but is possible to get that same effect while inserting from a webpage?
Thanks,
Greg Z
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
