[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