[Zope] RE: Insert Help

Dieter Maurer dieter@handshake.de
Tue, 26 Feb 2002 23:58:46 +0100


Todd Loomis writes:
 > I've did this and this is what the list looks like ['1', '2', '3'], when i 
 > submit it doesn't do 1 insert for each element
 > it just does one.
 > ...
 > <dtml-in options>
 > insert into UserRoles values (<dtml-sqlvar options type=string>)
 > <dtml-unless sequence-end><dtml-var delimiter></dtml-unless>
 > </dtml-in>
 > 
 > Can you make any other suggestions.... sorry for being pain just need some 
 > help!
Replace

     <dtml-sqlvar options type=string>
with 
     <dtml-sqlvar sequence-item type=string>

and

     <dtml-var delimiter>
with
     <dtml-var sql_delimiter>


Usually, I would say, you need to read something about the use
of "dtml-in" and to be more careful when instantiating examples.


Dieter