• 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: Odd SQL UPDATE statement
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


References: 
 >Odd SQL UPDATE statement (From: Klaus Berkling <email@hidden>)
 >Re: Odd SQL UPDATE statement (From: Klaus Berkling <email@hidden>)

  • Prev by Date: Re: Odd SQL UPDATE statement
  • Next by Date: re: Main Not Found?
  • Previous by thread: Re: Odd SQL UPDATE statement
  • Next by thread: re: Main Not Found?
  • Index(es):
    • Date
    • Thread