[freetds] transactions using freetds and php

Ben Vogan benvogan at hotmail.com
Thu Jun 24 12:57:56 EDT 2010


Hi all,
This might be more of a PHP question that freetds but I thought I would try my luck here.  I was wondering what the proper way to use transactions from PHP talking to SQL Server 2008.  I tried:
mssql_query('BEGIN TRANSACTION');try {  loop {  //multiple inserts here  }  mssql_query('COMMIT TRANSACTION');} catch (Exception $ex) {  mssql_query('ROLLBACK TRANSACTION');}
However I get errors that there was no begin transaction.  Is this pattern possible in PHP or do I have to concatenate all my sql into one query (which would be very unfortunate)?
Thanks for your help,--Ben 		 	   		  
_________________________________________________________________
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969


More information about the FreeTDS mailing list