just use <dtml-var ... instead of <dtml-sqlvar... ----- Original Message ----- From: Gregory Haley <ghaley@venaca.com> To: Zope <zope@zope.org> Sent: Friday, July 07, 2000 10:36 AM Subject: [Zope] Unquoting a string. Hi, I am trying to pass a column id through a ZMySQL method call. The thing looks like this: UPDATE venapoll SET <dtml-sqlvar resp type=string> = last_insert_id(+1) WHERE poll_num = 3; where resp is a value passed in by a dtml method and can have the value of resp0, resp1, resp3, etc. These are the names of columns. Zope is blowing chuncks, because the parsed call is actually: SET 'resp1' = last_insert_id(+1) and ZMySQL needs to have the value passed in as SET resp1 = . . . (i.e., without the quotes). Has anyone had a problem with this? TIA. ciao! greg. Gregory Haley venaca.com _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )