RE: What is the cause of this error?
> From: Robert Bailey > > Nope, no CFQueryParams at all, was more like this: > > Update table > Set this = 'that', > this2 = 'that2' > Where myid = id > > VERY Simple update. Oh well, not doing it now, so can not complain :) Have you checked that there are no apostrophies in the strings you're trying to update with? If there are, and you're not handling them, then it'll break I'd ALWAYS use CFQUERYPARAM, even in simple queries [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What is the cause of this error?
Nope, no CFQueryParams at all, was more like this: 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]
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]
RE: What is the cause of this error?
Well, ummm, never mind, now it is not doing it and nothing has changed. -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:34 PM To: CF-Talk Subject: What is the cause of this error? 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]
What is the cause of this error?
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]