I'm generating a flat-file to be able to feed into another company's system parsed exactly how the SQL parses or formats it.
The old code used mainly cold fusion to generate and output the rows, but oracle is so much faster.
So I use Oracle to generate and output the data exactly how it's needed for the other company.
FYI.. with Oracle this 8MB file was generated in about 10 seconds.. as opposed to 20 minutes the old way.
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 1:37 PM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
I think he meant, in nice, columns etc...
remember, there are people who don't know everything on this list.
those who think they do, usually, don't...
tw
-----Original Message-----
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 1:37 PM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
[EMAIL PROTECTED] wrote:
> Yes but I need to dump the whole query formatted just how the sql query
> formats it.
This confuses me. The SQL query doesn't format the data at all, it just
returns the data in a query object.
- Rick
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
