Skip to Content.
Sympa Menu

freetds - [freetds] Freetds/php empty recordsets.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tim Uckun <tim AT diligence.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Freetds/php empty recordsets.
  • Date: Thu, 26 Jun 2003 11:21:17 -0600

Hello.

I recently upgraded both my php and freetds and now I get a strange behavior when I pull up empty recordsets.

when I pull up a empty recordset the following things occur.

1) the function mssql_query does not return a valid handle but instead returns a value of 1.
2) mssql_num_rows returns 0 (as expected).
3) mssql_num_fields also returns a 0 (which is bad).

If I pull up at least one record then the field information is returned OK and the query handle is OK.

I am using freebsd, freetds .61 and php 4.3.2

The recordset is pulled up via "select * from tablename where keyfield = -1"



:wq
Tim Uckun
US Investigations Services/Due Diligence
http://www.diligence.com/





Archive powered by MHonArc 2.6.24.

Top of Page