On Tue, 2002-12-17 at 04:41, Tony Green wrote: > On Tue, 2002-12-17 at 15:32, Michael Fox wrote: > > > > Ahuh, and I've read it along with many other pages from /doc/en/ > > > > As I said, still having problems. > > > > Might just drop this field, and figure it out another time. At the end of the > > day I am just writing something to learn from. Since I've wanted to do some > > more mysql/php mucking about. > > > Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it doesn't > work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if > you get any better results.
I've also had issues with it, but if you want it to try it then specifying a value for it won't let it set it itself. If it is going to work, the way to do it will be to not specify that field at all in your list of fields to insert into. It's supposed to operate like a default value essentially. If you specify something else it will use that. both NULL and the empty string are "something". James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
