[Zope] Building SQL statements dynamically

[Gilles Lenfant]

Hi,

Zope DAs have a "manage_test" method. The docstring says :

results =3D someDA.manage_test(query, REQUEST=3DNone)

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 -----=20
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,
:=20
: 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.
:=20
: Any hint how this can be performed using Zope?
:=20
: Kind regards
:=20
:          Andreas.
:=20
:=20
: _______________________________________________
: Zope maillist  -  Zope@zope.org
: http://lists.zope.org/mailman/listinfo/zope
: **   No cross posts or HTML encoding!  **
: (Related lists -=20
:  http://lists.zope.org/mailman/listinfo/zope-announce
:  http://lists.zope.org/mailman/listinfo/zope-dev )
:=20