I tried this tag but it is NT only. Not Unix or Linux :-(
At 11:30 AM 2/16/01 -0500, Larry C. Lyons wrote:
>Paul,
>
>Have a look at Nate Weiss' custom CFX tag called CFX_CSVToQuery. You can
>get it from his website. Here's the direct URL:
>http://www.nateweiss.com/taggallery/CFXQueryColumns\CFX_QueryColumns.zip.
>He also has the documentation on-line for the tag:
>http://www.nateweiss.com/taggallery/CFX_CSVToQuery\CFX_CSVToQuery.html
>
>What I've found is that its somewhat faster than CFFile, and is fairly
>simple to use.
>
>hth,
>larry
>
>--
>Larry C. Lyons
>ColdFusion/Web Developer
>EBStor.com
>8870 Rixlew Lane, Suite 201
>Manassas, Virginia 20109-3795
>tel: (703) 393-7930 x253
>fax: (703) 393-2659
>http://www.ebstor.com
>http://www.pacel.com
>email: [EMAIL PROTECTED]
>
>Chaos, panic, and disorder - my work here is done.
>--
>
>Paul Sinclair wrote:
>>
>> I've been trying to figure out a method to suck the contents of a comma
>> delimited text file into a SQL database on an automated basis. Is there some
>> method of doing this via CF? I've looked in the devex for a tag but don't
>> see any.
>>
>> I'm getting a text file every night from an offsite source and each morning
>> I am manually importing the data to the db. I'm sure that CF can do this via
>> a cfm template that is run as a scheduled task but I haven't figured out how
>> to do it.
>>
>> Thanks for any help.
>>
>> Paul Sinclair
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
