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
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
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 quoting
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
Hello
I have a table which contain a few numerical values.
I set the default values to be NULL.
When I insert values using phpMyAdmin, it sets the values to NULL correctly.
But when I insert using a PHP script that I wrote it sets the values
to 0.00or 0.
In my script I do test if the values are
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
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
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:
Hello
I