Perhaps try one of these...? http://cflib.org/udf/CSVFormat http://cflib.org/udf/QueryToCsv http://cflib.org/udf/QueryToCSV2
On Mon, Jul 15, 2013 at 8:14 AM, Charles Shafer <[email protected]>wrote: > > 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:356189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
