RE: Query to text file.

2005-07-12 Thread Jeremy Meerwarth
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

RE: Query to text file.

2005-07-11 Thread Jeff Waris
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

Re: Query to text file.

2005-07-11 Thread Lee
- >> 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? &

Re: Query to text file.

2005-07-11 Thread Paul Hastings
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. ~~

RE: Query to text file.

2005-07-11 Thread Jeff Waris
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

Re: Query to text file.

2005-07-11 Thread Paul Hastings
> 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

RE: Query to text file.

2005-07-11 Thread David Manriquez Farias
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

Query to text file.

2005-07-11 Thread Jeff Waris
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: