Solved

textarea get truncated in coldfusion

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

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Application launch issue with Apache Tomcat 5 23
CSS HELP 6 84
whm high memory usage in processes 7 70
Public IP Address Amazon Servers 2 44
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…
Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. 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 :…
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…

867 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

16 Experts available now in Live!

Get 1:1 Help Now