[Zope-DB] dtml-let variables in sql queries

2006-11-23 Thread Andreas Tille
Hi, I have defined the following table CREATE TABLE names ( nameid int, name text, fake int ); INSERT INTO names values ( 1, 'Alfons',0 ); INSERT INTO names values ( 2, 'Alberto', 0 ); INSERT INTO names values ( 3, 'Adam', 0 ); INSERT INTO names values ( 4,

[Zope-DB] Re: dtml-let variables in sql queries

2006-11-23 Thread Andreas Tille
On Thu, 23 Nov 2006, Jonathan wrote: paramsname nameid /params SELECT * FROM names WHERE fake = 0 dtml-if name AND dtml-sqltest name op=like type=nb /dtml-if dtml-if nameid AND dtml-sqltest nameid op=eq type=int /dtml-if First off, i would highly recommend using python scripts instead of