7 Jul
2000
7 Jul
'00
3:36 p.m.
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