--- "Ford, Mike" <[EMAIL PROTECTED]> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to