RES: [PHP-DB] Join Sentences

dear gaby, mysql lacks rollback features. i believe the best way of handling long transactions is by array parameters, and commiting them to the database after positive flow is completed. hope it helps. rds mauricio portasio portasio@terra.com # -----Mensagem original----- # De: Gaby [mailto:gadame@atrivia.com] # Enviada em: Friday, February 09, 2001 10:34 AM # Para: Jorge Santos # Cc: php-db@lists.php.net # Assunto: RE: [PHP-DB] Join Sentences # # # No, I know how manage the functions .... I said for exemple : # # If I need insert or delete data in two tables, and one of them returns # error, the data stay inconsistent. I know that languages like Oracle have # sentences ROLLBACK, but I work in Mysql and I think this not works very # well. # # A acuse of it, I ask me if PHP can control this for a group of # sentences, in # other situations, like add un global array element, or similar. If the # function starts, modify this global variable, and after returns # error, it's # necessary rollback the actions made. # # You understand now ?? # # Thank you a lot. # # Gaby # http://www.atrivia.com # # # ----- Original Message ----- # From: Jorge Santos <santos@net-lynx.com> # To: Gaby <gadame@atrivia.com> # Cc: PHP-DB <php-db@lists.php.net> # Sent: Friday, February 09, 2001 2:17 PM # Subject: Re: [PHP-DB] Join Sentences # # # > Hi Gaby, # > # > Your best bet is to probably place the statements you want into a # function. # > Then, when the function is called if any one statement fails you simply # > return from the function with an error code. # > # > Hope this answer helps you... # > # > -------------------------- # > (No Espanol mas Portugues) # > O melhor a fazer e para por as declaracoes numa funcao. Depois quando # chamar # > a funcao, se alguma declaracao erra, regresse da funcao com um codico # > proprio. # > # > Espero que esta resposta lhe pode ajudar. # > # > Later, # > Jorge # > santos@net-lynx.com # > ----- Original Message ----- # > From: Gaby <gadame@atrivia.com> # > To: <php-db@lists.php.net> # > Sent: Friday, February 09, 2001 7:59 AM # > Subject: [PHP-DB] Join Sentences # > # > # > Hi, # > # > ( Excuse me for my english ) # > # > I wish execute in PHP some consecutives sentences , but if one of them # > returns un error, the program must'n execute anyone. I need one set of # > sentences that executes the code like one. # > # > I don't know if I explain ... Thanks a lot. # > --- # > Por si acaso alguien me entiende mejor en español : # > Lo que me gustaria es ejecutar un grupo de sentencias como si # fueran solo # > una # > # > # # # -- # PHP Database Mailing List (http://www.php.net/) # To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net # For additional commands, e-mail: php-db-help@lists.php.net # To contact the list administrators, e-mail: php-list-admin@lists.php.net # #