Skip to Content.
Sympa Menu

freetds - Problem with Transaction

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "THF" <thf AT cs.vabo.cz>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Problem with Transaction
  • Date: Tue, 12 Nov 2002 03:57:10 -0500


I have MS SQL 6.5 server on Win NT and FreeTDS 0.60 with Apache and PHP. I
try use transaction but I didnĀ“t work.
I try this (ex.):

//connect to DB
mssql_query("BEGIN TRAN",$db);
$res=mssql_query("select USER_ID from USERS where USER_ID > 10 and USER_ID
<15);
while ($rows=mssql_fetch_array($res)){
mssql_query("delete from USERS where USER_ID = $rows[USER_ID]);
}
mssql_query("COMMIT",$db);
mssql_close();

but It don't work.

I need use some transaction but I didn't know how?
Is there any, who use transaction with FreeTDS and MS SQL?




Archive powered by MHonArc 2.6.24.

Top of Page