Solved

textarea get truncated in coldfusion

Posted on 2007-12-06
4
684 Views
Last Modified: 2013-12-24
In my form I build a texteditor with textarea in there. But i do have a problem here. When I click the update button the value of the textarea get truncated. In the backend I use the stored procedure to do the update
CREATE PROCEDURE [dbo].[updateProgramRequirements]  
@requirements varchar (100),
@prereq varchar (100),
@hidden integer,
@reqid integer
 
 AS
 
BEGIN
update  tablename set requirement=@requirements,req_prereq=@prereq  ,hidden=@hidden where reqid=@reqid
END
GO

Open in new window

0
Comment
Question by:erikTsomik
  • 2
4 Comments
 
LVL 52

Expert Comment

by:_agx_
ID: 20422109
What is the length of the text in the textarea? You may need to increase the variable and column sizes if the allowable text length is longer than a varchar (100).
0
 
LVL 19

Author Comment

by:erikTsomik
ID: 20422122
I use text
0
 
LVL 52

Accepted Solution

by:
_agx_ earned 125 total points
ID: 20422155
Then your variable type and size should match.  Using a varchar (100) will likely truncate the string value to 100 characters.
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 20422192
"varchar (100) will likely truncate "

no likely about it...it will ;)

(no pts for this plz)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now