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]
