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:
<label class="textarea">
<span class="text1">Project Justification </span>
<cfif isdefined("URL.ID")>
<cftextarea name="Project_Justification" value="#Capital_Project.Project_Justification#"></cftextarea>
cfelse>
<cftextarea name="Project_Justification"></cftextarea>
</cfif>
</label>
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
(Project_Justification)
VALUES ( '#FORM.Project_Justification#')
Testing on my intranet server and it doesn't work.
Something with my intranet server configuration that isn't allowing it to work?? WTH? lol