I've never tried it, but would something like this work?

<@var name="request$yourArray" aprefix="" asuffix="" rprefix="insert into dbo.yourtable (row1, row2, row3, row4) values " rsuffix=")<@char 10>GO" cprefix="<@sq>" csuffix="<@sq>, ">



Brian Humes
Director, Interactive
JohnsonRauhoff Communications Group
269.428.9257 (Direct)
269.428.3377 (Main)
269.428.3312 (Fax)
www.johnson-rauhoff.com
[EMAIL PROTECTED]

_____________________________


On Jul 27, 2007, at 2:16 AM, Robert Garcia wrote:

You definitely can with a direct dbms.

--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Jul 26, 2007, at 8:56 PM, Fogelson, Steve wrote:

Is there a way to insert an array (multiple rows) into a table without using a loop?

The Witango action “Insert” implies that you can as it says “Insert the following rows into the table”.

Thanks

Steve Fogelson
Internet Commerce Solutions
_____________________________________________________________________ ___ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/ maillist.taf

______________________________________________________________________ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to