• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: WO 5.2.3 and MySQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


References: 
 >WO 5.2.3 and MySQL (From: kadoudal <email@hidden>)
 >Re: WO 5.2.3 and MySQL (From: Tom Woteki <email@hidden>)

  • Prev by Date: Re: A "Why WebObjects" Site / Initial Thoughts Please
  • Next by Date: Re: specifying number of rows to fetch
  • Previous by thread: Re: WO 5.2.3 and MySQL
  • Next by thread: Re: WO 5.2.3 and MySQL
  • Index(es):
    • Date
    • Thread