PHP DB - RE: [PHP-DB] Transaction suddenly not working

Author

RE: [PHP-DB] Transaction suddenly not working

Mike Ford

2004-11-29, 3:59 pm

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm

On 29 November 2004 13:19, Stuart Felenstein wrote:

> Now the printout of the query is this:
>
> 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.

Track down whatever is outputting these null values, fix it, and you should
be good to go (well, at least less bad!).

Cheers!

Mike

---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: m.ford@leedsmet.ac.uk
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211

Stuart Felenstein

2004-11-29, 3:59 pm

--- "Ford, Mike" <M.Ford@leedsmet.ac.uk> wrote:

> TravelPref,
> '',
>
> You have 2 successive commas in this last line, with
> no value in between --
> this is your syntax error.
>
> '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

Sponsored Links