php-db | 2001062

Re: [PHP-DB] sybase function for MS-SQL Server From: Frank M. Kromann (frank <email protected>)
Date: 06/30/01

Hi,

> Query Analyzer" perfectly.
> e.g.
> SP1: (works)
> CREATE PROCEDURE SP1 AS
> insert into mytable values(...)
> select * from mytable

Only one result set.

>
> SP2: (doesn't work)
> CREATE PROCEDURE SP2 AS
> select * from mytable
> select * from mytable

Two result sets

>
> SP3: (doesn't work)
> CREATE PROCEDURE SP3 AS
> insert into mytable values(...)
> insert into mytable values(...)

Two results.

The sybase extension is not written to handle multiple results in a single query. I have writteh the code for this in the MSSQL extension, but so far this extension is only available on Windows.

- Frank 

-- 
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>