Helpful Information
 
 
Category: ColdFusion
Displaying Comments (text area form) from Database Issues

I am very new to ColdFusion. I'm actually a web designer, but my Boss has insisted that I learn how to do dynamic coding with Coldfusion.

I have very little knowledge of the programming language. All I know really know how to do is capture leads with Forms and what not.

The problem that I've ran into is on one of our sites I have created forms for each contact page and inquire pages to track our conversions with Google. I am savings all of the leads and putting them into a database also. The main problem is when I output the lead information to a web site the comments / questions Text Area doesn't display all of what the client entered into the text area. It stops displaying text once you go to the next line in the text area.

Example:

This is what the client entered into the text field:
"I AM VERY INTERESTED IN DOING A MAILER, HOWEVER I AM NOT SURE WHICH MAILER WOULD BE BEST FOR OUR DEALERSHIP"

This is what displays on the page that I created that outputs the lead info:
"I AM VERY INTERESTED IN DOING A MAILER, HOWEVER I"

I am not sure why this happens, and I thought one of you Elite coders would be able to help me out. I was reading into one of my coldfusions books and it mentioned something about #TRIM when uploading to a database...but I have no idea how that works.

Any help would be greatly appreciated. Also, if you know of any great Tools for learning Coldfusion that'd be awsome.

Thank you very much.

Check you table, is there any character limit for the field in which you are storing the text?










privacy (GDPR)