I would like to do the following: if ynCompleteTask == "Y": taskCode = self.request.get('taskCode'); domainKey = users.get_current_user().email() + ":startTime" startedTime = memcache.get(domainKey); DebugText = "Complete Task" taskLogs = TaskLog.gql("SELECT * FROM TaskLog where taskCode = " + taskCode + " and workerEmail = :2 " + users.get_current_user ().email() + " and eventStartedDateTime = " + datetimeparse (startedTime)); #if len(taskLogs) <> 1: # DebugText = " Error: more than one matching row found " #else: # for taskLog in taskLogs: # taskLog1.eventStartedDateTime = datetime.datetime.now (); # taskLog1.put(); #save to BigTable database # DebugText = DebugText + " Updated Row "
The idea is to find a row that has been stored earlier, and update it. The row is identified by the user logged on, a task code, and the date/ time it was stored. I stored the date/time in memcache, and the admin viewer shows the following: "t...@example.com:startTime" is a pickled: datetime.datetime(2009, 5, 19, 19, 11, 36, 399000) Is "pickled" a Python term or a GAE term? I'm getting a 500 severe error on this line of code - whether or not I use the datetimeparse function: taskLogs = TaskLog.gql("SELECT * FROM TaskLog where taskCode = " + taskCode + " and workerEmail = :2 " + users.get_current_user ().email() + " and eventStartedDateTime = " + datetimeparse (startedTime)); Model is defined as follows: class TaskLog(db.Model): customerDomain = db.StringProperty() workerEmail = db.StringProperty() # db.UserProperty() taskCode = db.StringProperty() eventStartedDateTime = db.DateTimeProperty(auto_now=False) eventCompletedDateTime = db.DateTimeProperty(auto_now=False) resultFlag = db.IntegerProperty() issues = db.StringProperty(required=False) How can I match on the date/time that I have stored in memCache? Thanks in advance, Neal Walters --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---