I am very intrigued also, I think what he means is pass the entire array's
data as one string, delimited in some manner. Then use SQL server to parse
the string. This is one of those things that goes on my list of things to
play with when I get a chance.
While this may be looping, or maybe not. At least it's not looping over a
<cfquery> statement 50 times.
This whole idea of bulk inserting sounds like a great idea for a custom cfx
tag or even inclusion in a future version of CF...
jon
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 19, 2000 1:29 PM
Subject: RE: Bulk Insert?
> Ok, you have me intrigued. Are you talking about a PL/SQL procedure that
> takes the entire array and then parses it? Won't you be looping through
the
> array anyway?
>
> Brian
>
> -----Original Message-----
> From: Eric Barr [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 11:31 AM
> To: CF-Talk
> Subject: RE: Bulk Insert?
>
>
> Jon,
>
> You can get away with this in some situations through some clever
gymnastics
> in your sql.
>
> What it will come down to is passing a string into a stored procedure that
> you then do some string parsing and looping and use EXEC() (assuming your
> using SQL server). Althouhg procedding in this manor does impose some
> constraints: a lot of string manipulation in SQL is generally a bad idea,
> limit to the length of the string that can be passed in, etc...... But, I
> would try it out both ways and run some informal performance tests to
figure
> out which way fits your specific situation.
>
>
> -eric
> ------------------------------------------------
> If to please people we offer what we ourselves disapprove, how can we
> afterwards defend our work.
> -George Washington
>
> Eric Barr
> Zeff Design
> (p) 212.714.6390
> (f) 212.580.7181
>
>
> -----Original Message-----
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 18, 2000 9:23 PM
> To: CF-Talk
> Subject: Bulk Insert?
>
>
> I am wondering if anyone knows of any way to dump the entire contents of
an
> array into a table without having to loop over an insert query?
>
> jon
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
