Hi, Zope DAs have a "manage_test" method. The docstring says : results = someDA.manage_test(query, REQUEST=None) Executes the SQL in parameter query and returns results Note you must set the proxy to "manager" to a python script or DTML that executes this method. HTH --Gilles ----- Original Message ----- From: "Tille, Andreas" <TilleA@rki.de> To: "Zope user list" <zope@zope.org> Sent: Monday, May 13, 2002 1:40 PM Subject: [Zope] Building SQL statements dynamically : Hello, : : I have to port a complex database application which has no fix SQL : statements. The user builds the statement while interacting with : some menus and after having done some selections a database query : is builded depending from several options. : : Any hint how this can be performed using Zope? : : Kind regards : : Andreas. : : : _______________________________________________ : Zope maillist - Zope@zope.org : http://lists.zope.org/mailman/listinfo/zope : ** No cross posts or HTML encoding! ** : (Related lists - : http://lists.zope.org/mailman/listinfo/zope-announce : http://lists.zope.org/mailman/listinfo/zope-dev ) :