Re: Odd SQL UPDATE statement
Re: Odd SQL UPDATE statement
- Subject: Re: Odd SQL UPDATE statement
- From: Art Isbell <email@hidden>
- Date: Wed, 10 Oct 2007 16:24:29 -1000
On Oct 10, 2007, at 4:13 PM, Klaus Berkling wrote:
On Oct 10, 2007, at 6:48 PM, Klaus Berkling wrote:
Why does WO create such an odd SQL statement:
UPDATE QA SET question = NULL, answer1 = NULL, id_users = ?,
problem = NULL, date_modified = ? WHERE (id = ? AND answer1 = ? AND
answer2 is NULL AND date_created = ? AND date_modified = ? AND
figure1url is NULL AND figure2url is NULL AND figure3url is NULL
AND id_language = ? AND id_qaDetails = ? AND id_users = ? AND
keywords is NULL AND problem = ? AND question = ?)
The answer lies within optimistic locking and that lock icon in the
eomodler.
But if you find that updates are failing mysteriously, be suspicious
of date and floating point locking attributes whose values may lose
precision between the database and your app thus causing bogus
mismatches.
Aloha,
Art
_______________________________________________
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