[Zope] R: [Zope] What's wrong with this snippet?

[Marcel Preda]

_______________________________
"Will I be using Python today?"
 and if the answer is "yes"
 I know that it's going to be a good day.


----- Original Message -----
From: Marko MARKOVIC <marko.markovic@isp.lu>
To: <zope@zope.org>
Sent: Thursday, July 27, 2000 5:12 PM
Subject: [Zope] What's wrong with this snippet?


> hi all,
>
>
> i tried and searched to find the error but i couldn't solve it. Could anyone
> help me with this code:
>
> <dtml-in "GenericSQL(SQLStatement='SELECT
> ns.ns_ref,ns.ns_entrydate,ns.ns_status, ns.ns_name, ns.ns_adresse,
> ns.ns_location FROM noteservice ns WHERE (ns.ns_entrydate='%s/%s/%s' %
> (sentrydate[6:],sentrydate[3:5],sentrydate[:2])) ORDER BY ns.ns_entrydate
> desc')"  size=10 start=query_start>
>
>
> Where i can find infos about sql calls with dtml-in?

try something like

<dtml-let SQLStatement="'SELECT
 ns.ns_ref,ns.ns_entrydate,ns.ns_status, ns.ns_name, ns.ns_adresse,
 ns.ns_location FROM noteservice ns WHERE (ns.ns_entrydate=\'%s/%s/%s\' )
ORDER BY ns.ns_entrydate desc'  %
(sentrydate[6:],sentrydate[3:5],sentrydate[:2])">

<dtml-in "GenericSQL(SQLStatement)>
....


Dont forget about ESCAPE character: \
'.... \'%s%s%s%s\`...'

PM