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 PROTECTED]>: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 PROTECTED]"(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 PROTECTED]' 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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
