CF_QueryToText Output String

[hofar...@houseoffusion.com]

Excuse the vague subject, I didn't how to articulate it properly. My question is though I have been using the CF_QueryToText tag for some time now with great success, something now has come up that I cannot debug. The data has a character length of 15 in the table but the .csv output is appending a "0" to the end of the string making its LEN 16. Ex. in the field I have 123456712345678, but in the .csv file, that has changed to 1234567123456780. The records contain other fields with data varying in length and of Numeric, or Alpha/Numeric values and they translate accurately to the .csv but date lengths are below 15 characters. My db is SQL 2008, data type is nvarchar(50). Can anyone other any insight to the .csv is appending a 0 to the end of the string?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356185

[hofar...@houseoffusion.com]

Perhaps try one of these...?

http://cflib.org/udf/CSVFormat
http://cflib.org/udf/QueryToCsv
http://cflib.org/udf/QueryToCSV2

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356189