On Sep 26, 2011, at 9:01 AM, Ed Leafe wrote:
> I think I know the problem - I used the SQLite param placeholder ('?'),
> whereas MySQL expects '%s'. I'll post a fix soon.
OK, if you can grab the latest trunk version of dCursorMixin.py and try
again, let me know how it works.
-- Ed Leafe
++++++++++++
I grabbed "dCursorMixin.py" from revision 6855 & ran the code (after putting
the "print "SQL", sql" & print "VAL", val in new file).
It gives the same traceback.
Here it is reproduced ----
f:\py\dabo\lib\SimpleCrypt.py:52: UserWarning: WARNING: SimpleCrypt is not
secure. Please see http://wiki.dabodev.com/SimpleCrypt for more information
warnings.warn("WARNING: SimpleCrypt is not secure. Please see
http://wiki.dabodev.com/SimpleCrypt for more information")
SQL select mdlmstid from mdlmst where mdlmstid = ?
VAL 1
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
File "f:\py\dabovmd\bo3.py", line 117, in <module>
mdlBizObj.mmAssociateValue(wrBizObj, 'wrmstnm', 'Scorpio Standard Warranty')
File "f:\py\dabo\biz\dBizobj.py", line 2113, in mmAssociateValue
assoc["cursor"].mmAssociateValue(otherField, otherVal)
File "f:\py\dabo\db\dCursorMixin.py", line 1169, in mmAssociateValue
return self.mmAddToBoth(self.KeyField, self.getPK(), otherField, otherVal)
File "f:\py\dabo\db\dCursorMixin.py", line 1255, in mmAddToBoth
thisPK = self.lookupPKWithAdd(thisField, thisVal, thisTable)
File "f:\py\dabo\db\dCursorMixin.py", line 1154, 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
---Vineet
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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]
