[Zope] Building SQL statements dynamically

Jon Erickson jon.erickson@neicoltech.org
13 May 2002 13:42:39 -0500


On Mon, 2002-05-13 at 06:40, Tille, Andreas wrote:
> 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?

If the dynamic queries are used to select data from the database you may
want to take a look at the <dtml-sqlgroup> tag.  You can create dynamic
queries with optional\required arguments based on user input.

http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.5.4.html

Jon