[Zope] sql-statements in DTML-Methods....
Jim Sanford
jsanford@atinucleus.com
Mon, 19 Jun 2000 08:50:14 -0500
For the most part all a ZSQL method does is used some specialized DTML
syntax to contruct a string that is your SQL query. You can create a ZQL
method, say "GenericSQL", that has 1 parameter, let's call it
"SQLStatement", whose sole DTML statement is "<dtml-var SQLStatement>".
To use it you would do this:
<dtml-in "GeneicSQL(SQLStatement='select * from the_table where the_var =
\'var_value\'')>
...
</dtml-in>
You can replace the literal string with a string variable like from a filed
on a form where you entered you SQL statement.
I use this method extensively.
Jim Sanford
----- Original Message -----
From: "Marc LUDWIG" <lutschi72@gmx.net>
To: <zope@zope.org>; <zope-dev@zope.org>
Sent: Sunday, June 18, 2000 3:08 PM
Subject: [Zope] sql-statements in DTML-Methods....
Hi.
This is one of the first times I'm working with Zope and databases.
Until now - if I wanted to work with a databse, i always created a Z SQL
method that I called from my DTML-method via
<dtml-call "add_item(param1 = ..., param2 = ..., param3 = ...,
..."> (for example)
or <dtml-in get_items> ... </dtml-in> (for example)
In the Z SQL method 'add_item' or 'get_items', my SQL statement are defined.
My question is now:
Do I have to define one Z SQL Method for every SQL statement I want to
perform on my database or is it possible to define SQL-statements and
database requests in my DTML-method?
Am I missing something? Any idea? Thanks a lot.
Regards, Marc
mailto:lutschi72@gmx.net
_______________________________________________
Zope maillist - Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )