On Sep 26, 2011, at 11:33 AM, Vineet Deodhar wrote: > 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.
OK, looks like I missed that method. I just posted the fix, so grab that version and see if I missed anything else. -- Ed Leafe ================================== Again, after grabbing the updated dCursorMixin.py (& putting print "SQL ",sql print "VAL ",val after line 1141), In the second sql for other table, it is using mdlmstid (of first table), instead of wrmstid (of other table). SQL select mdlmstid from mdlmst where mdlmstid = %s VAL 1 SQL select mdlmstid from wrmst where wrmstid = %s 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, 'wrmstid', 1) File "f:\py\dabo\biz\dBizobj.py", line 2106, in mmAssociateValue assoc["cursor"].mmAssociateValue(otherField, otherVal) File "f:\py\dabo\db\dCursorMixin.py", line 1170, in mmAssociateValue return self.mmAddToBoth(self.KeyField, self.getPK(), otherField, otherVal) File "f:\py\dabo\db\dCursorMixin.py", line 1257, in mmAddToBoth otherPK = self.lookupPKWithAdd(otherField, otherVal, otherTable) 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: (1054, "Unknown column 'mdlmstid' in 'field list'") --- 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]
