Re: MySQLPlugIn.MySQLExpression bug?
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