Paula: Please forgive me but how would i then run/execute the sql statements? Regards, Tood At 06:38 PM 2/26/2002 +0000, you wrote:
Hi,
I think that someone tell you before, but...
sql_statement_list = [] for elem in ['1', '2', '3']: sql.append("insert into table values ('"+elem+"')")
doing something like this, at the end, you have a list with the strings you want.
Result: ["insert into table values ('1')", "insert into table values ('2')", "insert into table values ('3')"]
I hop this help, Paula Mangas
On Tue, 26 Feb 2002, Todd Loomis wrote:
All:
I need to take the elements in the list ['1', '2', '3'] and make them separate SQL Statements:
insert into table values ('1') insert into table values ('2') insert into table values ('3')
how can i do this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis SAIC - DMSO Support 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis@dmso.mil
_______________________________________________ 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 )
-- ==================================================================== "Everything should be made as simple as possible, but not simpler" -- Albert Heinstein -------------------------------------------------------------------- Paula Mangas
e-mail: pamm@students.fct.unl.pt URL: http://students.fct.unl.pt/~pamm/ TMV: (+351) 96 2559034 ====================================================================