freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Brian Bruns <camber AT ais.org>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: Timestamp fields.
- Date: Tue, 27 Feb 2001 17:02:22 -0500 (EST)
Quick question. Did you configure PHP --with-sybase or
--with-sybase-ct?
Brian
On Tue, 27 Feb 2001, Tim Uckun wrote:
> It seems that the timestamp fields are not fully supported by free tds and
> or php.
>
> the following query fails with "document contained no data" error
>
> select upsize_ts from tblclients where id=6657
>
> Both of these queries return a blank but at least it does not crash
>
> Select cast (upsize_ts as datetime) as TS from tblclients where id=6657
> Select cast (upsize_ts as varchar) as TS from tblclients where id=6657
>
> The following query also fails with Document contained no data error
>
> select * from tblClients where id = 657
>
>
> Using freetds cvs snapshot --with-tdsver=4.2 php4.04 and the sybase
> functions
>
> If I build tds with version 7.0 only the casting as varchar works casting
> as datetime causes a numeric overflow
>
> Also the bit fields still don't work properly with tdsver=7 both when bit
> fields are true.
>
-
Timestamp fields.,
Tim Uckun, 02/27/2001
- <Possible follow-up(s)>
- Re: Timestamp fields., Michael Peppler, 02/27/2001
- Re: Timestamp fields., G . Sumner Hayes, 02/27/2001
- Re: Timestamp fields., Tim Uckun, 02/27/2001
- Re: Timestamp fields., Brian Bruns, 02/27/2001
- Re: Timestamp fields., Tim Uckun, 02/27/2001
- Re: Timestamp fields., Brian Bruns, 02/27/2001
- Re: Timestamp fields., Westerdale, John, 02/27/2001
- Re: Timestamp fields., Brian Bruns, 02/27/2001
- Re: Timestamp fields., James Cameron, 02/27/2001
- Re: Timestamp fields., Brian Bruns, 02/27/2001
- Re: Timestamp fields., Tim Uckun, 02/28/2001
- Re: Timestamp fields., Brian Bruns, 02/28/2001
Archive powered by MHonArc 2.6.24.