Re: Odd SQL UPDATE statement
Re: Odd SQL UPDATE statement
- Subject: Re: Odd SQL UPDATE statement
- From: Klaus Berkling <email@hidden>
- Date: Wed, 10 Oct 2007 19:13:45 -0700
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.
Should have known that... sigh. I feel so... little. :-)
Thanks everyone.
kib
"Success is not final, failure is not fatal: it is the courage to
continue that counts.”
- Winston Churchill
--
Klaus Berkling
Systems Administrator
DynEd International, Inc.
www.dyned.com | web.mac.com/kib
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