FreeTDS Development Group

[Jamie Steffen <jamie_steffen AT csgsystems.com>]

The return results from a query of a field that is of type 'REAL' returns 0. 
I configured
using the --with-sybase option. Here is an example of the actual query that 
returns 0, the
only accurate return result is from the Date field which is of type 
'DATETIME'.

if($db->Query("select
date,last_sale,net_change,share_volume,high,low,previous_close,best_bid,best_ask
 from
stock where stock_id=1"))
 {
 
list($date,$last_sale,$net_change,$share_volume,$high,$low,$previous_close,$best_bid,$best_ask)=$db->GetRow();

 }

Jamie Steffen

Brian Bruns wrote:

> What exactly isn't working with REAL types? and are you using --with-sybase
> or --with-sybase-ct option during PHP's configure? Also if you can post a
> small script to demonstrate the problem?
>
> Brian
>
> On Wed, 22 Mar 2000, Jamie Steffen wrote:
>
> > We are querying the SQL server with PHP running on a TurboCluster/Apache 
> > web server.
> >
> > Jon Pounder wrote:
> >
> > > What exactly are you using as the client that wants the info from the
> > > database ?
> > >
> > > At 04:21 PM 3/22/00 -0600, you wrote:
> > > >Please excuse my lack of knowledge....
> > > >
> > > >Which ODBC driver would I need and is it something I can implement with
> > > FreeTDS in
> > > >place and functioning?
> > > >
> > > >Jon Pounder wrote:
> > > >
> > > >> you need to do type conversion to get that.
> > > >>
> > > >> The odbc driver we posted at library.freeodbc.org handles that if 
> > > >> you wish
> > > >> to download it.
> > > >>
> > > >> At 03:08 PM 3/22/00, you wrote:
> > > >> >Is there a way to get a query of type:real to return the correct 
> > > >> >results?
> > > >> >
> > > >> >---
> > > >> >You are currently subscribed to freetds as: pounder AT inline.net
> > > >> >To unsubscribe, forward this message to
> > > >> $subst('Email.Unsub')
> > > >> >
> > > >> >
> > > >>
> > > >>         Jon Pounder,   Development Engineer
> > > >>         Inline Internet Systems
> > > >>         pounder AT inline.net Jon AT Pounder.com
> > > >>
> > > >>         Web Tools Engineered for Success
> > > >>         http://www.inline.net
> > > >>         http://www.ihtml.com
> > > >>
> > > >>
> > > >>
> > > >> ---
> > > >> You are currently subscribed to freetds as: 
> > > >> jamie_steffen AT csgsystems.com
> > > >> To unsubscribe, forward this message to
> > > $subst('Email.Unsub')
> > > >
> > > >--
> > > >Jamie Steffen
> > > >x7798/jamie_steffen AT csgsystems.com
> > > >Web Administrator/CNS
> > > >CSG Systems, Inc.
> > > >
> > > >
> > > >
> > > >---
> > > >You are currently subscribed to freetds as: pounder AT inline.net
> > > >To unsubscribe, forward this message to
> > > $subst('Email.Unsub')
> > > >
> > > >
> > >
> > >         Jon Pounder,   Development Engineer
> > >         Inline Internet Systems
> > >         pounder AT inline.net Jon AT Pounder.com
> > >
> > >         Web Tools Engineered for Success
> > >         http://www.inline.net
> > >         http://www.ihtml.com
> > >
> > >
> > >
> > > ---
> > > You are currently subscribed to freetds as: jamie_steffen AT csgsystems.com
> > > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> > --
> > Jamie Steffen
> > x7798/jamie_steffen AT csgsystems.com
> > Web Administrator/CNS
> > CSG Systems, Inc.
> >
> >
> >
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> >
>
> ---
> You are currently subscribed to freetds as: jamie_steffen AT csgsystems.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
Jamie Steffen
x7798/jamie_steffen AT csgsystems.com
Web Administrator/CNS
CSG Systems, Inc.