taking a new line in a txt file

[damo2009]

Hi
I've created a text file from data in an SQL database, its putting all the text onto one line
I'm trying to output each field onto a new line, can anyone let me know what im missing,
heres the code im using:

<cffile action = "write"
file="Location of text file"
output = "
Number: #Test_Key#
UserName: #Test_UserName#
User Email: #Test_UserEmail#
Company: #Test_company# ">

Thanks

[damo2009]

#chr(13)# at the end of each line has done the job for me

[Adam Chrapkowski]

New line in a plain text is LF or CR LF. CR is a carriage (hex 0x0D, or "\r" for many programming languages ) return and LF is a line feed (hex 0x0A, or "\n" for many programming languages). Additional information can be found in the ASCII table. ASCII(8-bit) is a subset of Unicode so everything which refers to ASCII also refers to Unicode.

[Mittineague]

My Notepad++ editor has 3 settings for end of line conversions

Windows - CRLF
Unix - LF
Mac - CR

Normally not much of a problem except once when I was checking file hashes on my Windows localhost and my Linux site server.

"Identical" files (as far as I could see), but the EOL difference resulted in there being different hash values.