Almost brings a tear to your eye doesnt it. The endless struggle of code and trying to work out why the hell its not working the way it should be.
Thats why I love this list, seeing people work together to solve a problem. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Kear Sent: Friday, February 28, 2003 5:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: CFX_CSVToQuery tag just stopped working ... huh? 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/ --- 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/
