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

textarea get truncated in coldfusion

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
erikTsomik
Asked:
erikTsomik
  • 2
1 Solution
 
_agx_Commented:
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
 
erikTsomikSystem Architect, CF programmer Author Commented:
I use text
0
 
_agx_Commented:
Then your variable type and size should match.  Using a varchar (100) will likely truncate the string value to 100 characters.
0
 
SidFishesCommented:
"varchar (100) will likely truncate "

no likely about it...it will ;)

(no pts for this plz)
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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