CFFILE upload, CFEXECUTE a shell or Perl script that calls the BCP utility. Clumsy but
it will do the job.
At 03:21 PM 11/14/00 -0500, Zachary Bedell wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>> "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.
>
>It's definately an MS-SQL extension. I dunno what other RDBMS's out
>there also have it, but it's certainly not ANSI SQL.
>
>Good luck finding a functional alternative!
>
>Best regards,
>Zac Bedell
>
>========================================
>Zachary S. Bedell,
>Chief Technology Officer,
>Adirondack Technologies, Inc.
>
>Please include original message in any replies -- I get a
>lot of email every day, and I have a REALLY bad memory...
>So I don't always remember everything that was said.
>Thanks!
>
>-----BEGIN PGP SIGNATURE-----
>Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
>
>iQA/AwUBOhGey6vhLS1aWPxeEQJvWQCgqcDVttCVyghpeb1kQGFghrJW7vIAni3P
>95ow1jjf6ll1mpkzko2AWbEW
>=ewmq
>-----END PGP SIGNATURE-----
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]