Re: WO 5.2.3 and MySQL
Re: WO 5.2.3 and MySQL
- Subject: Re: WO 5.2.3 and MySQL
- From: Tom Blenko <email@hidden>
- Date: Sat, 3 Jul 2004 01:26:33 -0700
Actually, 'user' is reserved in MySQL so I'm guessing the original
poster has a table by that name that isn't going to go right over to
MySQL. I've used User tables several times with EOModels on OpenBase,
no problem.
Tom
On Jul 2, 2004, at 11:56 PM, Tom Woteki wrote:
If I am not mistaken, the problem is the table name "USER", which is a
reserved name somehow in EO, and it is unrelated to MySQL
specifically. In other words, avoid using "USER"; rename your table.
Perhaps someone else can confirm this.
Tom
On Jul 3, 2004, at 2:19 AM, kadoudal wrote:
but on my first INSERT I got a syntax error problem :
Next exception:SQL State:42000 -- error code: 1064 -- msg: Syntax
error or access violation, message from server: "You have an error
in your SQL syntax. Check the manual that corresponds to your MySQL
server version for the right syntax to use near 'USER(LAST_NAME,
I found that there should be a space between the table name USER and
the first parenthesis ...
but it's generated by the adaptor ! is there any clue but drop
mySQL ????
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.