#mysql - Mon 2 Apr 2007 between 00:00 and 00:18

NY Lost Funds



fdsdchadmaynard, only one more question, my table has the quanity as int(10) is there something better to use, because when I do not add info into quanity I want it set automaticly to null.. Should I do this with char(10)? or is there a better type?
actionchadmaynard wonders what 's' is
chadmaynardwonders what 's' is
fdsd: An int can be null
fdsdchadmaynard, for some reason when I put nothing in it puts a 0
chadmaynardfdsd: you told it to!
fdsdchadmaynard, really?
chadmaynardfdsd: try defining it as `quantity` INT(10) DEFAULT NULL
MySQL assumes a default 0 for ints
fdsdshow columns from repairs; shows default NULL for that
chadmaynarddoes it say NULL yes?
the NULL column?
fdsdyes
NULL is yes and default column is NULL
chadmaynardthen it should default to NULL
are you inserting anything into it? are you mentioning it in the insert at all?
fdsdchadmaynard, really, yeah it is being mentioned in insert
I believe
its using a php script
chadmaynarddon't mention it at all
i suspect PHP is inserting the 0 if its default NULL
fdsdsee I do not know how to, because the user needs to have the option
chadmaynard, let me upload the script
chadmaynardthen if they don't you need to specify NULL
fdsdchadmaynard, i was trying to avoid that, also when nothing is put in with the part it puts NULL into the database
chadmaynard, only with int it seems to be putting 0
chadmaynardfdsd: echo the $sql generated by PHP when a quantity is not specified
fdsdchadmaynard, here are the two files, html.txt and insert.txt
the html.txt is the form and the insert.txt is the php file that generates the sql statement
chadmaynard, I am working on normalization now, so it wont be so messy later
lol
chadmaynardwow
fdsdchadmaynard. what happened?
chadmaynardi think my wireless and wired networks had a battle to the death
twice
so i disabled wireless
fdsdchadmaynard, lol
chadmaynard, did you get my last post?
chadmaynardi never got the files
fdsdchadmaynard, http://keanmarine.com/html.txt http://keanmarine.com/insert.txt
chadmaynardso you aren't inserting 0 or NULL. you are inserting ''. since '' is invalid as an INT it reverts to 0

Page: 2 9 16 23 30 37 44 51 58 65 72 

IrcArchive

NY Lost Funds