How do you know when it's 4:30 on a Friday afternoon? When you change the value of a column then reset it to its original value further down the page.
Yup, brain fart. That's what it comes down to. Time to go kill that errant brain cell with a nice Friday afternoon cocktail (or three of four). > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@;GetingeCastle.com] > Sent: Friday, November 15, 2002 4:31 PM > To: 'Marco Tabini' > Cc: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Query Executes in MySQL Command Line, Not From > PHP. > > > It's definitely not working. A resulting page breaks each > time the code runs > and I can see that the UPDATE operation has not taken place > when I examine > the data in the database. > > I know the problem is not with the resulting page because the > page is built > to handle NULL and I can see that the database has not been > changed where I > expect it to be. > > I even changed the column definition from smallint to varchar > just to see if > I was not permitted to set a smallint back to NULL, but the > code didn't > perform properly even when the column was a varchar. ARGH! > > Thanks for trying to help. This is so frustrating. > > > -----Original Message----- > > From: Marco Tabini [mailto:marcot@;inicode.com] > > Sent: Friday, November 15, 2002 4:14 PM > > To: Hutchins, Richard > > Cc: [EMAIL PROTECTED] > > Subject: RE: [PHP-DB] Query Executes in MySQL Command Line, Not From > > PHP. > > > > > > Uhm... are you sure it's not working? It's an update > statement, maybe > > the row has already the NULL value before you execute the query? > > > > Otherwise, everything seems to be in order... sorry :-) > > > > > > Marco > > -- > > ------------ > > php|architect - The magazine for PHP Professionals > > The first monthly worldwide magazine dedicated to PHP programmers > > > > Come visit us at http://www.phparch.com! > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php