Reg. M:M assoc., I think I figured out the problem area. It is not failing while trying to insert records in individual tables. These tables are already populated. The query exception is raised while select/insert into the 'mdlwr' glue table. "otherPK" is NOT set to the supplied argument. "mdlBizObj.mmAddToBoth(wrBizObj,"mdlmstid", '1', "wrmstid", '1')" It is set to default "None" value. In def mmAddToBoth(), print line is embedded as --- ======================== aux = self.AuxCursor sql = self._qMarkToParamPlaceholder("select * from %s where %s = ? and %s = ?" % (self._assocTable, self._assocPKColThis, self._assocPKColOther)) print "mmAddToBoth() SQL: %s, PARAMS: %s" % ( sql.decode(self.Encoding).replace("\n", " "), str((thisPK, otherPK))) sql.decode(self.Encoding).replace("\n", " "), str((thisPK, otherPK))) ======================== Output is--- mmAddToBoth() SQL: select * from mdlwr where mdlmstid = %s and wrmstid = %s, PARAMS: (1, None) SQL PARAMS select * from mdlwr where mdlmstid = %s and wrmstid = %s (1, None) SQL PARAMS insert into mdlwr (mdlmstid, wrmstid) values (%s, %s) (1, None) SQL PARAMS ROLLBACK None DBQueryException: (1048, "Column 'wrmstid' cannot be null") Any idea on how to solve this? Thanks, Vineet.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: Dabo-users@leafe.com 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/1317635164.46152.yahoomail...@web160503.mail.bf1.yahoo.com