[Zope-dev] parameterised SQL methods, anyone?

Anthony Baxter anthony@interlink.com.au
Thu, 25 Mar 1999 00:36:07 +1100


Has anyone thought about extending the existing SQL Methods 
to support parameterised methods? Eg

INSERT INTO foo ( cola, colb, colc ) VALUES ( :1, :2, :3 ) 

and providing attributes in the method to supply :1, :2, :3 &c.

In databases which cache parsed SQL, this makes an enormous
difference in performance...

Anthony