Skip to Content.
Sympa Menu

freetds - Re: Boolean problem with 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rodolphe Ode" <rodolphe.ode AT eolas.fr>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Boolean problem with 7.0
  • Date: Fri, 30 Mar 2001 16:44:55 +0200


We use FreeTDS 0.51, furthermore, SQLServer 7 doesn't provide us with NBIT
type (only bit type is available).
The only trick we found is to convert the field in the request using :
"SELECT cast(BOOLEAN_COLONN as int) BOOLEAN_COLONN FROM myTable"


Rodolphe

----- Original Message -----
From: "Brian Bruns" <camber AT umcc.ais.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Friday, March 30, 2001 3:40 PM
Subject: [freetds] Re: Boolean problem with 7.0


> Hi,
>
> MS introduced a new bit type NBIT with 7.0, are you using the CVS version
or
> 0.51? I think it is fixed in CVS.
>
> Brian
>
> On Fri, 30 Mar 2001, Rodolphe Ode wrote:
>
> > Hi and thanx for your answer that helped me a lot (it works with large
VARCHARS). I have a new problem that didn't appear with FreeTDS 4.2
> > This problem is related to booleans, when I try to retrieve a value that
is in a boolean field from PHP (4.04).
> >
> >
> > example :
> > <?php echo $row[BOOLEAN_COLONN]; ?>
> > ............... does my server down
> >
> > <?php if ($row[BOOLEAN_COLONN]) {echo "true"; } else {echo false;} ?>
> > .............. always write 'true'
> >
> > thanks for help
> >
> >
> > Rodolphe Ode
> >
> >
> > ---
> > 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: [rodolphe.ode AT eolas.fr]
> To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page