[thelist] 8k Row limits must Go!

[Rob Smith]

--
[ Picked text/plain from multipart/alternative ]

Hi Anthony,

(From Jonathan's message)
My MDAC's are version 2.61.7326.0. I know 2.7 is released. I did everything
else you said. However, I now want to display that information. I used your
Server.HTMLEncode suggestion and still haven't seen the correct results. I
tried this:

response.write Server.HTMLEncode(":" &
article.fields.item("CMSFeatureBody").value & ":")
Server.HTMLEncode(response.write (":" &
article.fields.item("CMSFeatureBody").value & ":"))
response.write Server.HTMLEncode(":" & FeatureBody & ":") 'FeatureBody
contains RecordSet value
response.write(FeatureBody)

my 21k words still doesn't show up...

TIA!

-----Original Message-----
From: Anthony Baratta [mailto:Anthony at Baratta.com]
Sent: Wednesday, July 10, 2002 3:46 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] 8k Row limits must Go!



>
>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."

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !