• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

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#')
0
midhelpdesk
Asked:
midhelpdesk
  • 3
  • 2
1 Solution
 
midhelpdeskAuthor Commented:
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
0
 
dgrafxCommented:
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 ...
0
 
midhelpdeskAuthor Commented:
Hi,
thanks for the comment. I have corrected this and it seems to work fine on my Internet Server. Running the app on the Internet server doesn't work. It's the oddest thing. My guess is permissions or some sort of mapping that is the issue?

I needed to move that server to 2012 so now is a good time. I expect that should resolve the issue. Will post after migration is finished.

thnx
-jes
0
 
dgrafxCommented:
hi
I'm just checking in to see if you got it working or if you needed additional help.

Thanks
0
 
midhelpdeskAuthor Commented:
Reloaded server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now