RE: [PHP-DB] Transaction suddenly not working
| From: | Stuart Felenstein | Date: | Mon, 29 Nov 2004 14:16:09 +0000 |
| Subject: | RE: [PHP-DB] Transaction suddenly not working | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37441@lists.php.net to get a copy of this message | ||
--- "Ford, Mike" <M.Ford@leedsmet.ac.uk> wrote:
> > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo,
> > Telecomu, City1, State1, City2, State2,
> TravelPref,
> > SalaryAnnual, SalaryHourly, Available) VALUES (47,
> > 'ffffffff', 7, 2, 1015, 5, , '', '', '',
> > 'fds', 5,
> '',
>
> You have 2 successive commas in this last line, with
> no value in between --
> this is your syntax error.
>
> > , 4, 26, , 2004-02-02)01062 : Duplicate entry
> '0-f' for key 1
>
> And again on this line -- twice, in fact, since the
> previous line ends with
> a comma, too.
>
Mike are you saying that I should put single quotes
around all values regardless of the type ?
The double commas are happening because around an int
I don't use 'value' the single quotes . ?
Stuart