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
[EMAIL PROTECTED]

# -----Mensagem original-----
# De: Gaby [mailto:[EMAIL PROTECTED]]
# Enviada em: Friday, February 09, 2001 10:34 AM
# Para: Jorge Santos
# Cc: [EMAIL PROTECTED]
# 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 <[EMAIL PROTECTED]>
# To: Gaby <[EMAIL PROTECTED]>
# Cc: PHP-DB <[EMAIL PROTECTED]>
# 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
# > [EMAIL PROTECTED]
# > ----- Original Message -----
# > From: Gaby <[EMAIL PROTECTED]>
# > To: <[EMAIL PROTECTED]>
# > 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: [EMAIL PROTECTED]
# For additional commands, e-mail: [EMAIL PROTECTED]
# To contact the list administrators, e-mail: [EMAIL PROTECTED]
#
#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to