[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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