Chris, You can't directly insert an array into a db table. You may be able to write the array out to a file and use a database IMPORT command to load it into a table. I doubt that the ODBC driver supports an IMPORT command but you might be able to call it from a stored procedure, external action or shell script. However the overhead of doing this may be such that it would be faster to loop through the array and do INSERTs, unless the array is very large.
Oh wait, you said 'an easy way'. OK never mind. Dave Shelley -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Millet Sent: Wednesday, December 18, 2002 10:42 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Inserting multiple records Is there an easy way to insert multiple records into a database without using a loop? It seems DirectDBMS would work since MySQL will insert many rows at a one time from other tables and files using the INSERT...SELECT statement, but I'm not certain how it would work using an array. Chris ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
