[Zope] How to pass parameters containing single quotes to ZSQL Methods?

[Jason Wong]

I want pass something like:

day='Monday'

to a ZSQL method using this

<dtml-in "qry_Controller_Info_List(_.None, _, criteria='day=''Monday''')">

As it stands it doesn't work, I get this error:

Error Type: sql.error
Error Value: ('07001', -3010, '[Microsoft][ODBC Microsoft Access 97 Driver]
Too few
parameters. Expected 1.')


tia
-
Jason Wong
Digital View Ltd
2201 Nanyang Plaza
57 Hung To Road
Kwun Tong
HONG KONG
Tel: +852-2861-3615
Fax: +852-2520-2987
www.digitalview.com