Update table
Set this = 'that',
this2 = 'that2'
Where myid = id
VERY Simple update. Oh well, not doing it now, so can not complain :)
-----Original Message-----
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 12:52 PM
To: CF-Talk
Subject: Re: What is the cause of this error?
You are probably using cfqueryparam and defining a datatype but not
clarifying what to do if the form value is empty. null="#yesnoformat(not
len(trim(form.field)))#" is an option I use (per a suggestion from this
list, thank you very much).
The other option is that your SQL table field does not allow null
(empty) values.
Hope this helps.
Cutter
Robert Bailey wrote:
> I have an application, simple form with a simple MS SQL update. Was
working
> fine, checked on it today and got the following error:
>
> The system has attempted to use an undefined value, which usually
indicates
> a programming error, either in your code or some system code.
> Null Pointers are another name for undefined values.
>
> I have never seen this at all. Any ideas as to what may be the cause?
> Thanks!
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
