freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
- To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
- Subject: Re: bit column problem
- Date: Fri, 13 Sep 2002 14:22:32 +0200
>
> I use this script:
>
> function getUser($Sicil){
>
> $strSQL = "SELECT p.Name,p.SurName,p.PasswdState FROM
> personel p WHERE
> (p.ID='$Sicil')";
> $results = mssql_query($strSQL);
> if ($row = mssql_fetch_array(mssql_query($strSQL))) {
> $user = new User();
> $user->Set("Name" ,$row[Name]);
> $user->Set("SurName" ,$row[SurName]);
> $user->Set("PasswdState" ,$row[PasswdState]);
> $user->Set("Error","0");
> }else{
> $user = new User();
> $user->Set("Error","User Not Found...(Error 103)");
> }
>
> return $user;
>
> }// End Function
>
> in "Personel" table Name, SurName as char 15,PasswdState bit columns.
> Name and SurName returns correct values but PasswdState
> return empty value
> (real value '1' in "Personel" table).
>
> Freetds 0.60rc2 installed this configure parameters:
> ./configure --with-tdsver=7.0 --enable-msdblib
>
> Php :
> ./configure --with-apxs --with-sybase=/usr/local/freetds ....
>
Current CVS should work. Or try --with-sybase-ct ...
freddy77
=================================
"STRICTLY PERSONAL AND CONFIDENTIAL
This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."
=================================
-
bit column problem,
Zafer AYAZ, 09/12/2002
- <Possible follow-up(s)>
- Re: bit column problem, Frediano Ziglio, 09/12/2002
- Re: bit column problem, Zafer AYAZ, 09/13/2002
- Re: bit column problem, ZIGLIO Frediano, 09/13/2002
Archive powered by MHonArc 2.6.24.