Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Nov 2007
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,852
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    Check you table, is there any character limit for the field in which you are storing the text?
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •