Re: Stored procs and transactions using Linux/PHP and Windows/MSSQL

Rick Emery wrote:

Is anyone using PHP5 on Linux to connect to MS SQL Server 2000 on Windows and execute stored procedures with output parameters within a transaction? If so, how? I'm trying to do something like this in the PHP application: begin transaction execute a stored procedure, receiving an identity back if certain conditions are met execute another stored procedure, getting an identity if certain other conditions are met execute another stored procedure, getting an identity if any of the above procedures fail rollback transaction else commit transaction

Can you do this in mssql (ie take php out of the picture) ? That is - if you execute a procedure, can you get the identity back? I have no idea about mssql but that would be my first check.. -- Postgresql & php tutorials http://www.designmagick.com/