bit column problem
Zafer AYAZ
zafer at gazi.edu.tr
Fri Sep 13 09:39:44 EDT 2002
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')
>
More information about the FreeTDS
mailing list