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
