Also, if your Oracle table is multi-master replicated be sure to 'commit' after every insert or it will quesk (sp?).
BN
Brent Nicholas - EclecticDetroit, LLC. http://www.EclecticDetroit.com 248.767.5516 [EMAIL PROTECTED] [EMAIL PROTECTED]
"On the other hand, you have different fingers."
From: "Schreck, Tom" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [CFCDev] Upload Tab Delimited file
Date: Tue, 7 Dec 2004 10:14:39 -0600 MIME-Version: 1.0
Received: from cfczone.org ([69.43.131.101]) by mc3-f5.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 7 Dec 2004 08:15:15 -0800
Received: from a.mx.dresserinc.com [57.69.48.6] by nerve.mindtool.com (SMTPD32-7.15) id A7611057007C; Tue, 07 Dec 2004 08:16:33 -0800
Received: (qmail 7475 invoked from network); 7 Dec 2004 16:14:52 -0000
Received: from unknown (HELO dalexch3.DRESSER) (10.24.0.56) by a.mx.dresserinc.com with SMTP; 7 Dec 2004 16:14:52 -0000
Received: by dalexch3.DRESSER with Internet Mail Service (5.5.2657.72)id <WYTS9M2Q>; Tue, 7 Dec 2004 10:14:49 -0600
X-Message-Info: JGTYoYF78jH+ylw0ow1dn/rrrtma7KfQ
X-Mailer: Internet Mail Service (5.5.2657.72)
X-RBL-Warning: OSRELAY: Please stop using relays.osirusoft.com
X-Declude-Sender: [EMAIL PROTECTED] [57.69.48.6]
X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam.
X-Spam-Tests-Failed: OSRELAY [2]
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 07 Dec 2004 16:15:15.0197 (UTC) FILETIME=[EF953AD0:01C4DC77]
What's the best approach to uploading a tab delimited file using ColdFusion?
I'm working in an Oracle environment and I'm new to Oracle. So, for right
now I have to use ColdFusion. I am using <cfhttp> to turn file into a
recordset. I'm looping over the recordset and am doing an insert statement
for each record. This is timing out and seems overkill. Is there a way to
do a bulk insert from a recordset into a table?
Thanks - Tom
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at [EMAIL PROTECTED]
