FreeTDS Development Group

["Zafer AYAZ" <zafer AT gazi.edu.tr>]

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  ....



----- Original Message -----
From: "Frediano Ziglio" <freddyz77 AT tin.it>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Thursday, September 12, 2002 10:40 PM
Subject: [freetds] Re: bit column problem


> Il gio, 2002-09-12 alle 08:27, Zafer AYAZ ha scritto:
> > hi,
> > i select same fields from a table on SQL2000.
> > i use redhat 7.3 + php 4.2.3 + SQL2000 + freetds 0.60
> > when i set tdsver=4.2 query return correct values.
> > but when i set tdsver=7.0 or 8.0,only bit columns returned empty values,
> > other fields normal returned.
> >
> > can i help me?...
> > Zafer
> >
> What compiler option do you use with php ?
> Can you give a small test ?
>
> freddy77
>
>
>
> ---
> You are currently subscribed to freetds as: [zafer AT gazi.edu.tr]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>