[Zope] Convert Help

[Smith, Neil]

It sounds to me like you want a ZSQL method that contains code something
like:

Argument myList:list:int

Code:
<dtml-if myList>
	<dtml-in myList>
		<dtml-if "_['sequence-item']">
			insert into myTable 
			values (<dtml-var "_['sequence-item']">)
			<dtml-var sql_delimiter>
		</dtml-if>
	</dtml-in>
</dtml-if>

Neil

-----Original Message-----
From: Todd Loomis [mailto:tloomis@dmso.mil]
Sent: 26 February 2002 18:26
To: zope@zope.org
Subject: [Zope] Convert Help


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



**********************************************************************
 
The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it.
    
If you have received this e-mail in error, please notify postmaster@npower.com (UK 01384 275454) and delete it immediately from your system.
    
Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.

Npower Limited
Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277

This e-mail may be sent on behalf of a member of the Innogy plc group of companies.

**********************************************************************