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  -  [EMAIL PROTECTED]
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 )

Reply via email to