freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
-
Boolean problem with 7.0,
Rodolphe Ode, 03/30/2001
- <Possible follow-up(s)>
- Re: Boolean problem with 7.0, Brian Bruns, 03/30/2001
- Re: Boolean problem with 7.0, Rodolphe Ode, 03/30/2001
- Re: Boolean problem with 7.0, Tim Uckun, 03/30/2001
Archive powered by MHonArc 2.6.24.