Dan, Don't hate me for saying this but you are the MAN! Yep, it was Contact Email. Oops !
It works great now Thank you all! Stuart --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Aug 18), Stuart Felenstein > said: > > Okay, still not working in this one table so here > is all my info: > > I've also attached the table dump. > > > > Thank you , > > Stuart > > > > Error Code from attempted transaction: > > ------------------------------------------------- > > Transaction failed! > > Your SQL: > > insert into LFWBank > > > (JobReferenceCode,VendorID,LocationCity,LocationState,AreaCode,PayRate,Contact,Contact > > Email,TravelReq,FullSpec) values > > > (9999,11,'Bronx','AL',212,11,'Joe','[EMAIL PROTECTED]','no',' > > ) > > I can't be sure due to the word-wrapping your client > performed on these > lines, but is one of your field names "Contact > Email" with a space in > it? If so, you'll have to escape it with backtics: > `Contact Email` > > Renaming the field might be better though. > > > -- > Dan Nelson > [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
