[Zope-DB] Dynamically generate sql-query in ZSQL Method

Charlie Clark charlie at egenix.com
Wed Apr 7 08:50:02 EDT 2004


In addition to what Ian and Jim have written I'd like to point to my mail 
from yesterday on the same subject.

Regards

Charlie Clark

On 2004-04-06 at 21:53:24 [+0200], hawelek_tlen wrote:
> Hi,
> I'm beginner in Zope,
> I want to generate dynamically sql-query in ZSQL Method,
> exactly i want to give whole sql-query like parameter to ZSQL Method for 
> example in DTML Method,
> 
> for example I have clear ZSQL Method with id tempQuery and table Person 
> with fields 'id' and 'name'
> 
> I want to execute:
>     select * from person
> 
> so I tried something like this, but it doesn't work
> 
> <dtml-var standard_html_header>
> <dtml-in expr="tempQuery('select * from person')">
> <dtml-var id>
> </dtml-in name>
> <dtml-var standard_html_footer>
> 
> how can I do dynamic ZSQL Method?
>  
> thanks for help,
> 
> regards
> Adam
-- 
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-600-3657
GSM: +49-178-782-6226
-------------- next part --------------
An embedded message was scrubbed...
From: Charlie Clark <charlie at egenix.com>
Subject: [Zope-DB] Re: [egenix-users] Permission woes
Date: Tue, 06 Apr 2004 16:25:12 +0200
Size: 5923
Url: http://mail.zope.org/pipermail/zope-db/attachments/20040407/26ecb33a/Zope-DBRe_egenix-usersPermissionwoes_20040406162539_369-0001.mht


More information about the Zope-DB mailing list