I compiled my own version of PHP since i wanted to use MSSQL from my linux
box..
Everything works out great exept when i try to fetch an attribute which is
from the
type uniqueidentifier.. When i try to fetch this is segfaults the apache
child process..
Does anybody know how to solve this problem ?
This is the code is use to fetch the data (or to crash my apache 🙂 from the
database
(usr_uuid = the unique identifier field):
$db = mssql_connect("aitc03" , "webapp" , "appweb" ) or exit("connection
failed");
mssql_select_db("dev_iris") or exit("unknown database");
$query = "SELECT acc_app_ID,usr_namedisplay,app_name, usr_uuid " .
"FROM tbl_accounts,tbl_users,tbl_applications " .
"WHERE acc_usr_id = usr_id " .
" AND acc_app_id = app_id " .
" AND app_name = 'SAM' " .
"ORDER BY usr_namedisplay";
$result=mssql_query($query, $db) or exit("error");
while($line=mssql_fetch_array($result))
{
echo $line["usr_namedisplay"] . "(" . $line["app_name"] . ")<BR>\n";
}
mssql_close();
