I'm developing a site where people can submit ideas and other people
can rate them.
The problem is that when people rate the idea, the submission
timestamp on the idea gets updated as well and I have no idea why!
When a new idea is created I have the following method
public void awakeFromInsertion(EOEditingContext ec) {
setAvgRating(0.0);
setNumRatings(0);
setProposedStatus();
setSubmitDate(new NSTimestamp());
}
to set the default values as well as the submission timestamp. This
is the only method in my project that calls setSubmitDate!
However when I update or add a rating (which in turn updates the
AvgRating), the SubmitDate gets set to the current time. Below is my
SQL output from a simple update of a rating. It seems to be doing the
right thing, but the database and the app show new dates.
Any help would be greatly appreciated as I am stumped.
Thank you,
Tarun
(If you want to see this in action, go to http://
IdeasForABetterAmerica.org and create a user and change a rating on
an existing idea or comment. Don't worry.. I'm going to blow away all
the data as soon as I get closer to release.)
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.CATEGORY_NAME, t0.CATEGORY_OID,
t0.CATEGORY_ORDER FROM CATEGORY t0 ORDER BY t0.CATEGORY_ORDER ASC">
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 6 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.CATEGORY_NAME, t0.CATEGORY_OID,
t0.CATEGORY_ORDER FROM CATEGORY t0 ORDER BY t0.CATEGORY_ORDER ASC">
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 6 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "UPDATE IDEA SET AVGRATING = ? WHERE (IDEA_OID = ?
AND CATEGORY_OID = ? AND IDEADESC = ? AND IDEANAME = ? AND IDEAURL is
NULL AND NUMRATINGS = ? AND PARENT_OID is NULL AND STATUS = ? AND
USER_OID = ?)" withBindings: 1:-2.0(avgRating), 2:15(ideaOid), 3:5
(categoryOid), 4:"Hellow!!!"(ideaDesc), 5:"Test politics
entry"(ideaName), 6:1(numRatings), 7:"A"(status), 8:2(userOid)>
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "UPDATE IDEARATING SET RATING = ? WHERE
(IDEARATING_OID = ? AND IDEA_OID = ? AND RATING = ? AND USER_OID
= ?)" withBindings: 1:-2(rating), 2:10(ideaRatingOid), 3:15(ideaOid),
4:-4(rating), 5:1(userOid)>
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.AVGRATING, t0.CATEGORY_OID, t0.IDEADESC,
t0.IDEANAME, t0.IDEA_OID, t0.IDEAURL, t0.NUMRATINGS, t0.PARENT_OID,
t0.STATUS, t0.SUBMIT_DATE, t0.USER_OID FROM IDEA t0 WHERE t0.IDEA_OID
= ?" withBindings: 1:15(ideaOid)>
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 1 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.CATEGORY_NAME, t0.CATEGORY_OID,
t0.CATEGORY_ORDER FROM CATEGORY t0 ORDER BY t0.CATEGORY_ORDER ASC">
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 6 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.IDEA_OID, t0.IDEARATING_OID, t0.RATING,
t0.USER_OID FROM IDEARATING t0 WHERE t0.IDEARATING_OID = ?"
withBindings: 1:10(ideaRatingOid)>
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 1 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Begin Internal Transaction
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn
$MySQLExpression: "SELECT t0.AVGRATING, t0.CATEGORY_OID, t0.IDEADESC,
t0.IDEANAME, t0.IDEA_OID, t0.IDEAURL, t0.NUMRATINGS, t0.PARENT_OID,
t0.STATUS, t0.SUBMIT_DATE, t0.USER_OID FROM IDEA t0 WHERE
t0.PARENT_OID = ?" withBindings: 1:15(parentOid)>
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - 0 row(s) processed
Sep 26 23:03:19 Ideas[58094] (ERXNSLogLog4jBridge.java:44) DEBUG
NSLog - === Commit Internal Transaction
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
