Oracle has a similar function but to be honest I don't remember what it is.
FYI Here is a very basic call to the SQL server bulk insert
<cfset filepath = "absolute path to a file on the SQL server">
<cfquery dataSource="#someDSN#">
BULK INSERT someTableName FROM '#filePath#' WITH (FIELDTERMINATOR = ',')
</cfquery>
On 7/14/05, Roland Collins <[EMAIL PROTECTED]> wrote:
> Using the SQL BULK INSERT command or it's equivalent.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of [EMAIL PROTECTED]
> Sent: Thursday, July 14, 2005 1:00 PM
> To: [email protected]
> Subject: RE: [CFCDev] gateway CFCs
>
> How else can you do "bulk" insert/updates without doing a loop over a
> SQL Insert/Update statement?
>
> Tom
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Nando
> Sent: Thursday, July 14, 2005 12:29 AM
> To: [email protected]
> Subject: RE: [CFCDev] gateway CFCs
>
>
> >I think the problem we might be encountering is trying to map
> everything we
> do to a defined Pattern.
>
> Hmmm ... you know, if i had an app that did a lot of bulk updating and
> within the architecture, the DB handling object seemed like it just
> didn't
> fit in as either a DAO or a Gateway, i'd be willing to try making it an
> object in it's own right. Gridway, Grateway, GAO, an MDAO - at least i
> could
> try it and see if it fell into place nicely.
>
> It's My App - TM :)
>
>
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email to
> [email protected] with the words 'unsubscribe cfcdev' as the subject of
> the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
> (www.cfxhosting.com).
>
> CFCDev is supported by New Atlanta, makers of BlueDragon
> http://www.newatlanta.com/products/bluedragon/index.cfm
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[email protected]
>
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email to
> [email protected] with the words 'unsubscribe cfcdev' as the subject of the
> email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
> (www.cfxhosting.com).
>
> CFCDev is supported by New Atlanta, makers of BlueDragon
> http://www.newatlanta.com/products/bluedragon/index.cfm
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[email protected]
>
>
>
>
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email to
> [email protected] with the words 'unsubscribe cfcdev' as the subject of the
> email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
> (www.cfxhosting.com).
>
> CFCDev is supported by New Atlanta, makers of BlueDragon
> http://www.newatlanta.com/products/bluedragon/index.cfm
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[email protected]
>
>
>
--
[EMAIL PROTECTED]
http://blog.rawlinson.us
If you want Gmail - just ask.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
