Here's the code used to process the file .. I get a listing of the files using CFDIRECTORY, then loop over that list of files with the following code, which is just before the tag that's driving me berserk now ....
<!--- read in the raw file as ftp'd in ---> <.CFFILE action="READ" file="#physpath##name#" variable="rawCSV"> <!--- Process the variable rawCSV to turn it into a DOS file, with CRLF ---> <.CFSET LF = chr(13)> <.CFSET CRLF = chr(10) & chr(13)> <.CFSET rawCSV = replace(rawCSV,LF,CRLF,"ALL")> <!--- Write the processed variable to a temporary file ---> <.CFFILE action="WRITE" file="#temppath#\temporary.csv" output="#rawCSV#"> -----Original Message----- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie-Subject: [cfaussie] RE: CFX_CSVToQuery tag just stopped working ... huh? Ok, we're getting somewhere now (slowly). Im pretty sure the tag doesnt like a completely empty row (i.e. 2 line breaks in a row). Can we see the line of code that fixes the line breaks in the inbound CSV? (the bit you commented out). I have a feeling the problem lies there. _______________________ James Silva --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
