MS SQL Query
| From: | LP | Date: | Wed, 29 Nov 2000 15:29:48 +0000 |
| Subject: | MS SQL Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4842@lists.php.net to get a copy of this message | ||
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/