• 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: MySQLPlugIn.MySQLExpression bug?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: MySQLPlugIn.MySQLExpression bug?


  • Subject: Re: MySQLPlugIn.MySQLExpression bug?
  • From: Lachlan Deck <email@hidden>
  • Date: Tue, 7 Feb 2006 09:26:28 +1100

Hi there,

On 06/02/2006, at 7:56 PM, Wolfram Stebel wrote:

Am 06.02.2006 3:51 Uhr schrieb "Lachlan Deck" unter
<email@hidden>:

I get a JDBCAdaptorException: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0. FROM Person t0 WHERE (t0.email = ? AND
t0.firstName = ? AND t0.lastName = ?" withBindings:
1:"email@hidden"(email), 2:"Bill"(firstName), 3:"Blog"(lastName)>:
Next exceptionSQL State:42000 -- error code: 1064 -- msg: 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  'FROM
Student t0 WHERE (t0.email = 'email@hidden' AND t0.f

The "Select t0." is the problem.

I thought so. It didn't look right...

How did you manage to create this sql?
Are there missing attribute names in your eomodel?

Bingo. Slightly incorrect model. I'm using a 'derivedCount' attribute which should be a derived attribute - but the definition: count(*) got lost.


Thanks very much Wolfram!

with regards,
--

Lachlan Deck


Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Prev by Date: Re: WebObjects Licensing
  • Next by Date: (no subject)
  • Previous by thread: MySQLPlugIn.MySQLExpression bug?
  • Next by thread: multi user increment
  • Index(es):
    • Date
    • Thread