Skip to Content.
Sympa Menu

freetds - [freetds] freeTDS - unixODBC - PHP - RowCount ...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "C.Lee Taylor" <leet AT leenx.co.za>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] freeTDS - unixODBC - PHP - RowCount ...
  • Date: Wed, 11 May 2005 09:57:53 +0200

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>




Archive powered by MHonArc 2.6.24.

Top of Page