Re: Outputting a table/recordset to a csv

> What error are you getting? If any of the columns are numeric, you need
> [snip]

Thanks for all the info. The error message, BTW, was "not currently spooling". It didn't dawn on me for a bit that you had to create the .csv file for it first ;-) ASA did both, so it didn't cross my mind that Oracle wouldn't.

set feedback off pagesize 0 linesize 100 echo off termout off set heading on
spool C:\temp.csv;

select st_site_id || ',' || ow_owner_id || ',' || hsg_assessment_date from hsg146;

spool off;

was what worked in the end. Oh, and the other developer mentioned that I could have achieved the same thing using Scratchpad with it's Save Results button. That works well, plus allows for SELECT *.

Anyway, thanks for everyone's help.

--
Aidan Whitehall <aidanwhitehall_at_fairbanks.co.uk>
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775