I have an array generated nightly that has to be inserted into the database.
I have looked into actually writing the array to a file and then using the
Bulk Insert operation in SQL server, but I kept getting unexpected EOF
errors. The only problem I could think was that I was trying to read the
file over a networked drive eg, \\ns1\www..... instead of an actual mapped
drive like I have seen in all the examples.
jon
----- Original Message -----
From: "Michael She" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 18, 2000 10:20 PM
Subject: Re: Bulk Insert?
> You can write a custom tag to this for you, but inside the tag I belive
> it'll come down to looping over the array.
>
> BTW, are you trying to do a bulk load of data from another database/table?
>
> At 09:22 PM 12/18/00 -0500, Jon Hall you wrote:
>
> >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?
>
> --
> Michael She
> I m a g i n e C o m m u n i c a t i o n s
> Company E-mail: [EMAIL PROTECTED]
> Personal E-mail: [EMAIL PROTECTED]
> ICQ UIN: #243466
> Personal Homepage: http://www.michaelshe.com (Under Construction)
> Imagine Communications: http://www.imagineer.net
> PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
