limit on the number of fields returned?

Troy Settle 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
	decimal
	  Fixed precision and scale numeric data from -10^38 -1 through 10^38 -1.
	numeric
	  A synonym for decimal.

a convert(char(10),field) works, but is less than ideal.

--
  Troy Settle
  Pulaski Networks
  540.994.4254

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
> Winkless
> 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
> 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
>
>
> ---
> You are currently subscribed to freetds as: [troy at psknet.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
>




More information about the FreeTDS mailing list