Are the inserts to the same table or different tables and columns? JFernando ** sql **
-----Original Message----- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php