[prev in list] [next in list] [prev in thread] [next in thread]
List: freetds
Subject: [freetds] Timestamp fields.
From: Tim Uckun <tim () diligence ! com>
Date: 2001-02-27 18:31:28
[Download RAW message or body]
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.
:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.
---
You are currently subscribed to freetds as: [freetds@progressive-comp.com]
To unsubscribe, forward this message to leave-freetds-113879Q@franklin.oit.unc.edu
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic