RE: [PHP-DB] Query Executes ... SOLVED
| From: | Hutchins, Richard | Date: | Fri, 15 Nov 2002 21:53:15 +0000 |
| Subject: | RE: [PHP-DB] Query Executes ... SOLVED | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23407@lists.php.net to get a copy of this message | ||
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: php-db@lists.php.net
> 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: php-db@lists.php.net
> > 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
>