Hi
In the editor if I paste in say 3-4 pages of content from Word, save it to my db, and then try to log back in my application and show the saved data in the rich text control, it seems to get cut off. Its as if there is a restriction in how much text can be displayed. I tried this in IE6 and Firefox 2.x.
My code:
<cfmodule
template="/FCKeditor/fckeditor.cfm"
basePath="/FCKeditor/"
instanceName="answerText#currentRow#"
width="100%"
height="600"
value="#qAnswer.answer_text#">
Any help appreciated
Thanks
In the editor if I paste in say 3-4 pages of content from Word, save it to my db, and then try to log back in my application and show the saved data in the rich text control, it seems to get cut off. Its as if there is a restriction in how much text can be displayed. I tried this in IE6 and Firefox 2.x.
My code:
<cfmodule
template="/FCKeditor/fckeditor.cfm"
basePath="/FCKeditor/"
instanceName="answerText#currentRow#"
width="100%"
height="600"
value="#qAnswer.answer_text#">
Any help appreciated
Thanks
RE: Restriction on data length in text area??
RE: Restriction on data length in text area??
I am using NTEXT, this should not be a problem. The data gets saved, if I got into sql server, all i see in the column is <Long Text>, so I highly doubt its getting cut off during the save.
It seems to be an issue with the editor in displaying previously saved text. I am wondering is there a limit in the amount of text the editor can display when using the "value" attribute to populate the text control.
-Westside415
RE: Restriction on data length in text area??
From MS:
"The Microsoft SQL Server 2005 ntext, text, and image data types are capable of holding extremely large amounts of data, up to 2 GB, in a single value. A single data value is typically larger than can be retrieved by an application in one step; some values may be larger than the virtual memory available on the client. Therefore, special steps are usually needed to retrieve these values.
If an ntext, text, and image data value is no longer than a Unicode, 4,000 characters; character, 8,000 characters; or binary string, 8,000 bytes, the value can be referenced in SELECT, UPDATE, and INSERT statements much the same way as the smaller data types. For example, an ntext column with a short value can be referenced in a SELECT statement select list the same way an nvarchar column is referenced. Some restrictions that must be observed, such as not being able to directly reference an ntext, text, or image column in a WHERE clause. These columns can be included in a WHERE clause as parameters of a function that returns another data type, such as ISNULL, SUBSTRING or PATINDEX, or in an IS NULL, IS NOT NULL, or LIKE expression."
RE: Restriction on data length in text area??
It was in the CF Admin. There is a checkbox under datasource that allows you to retrieve long text. Otherwise if you don't check this box, there is a limit on what is retrieved.
-Westside415