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
dtml-sqlvar does quoting of strings to aid in placing them in SQL queries. Use just <dtml-var resp> instead of <dtml-sqlvar ...> _______________________ Ron Bickers Logic Etc, Inc. rbickers@logicetc.com
-----Original Message----- From: gh@gowanus.com [mailto:gh@gowanus.com]On Behalf Of Gregory Haley Sent: Friday, July 07, 2000 11:36 AM To: Zope 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?
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 )
participants (3)
-
Gregory Haley -
Jim Sanford -
Ron Bickers