On Sep 23, 2011, at 9:18 AM, Vineet Deodhar wrote:
> File "f:\py\dabo\db\dCursorMixin.py", line 1142, in lookupPKWithAdd
> aux.execute(sql, (val,))
> File "f:\py\dabo\db\dCursorMixin.py", line 386, in execute
> raise dException.DBQueryException(errMsg)
> DBQueryException: not all arguments converted during string formatting
I'm at work now, and don't have the time to dig into this. But usually
that error means that the query has a parameter that isn't specified in the SQL
that is being run.
Unfortunately, I never added dbLogging to the MM code. I've created a
ticket (http://trac.dabodev.com/ticket/1421) for doing this, but in the
meantime, try this: in db/dCursorMixin.py, add the following lines:
1141 sql = "select %s from %s where %s = ?" % (self.KeyField, tbl,
field)
print "SQL", sql
print "VAL", val
1142 aux.execute(sql, (val,))
Re-run the code as you did before, and before the traceback you should
see the output from those two lines. Paste that in your reply.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
