[Zope-DB] Dynamically generate sql-query in ZSQL Method
hawelek_tlen
hawelek at tlen.pl
Tue Apr 6 15:53:24 EDT 2004
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
-------------- 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