ID: 20222 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: win 2k server SBS PHP Version: 4.2.3 New Comment:
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. >From that error I get the impression that one of your queries did not succeed. Please break this down to a simple script to reproduce this, and it will make debugging this a lot easier. Previous Comments: ------------------------------------------------------------------------ [2002-11-03 06:52:52] [EMAIL PROTECTED] here is the full error message: PHP Warning: mssql_free_result(): 18 is not a valid MS SQL-result resource in D:\Inetpub\d2b_devis\lib\dbutils.inc.php on line 335 here is the code on line 335: /* 334 */case "MSSQL": /* 335 */mssql_free_result($iResult); /* 336 */break; I don't understand why it works for ressource number 9,12 & 15, and for ressource number 18 I.ve got an error message. I've got also the same error message at different part of my program but with a different ressource number. For me it really seems to be link with PHP and not with somthing else. I hope I could help in the developpment of PHP, best regards. ------------------------------------------------------------------------ [2002-11-02 14:23:38] [EMAIL PROTECTED] Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Can you give us the full error message as well? ------------------------------------------------------------------------ [2002-11-02 13:46:05] [EMAIL PROTECTED] I 've got this warning for a query that works, I don't understand why. PHP Warning: mssql_free_result(): 18 is not a valid MS SQL-result resource in ... here the code: $strSQL = " SELECT REF_PRODUIT FROM PRODUITS WHERE ACTUEL = 1 AND REF_EDITEUR = '$pEditeur' AND REF_PRODUIT ='".$tabCol[0]."'"; $iQuery2 = dbQuery($iConnect, $strSQL) ; echo $iQuery2; dbFetch($iQuery2, $tabref); dbFreeResult($iQuery2); here the echo of iQuery2: Resource id #9 Resource id #12 Resource id #15 Resource id #18 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20222&edit=1