Skip to Content.
Sympa Menu

freetds - [freetds] mssql_fetch_row(): supplied argument is not a valid Sybase result

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Adrian Saileanu" <adrian AT smartcall.ro>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] mssql_fetch_row(): supplied argument is not a valid Sybase result
  • Date: Sun, 20 Jul 2003 13:46:25 +0300 (EEST)

Description:
------------
I updated my php to php-4.3.2 on apache_1.3.27, I have mysql-3.23.57 and
I also use freetds-0.61.
My php ./configure line is
'./configure' '--prefix=/usr/local/misc/php'
'--with-apxs=/usr/local/misc/apache/bin/apxs'
'--with-mysql=/usr/local/misc/mysql'
'--with-sybase-ct=/usr/local/misc/freetds'
All my scripts ( that before worked ) are giveing me the followig error
:
mssql_fetch_row(): supplied argument is not a valid Sybase result
resource

This error apears when no line maches the query !

In the first place I thought that is the freetds driver ... but I saw
that even on mysql i'm geting the same error.

Reproduce code:
---------------
$msdb = mssql_connect("192.168.0.5", "web","webpass");
mssql_select_db("DATABASE",$msdb);

$result = mssql_query("SELECT DEALERS.PASS FROM DEALERS WHERE
DEALERS.DEALER='" . $_POST["DealerName"] . "'", $msdb);

$msrow = mssql_fetch_row($result);

if ( $msrow[0] != $_POST["DealerPass"] )
{ mssql_close($msdb);
include("../include/error_message.html");
exit();
}

Expected result:
----------------

In $msrow[0] I should have the password ( I have the password when
$_POST["DealerName"] matches one of the DEALERS.DEALER from DEALERS )
but if $_POST["DealerName"] can't be found in the table I'm getting
Warning: mssql_result(): supplied argument is not a valid MySQL result
resource
I "echo("Result = ".$result);" and when I have a match I'm getting
"Result = Resource id #7" and when not a match I have "Result = 1". Is
this correct - don't should Result to be a resource also ? Before using
php 4.3.2 I didn't faced this problem !

Actual result:
--------------

Warning: mssql_fetch_row(): supplied argument is not a valid Sybase
result resource in /home/www/default/dealer/check_dealer.php on line 7




  • [freetds] mssql_fetch_row(): supplied argument is not a valid Sybase result, Adrian Saileanu, 07/20/2003

Archive powered by MHonArc 2.6.24.

Top of Page