My apologies.. I scanned back looking for the reference but couldn't
find it... I thought it worth reiterating what turned out to be your
point because there seems to be so much confusion around this issue.
- michael
On 8/9/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
> Actually, I said to m
IF it is a null in that column, you should not see the word 'null'..
and the advise to put quotes around it I read earlier in this thread
is completely misguided.. If you insert the string 'null' or 'NULL'
into the database, you have just strored a string..
Perhaps it is the form of your queries
I did remove that column from the insert statement and no text appeared at
all in that field under that column. Not even the word "NULL".
On 8/8/07, Christian High <[EMAIL PROTECTED]> wrote:
>
> On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
> > One thing to check is to make sure you are not
Hi
I added the following statement at the end of the my.cnf file:
sql-mode="STRICT_ALL_TABLES,ALLOW_INVALID_DATES"
but I still got the values 0 and 0.00 where no values were entered.
I did restart the the mysql daemon of course.
What am I still doing wrong?
Thanks.
On 8/8/07, Christian High <
On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
> One thing to check is to make sure you are not quoting your NULL
> value for your insert statement. MySQL will try to convert that to a
> numeric value, which may end up as 0.
>
> On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
>
> > Hell
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I have a table which contain a few numerical values.
I set
That is MySQL, not PHP doing that to you. You need to set your
SQL_MODE to strict to get that kind of behavior.. there are other
implications to this mode so you should review:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- michael
On 8/8/07, Mahmoud Badreddine <[EMAIL PROTECTE
