[Zope] Unquoting a string.

[Jim Sanford]

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 )