alternatively could the problem be before the data is put into mysql. basically we are using an extjs text area to collect data, that passes the data over to a form which we put straight in the database. should we be doing anything with that data such as escaping it?
> Hi, > > i have data stored in the database with a carriage return. however, > when coldfusion pulls the data out with cfquery it seems to lose the > carriage return, i dump out the query and it doesnt show the carriage > return. i tried looping through each character in the string and > outputting the ascii value and none show the character 13 for carriage > return > > does anyone know why this happens and how to get around it. > > thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm