transactions using freetds and php
Ben Vogan <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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