Thanks for your answer. I'm relieved to know that the ZPT-ZSQL combination
will suffice for database accesses. As a Zope neophyte, though, I still
need an example or tutorial showing me how to get data from page to database
via ZPTs and ZSQL objects. Can you point me to such a reference?
- Thanks, Ken
> -----Original Message-----
> From: Andreas Jung [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 28, 2005 2:17 PM
> To: [EMAIL PROTECTED]; firstname.lastname@example.org
> Subject: Re: [Zope-DB] ZPTs and database accesses
> --On Donnerstag, 28. April 2005 14:05 Uhr -0400 Ken Winter
> <[EMAIL PROTECTED]> wrote:
> > The Zope Book (version 2.7,
> > http://www.plope.com/Books/2_7Edition/ZPT.stx#1-8) implies that you
> > do "SQL queries" from Zope Page Templates. If this implication is
> > correct, I (for one) have a problem, as I'm trying to do all my work
> > ZPTs (rather than DTML) in order to use my WYSIWYG HTML editor
> > (DreamWeaver) to design my pages.
> > The RDB chapter in the Zope book
> > (http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx#1-10)
> > shows a ZPT example that works for getting retrieved data from the
> > database through ZSQL objects onto web pages. But I haven't found an
> > example of a ZPT for an HTML form that can take data from the web page
> > into the database.
> You have not read the book correctly. First statement just said that you
> can't SQL queries using ZPT. In Zope you specify SQL queries using
> *ZSQL methods* that use DTML as markup language...this is not the same
> as defining SQL inside DTML methods/documents or Page Templates.
> Since ZSQL methods are first-class objects in Zope, you can call them
> of course from DTML method/documents, Python Scripts *and* Zope
> (as shown in the RDBMS chapter).
> Hope this makes things clearer,
Zope-DB mailing list