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

hawelek_tlen hawelek at tlen.pl
Tue Apr 6 15:53:24 EDT 2004

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,


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20040406/2c909f81/attachment.html

More information about the Zope-DB mailing list