Robert,
I looked at the MySQL syntax and am wondering if this is what you mean within the Direct DBMS: INSERT INTO Country ( Country_ID , Country_Name , Country_Disabled ) VALUES <@rows array="EResults" scope="request"> ( <@var request$EResults[<@currow>,Country_ID]> , <@var request$EResults[<@currow>,Country_Name]> , <@var request$EResults[<@currow>,Country_Disabled]> , ) </@rows> ; Thanks, Steve _____ From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 1:17 AM To: [email protected] Subject: Re: Witango-Talk: Inserting an array (multiple rows) into a table 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] <mailto:[EMAIL PROTECTED]> - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://bighead.net <http://bighead.net> / - http://eventpix.com <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 <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
