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
