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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to