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

2006-10-11 Thread Rick Emery
Quoting Chris <[EMAIL PROTECTED]>: 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 transact

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

2006-10-10 Thread Chris
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, receivi

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

2006-09-27 Thread Richard Lynch
On Wed, September 27, 2006 11:50 am, Rick Emery wrote: > Warning: mssql_query() [function.mssql-query]: Query failed in > /var/www/html/business/entity.php on line 127 > > which is: > mssql_query('RollBack Transaction'); Smush all of that into one line in Google, and see what you get... Oh, look:

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

2006-09-27 Thread Rick Emery
Quoting Richard Lynch <[EMAIL PROTECTED]>: On Wed, September 27, 2006 7:40 am, Rick Emery wrote: 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 proced

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

2006-09-27 Thread Richard Lynch
On Wed, September 27, 2006 7:40 am, 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? No, but... > I'm trying to do something like this in the PHP application: >

[PHP] Stored procs and transactions using Linux/PHP and Windows/MSSQL

2006-09-27 Thread Rick Emery
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 ba