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
> 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 :-)
> 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