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

6 Apr 2000

      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