[thelist] 8k Row limits must Go!

Paul Cowan evolt at funkwit.com
Wed Jul 10 18:23:01 CDT 2002


Jonathan McPherson wrote:
> I suspect that you can get around the text datatype bugs. There are
several
> workarounds available. Try this stuff:
> 1. Upgrade your MDAC, for starters.
> 2. Put your text fields as the last ones in both the query and the
physical
> table.
> 3. Query separately for your text fields and put the results in variables
> before using them.

4. Use disconnected recordsets, which don't seem to have that problem (and
   have other advantages too) (but also have other disadvantages).

Maybe this is what CF does...

Paul.




More information about the thelist mailing list