Looks like I had to unlock "doubleNumber" in my model. thanks.
On Jun 19, 2013, at 9:59 AM, James Cicenia <ja...@jimijon.com> wrote: > Red herring... something else going on. > > I have a rest direction action and do the following in the action: > > EOEditingContext ec = ERXEC.newEditingContext(); > > Device device = getDevice(ec,hwid,ppAppKey); > > device.setLastReportedLongitude(new > Double(json.get("lng").toString().replace("\"", ""))); > device.setLastReportedLatitude(new > Double(json.get("lat").toString().replace("\"", ""))); > device.setDateModified(new DateTime());// I can remove this and > it still fails. > ec.saveChanges(); > Thoughts? > > > On Wed, Jun 19, 2013 at 9:02 AM, James Cicenia <ja...@jimijon.com> wrote: > I am getting an error: > Caused by: com.webobjects.eoaccess.EOGeneralAdaptorException: > updateValuesInRowDescribedByQualifier -- > er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in > database > > > Here is the SQL being generated: > > UPDATE Device SET lastReportedLatitude = ?, lastReportedLongitude = ?, > dateModified = ? WHERE (id = ? AND badge is NULL AND hwid = ? AND > lastReportedLatitude = ? AND lastReportedLongitude = ? AND osGatewayID = ? > AND ppAppKey = ? AND token = ? AND zoneID is NULL)" withBindings: > 1:41.85897038322115(lastReportedLatitude), > 2:-87.66461452477394(lastReportedLongitude), > 3:2013-06-19T08:52:51.734-05:00(dateModified), 4:2(id), > 5:"6C219B57-8184-4537-85CE-B4A33F78F91E"(hwid), > 6:41.8588996399584(lastReportedLatitude), > 7:-87.6646017842811(lastReportedLongitude), 8:0(osGatewayID), > 9:"679DB-17774"(ppAppKey), > 10:"63080abb26010101ee4c...34a91d9a62bdaf20440a"(token)> > > Here is it converted to run : > > This Fails: > > UPDATE Device SET lastReportedLatitude = 41.85897038322115, > lastReportedLongitude = -87.66461452477394, dateModified = > 2013-06-19T08:52:51.734-05:00 WHERE (id = 2 AND badge is NULL AND hwid = > "6C219B57-8184-4537-85CE-B4A33F78F91E" AND lastReportedLatitude = > 41.8588996399584 AND lastReportedLongitude = -87.6646017842811 AND > osGatewayID = 0 AND ppAppKey = "679DB-17774" AND token = > "63080abb26010101ee4c...34a91d9a62bdaf20440a" AND zoneID is NULL); > > However if I put quotes around dateModified it does update. > > Am I missing a setting? > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com