[Zope] dtml-in SQL, results display

hans hans@beehive.de
Wed, 10 Apr 2002 13:55:02 +0100


Alexander Batzios wrote:

>    Part 1.1    Type: Plain Text (text/plain)
>            Encoding: quoted-printable

usually i dont read attachments, especially if they contain long lines
which urge me to scroll hor

maybe i understand in wrong, but
a) "LIKE" operators AFAIK cannot be made w <dtml-sqltest ...>,
so you had to fall back to COLNAME LIKE %<dtml-var ...>%
(from the top of my head, syntax is most prbably wrong)
inserting the %-signs by slowhand.
for security, make sure your var doesnt contain apostrophs
b) prev/next: apart from http://www.zope.org/Members/michel/ZB,
there were examples in (needs some fiddling)
http://www.zope.org/Documentation/Guides/DTML-HTML/DTML.html

hans
-------------------------------------------------------------
Who's got only a hammer sees the world as a nail
hans augustin  (software developer)           hans@beehive.de
beehive elektronische medien GmbH       http://www.beehive.de
phone: +49 30 847-82 0                  fax: +49 30 847-82 299