Try something like:
if MyNewMoney EQ ""
MyNewVal = "NULL"
else
MyNewVal = #form.MyNewMoney#"
<cfquery...
UPDATE MyTable
SET MyNewMoney = #MyNewVal#
Didn't test this, but the suggestion is to set a field to NULL using an
assignment. I believe this is the only situation where you can use "= NULL
" in SQL.
Mischa.
>
"Dean H. Saxe" <[EMAIL PROTECTED]> wrote:
This should go to the discussion list (and I redirected it there).
I apologize, this is my first attempt at trying to ask a question to the ACFUG
and I just replied to an email that I received.
Is the column set to allow nulls? If not, that's your issue.
Yes, it is set to accept nulls. The issue is the form passes a "" and when it
tries to update a smalldate and a money field in the table it throws and error.
I put the SQL statement generated in the CF error into Enterprise Manager and
dissected it field by field. The error that I get from Enterprise Manager is
invalid data type or length.
-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
> 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 .
>
> 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
-------------------------------------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.
-------------------------------------------------------------
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 FusionLink
------------------------------------------------------------- <
Mischa Uppelschoten
The Banker's Exchange, Inc.
2020 Hills Avenue NW
Atlanta, GA 30318
Phone: (404) 605-0100 ext. 10
Fax: (404) 355-7930
Web: www.BankersX.com
Follow this link for Instant Web Chat:
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
-------------------------------------------------------------
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
-------------------------------------------------------------
