ot;S P" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: MySQL data matching error...
I am using phpMyAdmin to simplify the DB administration, but yes
I have setup the table as you are suggesting. The problem as I see it
is that the value of the incoming data is '
> From: Dan Hopkins <[EMAIL PROTECTED]>
> Date: 2004/09/21 Tue AM 09:45:32 GMT
>
> > -Original Message-
> > From: amonotod [mailto:[EMAIL PROTECTED]
> > Sent: 20 September 2004 17:09
> >
> > 1) if you're using place-holders, assign undef() to the value, and
> > the DBI *should* convert
> -Original Message-
> From: amonotod [mailto:[EMAIL PROTECTED]
> Sent: 20 September 2004 17:09
> To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
> Subject: Re: MySQL data matching error...
[snip]
> 1) if you're using place-holders, assign undef() to the value,
> From: "NIPP, SCOTT V \(SBCSI\)" <[EMAIL PROTECTED]>
> Date: 2004/09/16 Thu PM 07:22:25 GMT
>
> I am having a problem in that if a field is blank, it is getting
> put into the database as a '0' rather than 'NULL'. The table is setup
> to both allow NULL values in this field as well as NULL
this
change log testing.
Thanks again for any feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: S P [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 2:27 PM
To: NIPP, SCOTT V (SBCSI); [EMAI
Hi,
Not sure what you're trying to achieve,
Are you trying to have a blank(' ') instead of '0'?
or are you trying to actually store as 'NULL'?
Have you tried
create table table_name (
field datatype(size) default as 'NULL',
...
)
?
--- "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> wrote:
>
I am having a problem in that if a field is blank, it is getting
put into the database as a '0' rather than 'NULL'. The table is setup
to both allow NULL values in this field as well as NULL being the
default value. The problem is that on a few entries the field is
actually empty, but the