[thelist] 8k Row limits must Go!

Jay Blanchard jay.blanchard at niicommunications.com
Thu Jul 11 06:55:01 CDT 2002


[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





More information about the thelist mailing list