[Zope] dtml-sqlvar quote

Tony McDonald tony.mcdonald@ncl.ac.uk
Fri, 20 Oct 2000 08:17:29 +0100


>
>Hi all
>
>How can i pass a string to a sql method that won't be quoted.
>
>i.e so i can do somthing like this
>
>.....
>group by foo,blah
>order by <dtml-sqlvar spam>
>
>
>thanks mark
> 

don't quote it?

...
order by <dtml-var spam>


I use this all the time for things like

select * from data where <dtml-var search_field> like '%<dtml-var search_term>%'

tone