Hello, I am trying to save a cftextarea to an MSSQL database with datatype VarChar for Project_Justification.
When I submit the form, the record is saved to the database but the line returns are lost, no BR tages are saved to the dB and they are lost when displaying.
I need to maintain the line returns when displaying the record as part of an edit field so my paragraphs are not bunched together....
My Input Form:
<span class="text1">Project Justification </span>
<cftextarea name="Project_Justification" value="#Capital_Project.Project_Justification#"></cftextarea>
My Input Query:
<cfset Project_Description=replace("#FORM.Project_Justification#",chr(13)&chr(10),"<br />","all")>
<cfquery name="Insert_Project" datasource="#application.dsn#">
INSERT INTO Capital_Projects
VALUES ( '#FORM.Project_Justification#')