This should go to the discussion list (and I redirected it there).
Is the column set to allow nulls? If not, that's your issue.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"If liberty means anything at all, it means the right to tell people
what they do not want to hear."
-- George Orwell, 1945
On Sep 28, 2006, at 2:36 PM, Jeff Howard wrote:
I am trying to do an update to a table in SQL Server with <cfquery>
and one of the updates to the record is to a column that has a date
(smalldate type) and I'm trying to update it to <null>.
Seems like this should be simple but everything I've tried keeps
throwing errors.
Stay in the know. Pulse on the new Yahoo.com. Check it out.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
List hosted by FusionLink
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------