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

LVL 19
erikTsomikSystem Architect, CF programmer Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
_agx_Connect With a Mentor Commented:
Then your variable type and size should match.  Using a varchar (100) will likely truncate the string value to 100 characters.
0
 
_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
 
SidFishesCommented:
"varchar (100) will likely truncate "

no likely about it...it will ;)

(no pts for this plz)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.