Avatar of midhelpdesk
midhelpdesk
Flag for United States of America asked on

Saving Coldfusion Line Breaks and Returns

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#')
ColdFusion LanguageMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
midhelpdesk

8/22/2022 - Mon
midhelpdesk

ASKER
It seems to be something with my CFServer? I tested on my internet server and it works fine.
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
dgrafx

Well for one thing look what you have here:
<cfset Project_Description=replace("#FORM.Project_Justification#",chr(13)&chr(10),"<br />","all")>
You are adding BR tags to Project_Description NOT to form.Project_Justification!

Then you are inserting form.Project_Justification to the DB - You should be inserting Project_Description which is actually variables.Project_Description (I believe in scoping everything)
<cfquery name="Insert_Project" datasource="#application.dsn#">
INSERT INTO Capital_Projects
(Project_Justification)
VALUES (      '#FORM.Project_Justification#')

Also if still having issues you might want to check to see if your carriage returns ( chr(13) & chr(10) ) do exist in your form.Project_Justification ...
ASKER CERTIFIED SOLUTION
midhelpdesk

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
dgrafx

hi
I'm just checking in to see if you got it working or if you needed additional help.

Thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
midhelpdesk

ASKER
Reloaded server.