• 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: columns being set to null for no apparent reason
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: columns being set to null for no apparent reason


  • Subject: Re: columns being set to null for no apparent reason
  • From: Mark Wardle <email@hidden>
  • Date: Thu, 27 May 2010 06:38:41 +0100

I've been caught out by accidentally forgetting to use a WOForm and then have spent ages looking for why everything was set to null. Worth checking...

Mark

-- 
Dr. Mark Wardle
Specialist registrar, Neurology
(Sent from my mobile)


On 26 May 2010, at 18:57, Larry Mills-Gahl <email@hidden> wrote:

Hello,

I setup what I think is a pretty simple program to map some external identifier strings to existing data. Two display groups on one page. First display group is the objects (Center) to be edited, the second display group (ExternalCenter) is used to find the right match by searching on the name.

One attribute of the Center is all that is being updated. 

com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'parentCenterFK' cannot be null 
Reason: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE center SET cmsnum = ?, parentCenterFK = NULL, active = NULL WHERE (centerKey = ? AND active = ? AND cmsnum is NULL AND code = ? AND name = ? AND parentCenterFK = ?)" withBindings: 1:"310001"(cmsProviderNumber), 2:620(centerkey), 3:1(active), 4:"HUMED"(code), 5:"University Medical Center"(name), 6:620(parentcenterfk)>: Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 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: 
 >columns being set to null for no apparent reason (From: Larry Mills-Gahl <email@hidden>)

  • Prev by Date: columns being set to null for no apparent reason
  • Next by Date: Re: WWDC? (Was: Snow Leopard, Apache 2.2, Skewed Load Balancing?)
  • Previous by thread: columns being set to null for no apparent reason
  • Next by thread: Re: columns being set to null for no apparent reason
  • Index(es):
    • Date
    • Thread