dabo Commit
Revision 5528
Date: 2009-11-14 19:01:55 -0800 (Sat, 14 Nov 2009)
Author: Ed
Trac: http://trac.dabodev.com/changeset/5528
Changed:
U trunk/dabo/db/dCursorMixin.py
Log:
Fixed some errors with my recent changes when saving a new record.
Diff:
Modified: trunk/dabo/db/dCursorMixin.py
===================================================================
--- trunk/dabo/db/dCursorMixin.py 2009-11-15 00:15:00 UTC (rev 5527)
+++ trunk/dabo/db/dCursorMixin.py 2009-11-15 03:01:55 UTC (rev 5528)
@@ -1363,7 +1363,7 @@
flds += ", " +
self.BackendObject.encloseNames(kk, aq)
# add value to expression
fieldType = [ds[1] for ds in
self.DataStructure if ds[0] == kk][0]
- vals.append(self.formatForQuery(vv[1],
fieldType))
+ vals.append(vv[1])
# Trim leading comma-space from the 'flds'
string
flds = flds[2:]
@@ -1374,9 +1374,9 @@
flds = self.KeyField
vals = "NULL"
nms =
self.BackendObject.encloseNames(self.Table, aq)
- sql = "insert into %s (%s) values (%s) " %
(nms, flds, self.BackendObject.paramPlaceholder)
+ placeHolders = len(vals) *
[self.BackendObject.paramPlaceholder]
+ sql = "insert into %s (%s) values (%s) " %
(nms, flds, ",".join(placeHolders))
params = tuple(vals)
-
else:
pkWhere = self.makePkWhere(row)
updClause, params = self.makeUpdClause(diff)
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]