RE: [PHP-DB] Transaction suddenly not working
| From: | Stuart Felenstein | Date: | Mon, 29 Nov 2004 15:11:55 +0000 |
| Subject: | RE: [PHP-DB] Transaction suddenly not working | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37445@lists.php.net to get a copy of this message | ||
--- dpgirago@mdanderson.org wrote:
> > --- "Ford, Mike" <M.Ford@leedsmet.ac.uk> wrote:
> Don't know about other database engines, but in
> MySQL, it doesn't matter
> if an int is inserted as a string, i.e., with the
> quotes. My recollection
> is that MySQL handles the type conversion
> internally. So, assuming you are
> validating the entries before inserting, if a value
> is missing, assign to
> it ''. Whatever the field has as a default value
> will then be inserted
> into the table.
>
> dave
Well most of these fields are optional and in the db
set to allow null. I went ahead and put '' around all
the values so just in case. Though I know for a fact
it was working without them before.
Oh and yes it seems to be working now.
Stuart