I wrote a UDF that does CSV, Excel, and TAB delimited file generation from a
query.
http://www.opensourcecf.com/1/2006/12/UDF-to-generate-File-Drops-in-CSV-Excel-and-Tab-delimited-formats.cfm
http://tinyurl.com/yuz8pu
~|
Rick,
This is exactly the kind of thing I am looking for.
But I get an error when it encounters a numeric field:
The selected method append was not found.
Any ideas?
On 2/5/07, Rick Root [EMAIL PROTECTED] wrote:
I wrote a UDF that does CSV, Excel, and TAB delimited file generation from a
I posted a response on the blog... haven't tested it though:
try changing lines 106 and 108 to the following:
output.append(FIELD.toString())
On 2/5/07, David Mineer [EMAIL PROTECTED] wrote:
Rick,
This is exactly the kind of thing I am looking for.
But I get an error when it encounters a
I saw that and also posted there. Changing those lines to the
following fixed the problem:
output.append(toString(FIELD))
On 2/5/07, Rick Root [EMAIL PROTECTED] wrote:
I posted a response on the blog... haven't tested it though:
try changing lines 106 and 108 to the following:
David Mineer wrote:
I have an app that uses DTS in MSSQL server to export records to a
..dbf file that is then emailed or made available to our clients.
Using DTS has never been ideal for me and now we are moving to a
hosted solution with workgroup edition of MSSQL which as I understand
it
If you're just trying to get a .csv file out, I've often done it using
CF, although, in a quick and dirty fashion this works just as well:
using query analyzer, write your query and run it. In the results
pane, select all, and copy. Open a new excel spreadsheet, and with
your cursor positioned in
I have an app that uses DTS in MSSQL server to export records to a
..dbf file that is then emailed or made available to our clients.
Using DTS has never been ideal for me and now we are moving to a
hosted solution with workgroup edition of MSSQL which as I understand
it doesn't have DTS
7 matches
Mail list logo