Why do you have to do it that way?

Could you do it in a loop?

Do Until rst.EOF
        dbConn.Execute("INSERT STATMENT");
Loop

JFernando
** sql **

-----Original Message-----
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 10, 2002 13:55
To: Fernando Grijalba
Cc: MySQL Help
Subject: RE: ADO Bulk Inserts


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:[EMAIL PROTECTED]]
>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:[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
>
>--
>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

--
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

Reply via email to