Skip to Content.
Sympa Menu

freetds - Re: limit on the number of fields returned?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Geoff Winkless" <geoff.winkless AT farmline.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: limit on the number of fields returned?
  • Date: Fri, 17 Nov 2000 09:18:21 -0000


"Troy Settle" <troy AT psknet.com> writes:
> select * from customer where id=1001
>
> This query works fine from Query Analyser, but causes both PHP3 and SQSH
to
> hang. If I enumerate the fields and limit the query to 40 or so columns,
it
> works fine.
>
> Can anyone shed some light on this? We really should be able to return a
> (near) infinate number of columns.

Is it the limit on the number or is it a specific field that causes the
problem?

When I first started using freetds any SQL Server datestamp (?) fields would
crash freetds - so doing select * wouldn't work, but selecting the fields I
wanted specifically -would- work.

Try selecting various fields, see if that crashes it.

Geoff





Archive powered by MHonArc 2.6.24.

Top of Page