[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,

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

2006-11-23 Thread Jonathan
- Original Message - From: Andreas Tille [EMAIL PROTECTED] To: zope-db@zope.org Sent: Thursday, November 23, 2006 10:06 AM Subject: [Zope-DB] dtml-let variables in sql queries Hi, I have defined the following table CREATE TABLE names ( nameid int, name text, fake

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

2006-11-23 Thread Dieter Maurer
Andreas Tille wrote at 2006-11-23 16:06 +0100: Unfortunately dtml-let namepart=namepart + '%' does not seem to work transparently in the SQL-Method Right. ZSQL Methods take their parameters either from explicitly passed keyword arguments or from the request but not from the DTML