limit on the number of fields returned?
troy at psknet.com
Fri Nov 17 17:48:35 EST 2000
Found it. TDS seems to have a problem with numeric fields.
>From the SQL 7.0 books online:
decimal and numeric
Fixed precision and scale numeric data from -10^38 -1 through 10^38 -1.
A synonym for decimal.
a convert(char(10),field) works, but is less than ideal.
It's always a long day, 86400 doesn't fit into a short
> -----Original Message-----
> From: bounce-freetds-121575 at franklin.oit.unc.edu
> [mailto:bounce-freetds-121575 at franklin.oit.unc.edu]On Behalf Of Geoff
> Sent: Friday, November 17, 2000 4:18 AM
> To: TDS Development Group
> Subject: [freetds] Re: limit on the number of fields returned?
> "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
> > hang. If I enumerate the fields and limit the query to 40 or
> so columns,
> > 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
> 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.
> You are currently subscribed to freetds as: [troy at psknet.com]
> To unsubscribe, forward this message to
More information about the FreeTDS