I'd tend to go with an export from SQL server via DTS, but there's also a
custom tag out there we use for various data imports called CF_QueryToText.
I think it's still available at:
http://www.cfmcentral.com/gallery/detail.cfm?Script_ID=23
It's pretty easy to use too:
I'm not sure of it's l
Good point...
Jeff
> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 11, 2005 4:44 PM
> To: CF-Talk
> Subject: Re: Query to text file.
>
>
> Jeff Waris wrote:
> > project. DTS also seems like trying to kil
-
>> From: Paul Hastings [mailto:[EMAIL PROTECTED]
>> Sent: Monday, July 11, 2005 4:20 PM
>> To: CF-Talk
>> Subject: Re: Query to text file.
>>
>>
>> > What is the best way to dump a HUGE query to a text
>>file.
>>
>> the db itself?
&
Jeff Waris wrote:
> project. DTS also seems like trying to kill a fly with a sledgehammer. So I
> was hoping a more simple solution could be found for a plain text file dump.
considering your "fly" is choking your server to death, i think you're
looking at this the wrong way.
~~
dump.
Jeff
> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 11, 2005 4:20 PM
> To: CF-Talk
> Subject: Re: Query to text file.
>
>
> > What is the best way to dump a HUGE query to
> What is the best way to dump a HUGE query to a text file.
the db itself?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Messag
Did you tried to pass the Query Object to CFX using request and then loop
over the query using the Query object.. (both from com.allaire.cfx)
-Mensaje original-
De: Jeff Waris [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 11, 2005 3:18 PM
Para: CF-Talk
Asunto: Query to text file
What is the best way to dump a HUGE query to a text file.
There used to be a CFX tag long ago called CFX_dumptext that did this. This
doesn't work on MX6.1.
I have rolled my own with little success on extremely large queries. Each
works below on small queries just fine. In no particular order:
8 matches
Mail list logo