--- denys <dbulant@xxxxxxxx> wrote: > hi! > what if you try to ignore the primary key in fields > and values list ? > MySQL should assign a valid primary key. It's what > I'm doing on 4.0.22 > and it's working.... If not, try to echo your query > and write it in > MySQL( GUI or console). > Tried ignoring , first removing the null and ProfileID column name - result still failure. 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, '', , 4, 26, , 2004-02-02)01062 : Duplicate entry '0-f' for key 1 transaction failed When I tried the Insert statement into a mysql gui it spit back a syntax error , apparently for the blank values ..,'', yet those are set to allow null. I went ahead and tried just an insert on the first 4 columns , that worked. Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
