PHP & MS SQL (odbc) integers get formatted

bakerville

I am developing a web interface against an existing MS SQL (2000) database.
When reading from integer fields (int (4)), the data is converted (formatted) into something that looks like a currency-formatted string.

Code extract:
$conn=odbc_connect( $SERVER, $USER, $PW);
$query1 = "SELECT id, persid FROM call_req";
$rs=odbc_exec($conn,$query1);

while ( $row = odbc_fetch_row($rs) )
{
print odbc_result($rs,1) . " - ";
print odbc_result($rs,2) . "<br>";
}

Results in (example):
400 800,00 - pcat:400800
400 801,00 - pcat:400801
...

id contains int(4) data, containing the numbers 400800 and 400801 for these two records, while persid is a varchar with "pcat:" + the same numbers added.

I am using Apache 2.0.58 and PHP 5.1.4 on Windwos XP against a MS 2003 Server with MS SQL 2000 installed.

Any suggestions how to get the numbers out with no "formatting"?

Btw, I also tried to add a WHERE statement:
"WHERE id=400800", but it didn't validate (ie give any rows as a result) through PHP, while the same SQL statement works fine in SQL Enterprise Manager.

Thorfinn (aka Bakerville)

bastien

it might be an issue with the odbc driver itself and you may not be able to fix this. you might want to look casting the data in the sql to a string that matches the format that you want

bakerville

Ii found that the ODBC driver worked just fine, by importing the same data into Excel.
In other words, it must have been the ODBC library of PHP 5.1.4 that is faulty, I see no other explanation, and there are no other links in the chain that I can see.

My solution was to skip the ODBC solution and use the mssql library functions of PHP instead. The only drawback was that I had to do all testing on the live server, since the network didn't permit SQL connections except via ODBC. With the mssql functions, I got the correct results, and all has worked well since.