My site used to work using cfhttp to find and convert and
uploaded csv file,
but an upgrade to Server 2003 killed it. I found the 'fix'
compression problem with 2003, but it didn't work for me.
I found a UDF that converts a csv to a query, but I don't
know how to
impliment it. I want to grab a csv from a folder and convert
it. The example
shows a csv being created using <cfsavecontent>. Can it
be used with a file?
If so, how can I point it to the csv file.
Here is the UDF:
var rowDelim = chr(10);
var colDelim = ",";
var numCols = 1;
var newQuery = QueryNew("");
var arrayCol = ArrayNew(1);
var i = 1;
var j = 1;
csvString = trim(csvString);
if(arrayLen(arguments) GE 2) rowDelim = arguments;
if(arrayLen(arguments) GE 3) colDelim = arguments;