Welcome Guest, Not a member yet? Register   Sign In
NULL into MYSQL db with active record???
#1

[eluser]nevsie[/eluser]
Its late, and i am probably missing something obvious...
but i have two fields of "hours" (int) and "price" (float) and i am using active record methods to insert the data into the database... the fields are allowed to be null, and setting it to (NULL) through a desktop SQL editor correctly stores the null value in the database...

However, when ever i send values of "" or "null" or "(NULL)" or just not send any value at all the fields set to "0" and "0.00"... not as null...

Any ideas or help on this one...?
Just thought about default values of null - but this does not get accepted... anything other ideas?


Messages In This Thread
NULL into MYSQL db with active record??? - by El Forum - 01-10-2010, 04:16 PM
NULL into MYSQL db with active record??? - by El Forum - 01-10-2010, 04:27 PM
NULL into MYSQL db with active record??? - by El Forum - 01-10-2010, 04:48 PM



Theme © iAndrew 2016 - Forum software by © MyBB