FreeTDS Development Group

["C.Lee Taylor" <leet AT leenx.co.za>]

Greetings ...

	My first post, and a little off topic, but I don't wish to go a busier 
mail list without some understanding and real info ...

	I have a PHP developer, whom is write some nice web stuff for me, but 
is developing on Windows. ( I can't change that )

	Now the problem I'm having is that on Fedora Core 3, PHP does not seem 
to return the effected rows of a select statement.

	I don't think it's a freeTDS problem, but would like to just understand 
the problem.

	I have searched the internet, to look into this, and on the php site, I 
see that they state that RowCount in ODBC, is meant to be effected rows 
on insert, delete and update ... But as I have stated, this same code 
works on Windows ...

        Could I ask for some help with this problem.

Thanks
Mailed
Lee

P.S. isql and tsql seem to return the needed data, as one might be able 
to see in the below examples ...



isql CRM sa password
SQL> select TOP 10 * from logs; select @@Rowcount
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 10
10 rows fetched
+------------+
|            |
+------------+
| 10         |
+------------+
SQLRowCount returns 1
1 rows fetched
SQL>

tsql -S SQL-DEV -U sa -P password
1> use testCRM
2> select TOP 10 * from logs; select @@Rowcount
3> go
details to jacque       BRANCH  EAST RAND       NULL    NULL    NULL 
NULL   NULL     NULL    NULL    NULL    NULL    NULL    NULL    NULL 
NULL    NULL   NULL     NULL    NULL    NULL    NULL    NULL    NULL 
NULL    NULL    NULL   NULL     NULL    NULL    NULL

10
1>