On Fri, 2002-03-01 at 04:16, Dario Lopez-Kästen wrote: > I'd like to see ZSQL methods altered so that bind variables could be used in > SQL queries.
+1, even though MySQL doesn't bind variables (yet, apparently in the works for 4.0). Another thing I would like (and could probably write) is an additional skip_rows parameter (default 0) to Z SQL Methods to complement max_rows. Since this needs to be passed to the DA's query(), and no DA's currently accept this parameter, one of these things need to happen: 1) Trap the TypeError that results from calling a query() that doesn't recognize skip_rows (used as a keyword parameter). In that case, fall back to query(q, max_rows+skip_rows) and return result[skip_rows:] in the Z SQL Method. 2) Add a new DA method query_range(q, skip_rows, max_rows); if AttributeError, fall back like #1. 3) Simply require all DA's to implement it in query() as a keyword parameter to maintain backwards compatibility with older Zopes. Adding this would make Z SQL Methods work a bit more like <dtml-in ... start=skip_rows size=max_rows>. There may be issues with result caching, but I don't think it'll be too much of a problem. -- Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy You can have my keys when you pry them from my dead, cold neurons. _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )