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