[PHP-DB] MS SQL Query From: LP (phplp <email protected>)
Date: 11/29/00

 I have the following query:

   set ROWCOUNT 10;select Poc,Zip,Email from company;

 If I run this query in the SQL Server Query analyzer it runs
 just fine.

 If I place this query inside the mssql_query and then do the
 following statement:

   print "RESULT :: [$result]\n";

 I get "1" but if I take out the "set ROWCOUNT 10;" the result
 is "Resource id #2".

 Why can't I place the "set ROWCOUNT 10;" inside of the query?

LP

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/ 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>