BINGO! You were right, James, the problem was to do with the CRLF processing.
The change that worked, was your second one, and now my calculator is back on line. Thanks a lot for your patience and help. I owe ya. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Silva Sent: Friday, 28 February 2003 4:37 PM To: CFAussie Mailing List Subject: [cfaussie] RE: CFX_CSVToQuery tag just stopped working ... huh? In my code, i use a single chr(13) as the line terminator. Which, in theory, means that your initial CSV should work fine. Perhaps its comming through with a double chr(13) (or some other weird combination)... in which case, id try something like: <CFSET LF = chr(13) & chr(13)> <CFSET CRLF = chr(13)> <CFSET rawCSV = replace(rawCSV,LF,CRLF,"ALL")> while you're at it give this a go: <CFSET LF = chr(13) & chr(10)> <CFSET CRLF = chr(13)> <CFSET rawCSV = replace(rawCSV,LF,CRLF,"ALL")> and this: <CFSET LF = chr(10) & chr(13)> <CFSET CRLF = chr(13)> <CFSET rawCSV = replace(rawCSV,LF,CRLF,"ALL")> _______________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: www.gruden.com _______________________ --- 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/
