PHP :: Bug #18928 :: mssql_num

[2002-08-15 17:40 UTC] matthius at u dot washington dot edu

Using MSSQL 2000

The function mssql_num_rows generates the following 
warning: 

Warning: mssql_num_rows(): supplied argument is not a valid 
MS SQL-result resource

At the advice of the documentation I tried making the 
following query:

			$query2 = 'SELECT @@ROWCOUNT';

			$result2 = mssql_query($query2);

			list($affected) = mssql_fetch_row($result2);

			echo($affected);

This generates the following error:

Warning: MS SQL: Query failed

All other queries work fine I can interact with the 
database. I have also tried the latest stable build on 
snaps.php.net as of today 8-15-02 the problem remains 
unchanged.

Any help would be greatly appreciated.

Thanks!
Matt

[2002-08-15 18:24 UTC] kalowsky@php.net

I'm not a MSSQL user, so I don't know the specifics of that query string.  But if the query fails, of course you'll receive this error message from MSSQL.... the result set isn't populated, thus there is nothing to retrieve. 

Unless you can show this error message to work with a valid SQL query, I'm going to mark this as Bogus.  If you can, you're welcome to re-open the bug and add this new information.

[2002-08-15 19:18 UTC] matthius at u dot washington dot edu

Sorry for not including that detail. Please let me clarify, 
the actuall query IS valid and it does succeed. It affects 
about 3300 rows. I am pasting my code snippet:

// above is DB connection stuff, all goes well

	$query = '	DECLARE @Ident int
				
				INSERT INTO LastMod (lastModBy, lastModDate)
				VALUES ("Matt - Email Import Test", GETDATE())
				
				SET @Ident = @@IDENTITY
				
				-- insert primary email
				INSERT INTO EmailAdd (personID, address, emailAddType, 
lastModID) 
				SELECT newID, Col017, "primary", @Ident 
				FROM fmFullExport	
				WHERE Col017 != ""	AND Col002 LIKE "%_%" AND COL003 
LIKE "%_%"
										
			 ';				
				
	// execute query
	$result = mssql_query($query);	
	mssql_num_rows($result);
	
// it dies on that last line
	

This is the error message it generates:

Warning: mssql_num_rows(): supplied argument is not a valid 
MS SQL-result resource in 
c:\inetpub\wwwroot\DBclass\index.php on line 36

[2002-08-15 19:41 UTC] kalowsky@php.net

does this happen with a very simple SELECT query, that returns one row?

[2002-09-21 01:54 UTC] sniper@php.net

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

Patches

Pull Requests

History

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2023 The PHP Group All rights reserved.	Last updated: Mon Mar 27 20:03:38 2023 UTC