freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...
- From: Mark Schaal <mark AT champ.tstonramp.com>
- To: freetds AT franklin.oit.unc.edu
- Subject: Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...
- Date: Thu, 2 Sep 1999 13:58:45 -0700 (PDT)
I'm working on money and smallmoney right now. Hopefully I'll have
patches for most of it by the end of today.
Mark
>
>
>
> not exactly sure what's happening.
>
> float works, but a column of type money doesn't.
> I always get 0.
>
>
> sqsh-1.7 linked with the freeTDS libs returns the right value.
>
> I did check for the "defined $_" issue from before.
>
>
> Note that the column I'm selecting against is in a view, rather than a
> table, but it shouldn't make any difference that I can see.
>
>
> SQL Server 6.5 SP5A, TDS ver = 4.2
>
>
> I haven't supped and built for a few days.
>
>
> TIMESTAMP values don't match isql at all, and in fact, seem a little
> clustered for valid values.
>
> timestamp: |0x00000001000ef41c|
> timestamp: |0x00000001000ef425|
> timestamp: |0x00000001000ef42f|
>
>
> >From isql:
>
> timestamp: 0x0000000100530d0a
> 0x000000010411f4ff
> 0x0000000104344371
>
> for the same columns.
>
> sqsh matches isql as well. So that probably means the problem is in
> DBD::Sybase.
>
>
> ---
> You are currently subscribed to freetds as: mark AT champ.tstonramp.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
--
Mark J. Schaal Phone: (909) 620-7724
TST On Ramp Fax: (909) 620-8174
System Administrator E-Mail: mark AT tstonramp.com
-
DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...,
Jaye Mathisen, 09/02/1999
- <Possible follow-up(s)>
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Michael Peppler, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Jaye Mathisen, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Mark Schaal, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Mark Schaal, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
Archive powered by MHonArc 2.6.24.