"BULK INSERT"; Is that a SQL Server only thing?
I could really use that... but I'm using Sybase on Linux which has a command line tool
(BCP) but I never heard of a SQL statement to do bulk inserts.
At 07:05 AM 11/14/00 -0800, paul smith wrote:
>The BULK INSERT is not carried out if I CFINCLUDE the following into a
>template:
>
><!--- Read raw data from file --->
><cfquery name="bulkin" datasource="golfdata" username="" password="">
>BULK INSERT MarketUpdate
>FROM 'D:\website\htdocs\stockgolf\htdocs\data\eod.txt'
>WITH
>(
>FIELDTERMINATOR=',',
>ROWTERMINATOR='
>'
>)
></cfquery>
>
>But THE SAME Bulk Insert as above works if I do it from Query Analyzer.
>
>Any suggestions would be appreciated.
>
>best, paul
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
