[thelist] 8k Row limits can Stay!

[Rob Smith]

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

I also changed the datatype to text (16)...

Holy Bajeezers!

I changed the sequence around on the requesting part and called the
FeatureBody last. I went from 1682 or so max words to 21,000 max words.
That's the difference in a 3 page article to 33 page article.

Muuuuch better!

Thanks

[snip]
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Anthony Baratta
>
> There is a "bug" with MS SQL and Text Fields. Any
> fields you call after a text field will not be
> available.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

fwiw, this must be a bug that only shows up when using mssql with asp.  i
just tested a project running on cf5 and mssql and the text field isn't the
last column in the select and it works fine.
[/snip]

It is a bug with M$SQL and ASP. The best way to handle this is the way that
Anthony mentioned before, selecting the text area last in the query. Another
method to handle this (it requires testing, but used it some time in the
past IIRC) is to do the query and then immediately place the data from the
query into a variable than can be called when needed. However, that requires
an extra step...I like Anthony's solution best.

Jay


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