Solved

textarea get truncated in coldfusion

Posted on 2007-12-06
4
678 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

747 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

13 Experts available now in Live!

Get 1:1 Help Now