RE: ADO Bulk Inserts

[Michael She]

Hi,


That is how I currently submit my statements, but can't I go:

Hi, that is how I execute my current statements.

But can't I submit multiple statements like:

"INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) 
VALUES(val1);"?

If I submit multiple statements I get a SQL error.



At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote:
>Have you try this:
>
>dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1,
>val2),(val1,val2),(val1,vla2);")
>
>JFernando
>** sql **
>
>-----Original Message-----
>From: Michael She [mailto:michael.she@stripped]
>Sent: December 10, 2002 12:08
>To: Fernando Grijalba
>Cc: MySQL Help
>Subject: RE: ADO Bulk Inserts
>
>
>Same table, but it shouldn't matter right?
>
>I'm getting a SQL syntax error once I start combining my statements
>together.  If I submit the statements separately they're OK.
>
>
>
>At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote:
> >Are the inserts to the same table or different tables and columns?
> >
> >JFernando
> >** sql **
> >
> >-----Original Message-----
> >From: Michael She [mailto:michael.she@stripped]
> >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  : michael.she@stripped
> >Mobile       : [phone]
> >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 <mysql-thread127036@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
> >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 <mysql-thread127109@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-michael.she=binaryio.com@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>--
>Michael She  : michael.she@stripped
>Mobile       : [phone]
>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 <mysql-thread127124@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
>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 <mysql-thread127130@stripped>
>To unsubscribe, e-mail 
><mysql-unsubscribe-michael.she=binaryio.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Michael She  : michael.she@stripped
Mobile       : [phone]
WWW Homepage : http://www.binaryio.com/