[thelist] 8k Row limits must Go!

[Anthony Baratta]

>
>I'm building a CMS and part of it allows users to enter an technical
>article. Well the 8k limit is a hindering for the users cannot enter
>articles any longer than 1600 or so words, or about 3 (8.5" X 11") pages.
>Some of our technical articles extend beyond 14 pages.
>
>I do agree that the data type "text" does allow my users to enter data
>longer than that. However, when I go to retrieve that data into a
><textarea></textarea> for example, the info appears missing; nor can be
>displayed (asp 2.0) <%=article.fields.item(CMSFeatureBody).value%>.

Rob...

There is a "bug" with MS SQL and Text Fields. Any fields you call after a
text field will not be available.

e.g. Select FieldOne, TextField, FieldThree, FieldFour From TableName

FieldThree & FieldFour will not be available for some reason. You have to
change your SQL statement to this:

e.g. Select FieldOne, FieldThree, FieldFour, TextField From TableName

Therefore always call the Text Field last. If you have multiple text
fields, your screwed with multiple SQL calls.

Also, you should convert the text returned with the Server.HTMLEncode
function before throwing it to the browser. This should clean up any HTML
conflicts with quotes and stuff.
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."