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]

Reply via email to