FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Hmmmm....

I modified main.t to return some floats:

Fields: 2
Names: i f
Null:   
1 2.4
2 4.2
3 
ok 5

Number 3 there is 0.0, the non-zero numbers return properly...I don't
quite know whether that is correct (I don't think so)


Brian

On Thu, 26 Aug 1999, Jaye Mathisen wrote:

> 
> 
> OK, with sqsh-1.7, my query is now returning great info.  timestamp field
> came through OK, and the floats are correct.
> 
> DBD::Sybase doesn't like the floats though. Everything else including the
> timestamp came through, but I'm not so sure where the problem is, if it's
> still in the ctlib stuff, or really in DBD::Sybase.
> 
> Note the portion of the trace:
> 
>     <- FETCH= [ 'id' 'name' 'guarantor' 'taxrate' 'taxrate2' 'date'
> 'active' 'taxid' 'staffnum' 'timestamp' 'attn' 'addr1' 'addr2' '
> [...]
>     -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8145e7c)~INNER 'NAME')
>     -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8145e7c)~INNER 
> 'NULLABLE')
>     <- FETCH= [ '' 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
> 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ] at x.pl line 44.
>     -> fetchrow for DBD::Sybase::st (DBI::st=HASH(0x8057890)~0x8145e7c)
>     <- fetchrow= ( 10196 'Jaye Mathisen' 0 0 0 'Feb 05 1998 12:00AM' 'Y'
> [stuff deleted]
> 
> In the row data, the three fields after "Jaye Mathisen" has 0 0 0.
> 
> The first 0 is an int field, and it's correct.  But the next 2 fields are
> both floats.  I am unsure if the 0 there as opposed to 0.0 or somesuch is
> related to the problem.
> 
> I'm using DBI-1.13, with DBD::Sybase-0.19...  I think if I had my floats
> in DBD::Sybase, I'd be off to the races. :)
> 
> On Thu, 26 Aug 1999, Brian Bruns wrote:
> 
> > 
> > Ok, I've checked in the varbinary conversion stuff.  There shouldn't be
> > anymore of the 'Attempting to convert unknown source type xx' messages. If
> > you see any, let me know any I can patch it up in pretty short order.
> > 
> > You guys have been really great with the problem reports.  It makes my
> > life alot easier. :) 
> > 
> > Well I'm off to bed, g'night everyone
> > 
> > Brian
> > 
> > By the way, if anybody is looking for an easy task to sink their teeth
> > into, there is a lot of relatively easy but monotonous work to do in the
> > convert functions to go from one datatype to the others.  It's all in
> > src/tds/convert.c and the code should be pretty easy to follow.
> > 
> > 
> > 
> > ---
> > You are currently subscribed to freetds as: mrcpu AT internetcds.com
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> > 
> 
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>