Re: [PHP] mysql_errror bug on innodb table
Great to hear. Reading my previous post, i am suprised you understood it with all the glaring spelling mistakes :-). Yikes. Sorry about that i typed it in too much of a hurry. [EMAIL PROTECTED] wrote: ok i managed to set the generated error screen to a variable, do the rollback then die H, The mysql_error() fucntion returns the error that took place for the last call to the db. If you do a roll back that would be considered another call and mysql_error() would then return the error (is any) associated with the roll back. If this reason many programmer create a separate error handling routing to watch of db errors and save them elsewhere all the best [EMAIL PROTECTED] wrote: hmm this is tricky, on an innodb table if i do a rollback when i find an error then trigger the error handler which dies to the screen it wont show the message, but i commented out the rollback and it was find, how could i execute the rollback properly then ? hi there i have noticed a bug where mysql_error is not returned on a transaction, why is this ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://www.radinks.com/upload Drag and Drop File Uploader. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://www.radinks.com/upload Drag and Drop File Uploader. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_errror bug on innodb table
ok i managed to set the generated error screen to a variable, do the rollback then die > H, > > The mysql_error() fucntion returns the error that took place for the > last call to the db. If you do a roll back that would be considered > another call and mysql_error() would then return the error (is any) > associated with the roll back. If this reason many programmer create a > separate error handling routing to watch of db errors and save them > elsewhere > > > all the best > > > > > [EMAIL PROTECTED] wrote: > >>hmm this is tricky, on an innodb table if i do a rollback when i find >>an error then trigger the error handler which dies to the screen it >>wont show the message, but i commented out the rollback and it was >>find, how could i execute the rollback properly then ? >> >> >> >>>hi there i have noticed a bug where mysql_error is not returned on a >>>transaction, why is this ? >>> >>>-- >>>PHP General Mailing List (http://www.php.net/) >>>To unsubscribe, visit: http://www.php.net/unsub.php >>> >>> >> >> >> > > > -- > http://www.radinks.com/upload > Drag and Drop File Uploader. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_errror bug on innodb table
H, The mysql_error() fucntion returns the error that took place for the last call to the db. If you do a roll back that would be considered another call and mysql_error() would then return the error (is any) associated with the roll back. If this reason many programmer create a separate error handling routing to watch of db errors and save them elsewhere all the best [EMAIL PROTECTED] wrote: hmm this is tricky, on an innodb table if i do a rollback when i find an error then trigger the error handler which dies to the screen it wont show the message, but i commented out the rollback and it was find, how could i execute the rollback properly then ? hi there i have noticed a bug where mysql_error is not returned on a transaction, why is this ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://www.radinks.com/upload Drag and Drop File Uploader. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_errror bug on innodb table
hmm this is tricky, on an innodb table if i do a rollback when i find an error then trigger the error handler which dies to the screen it wont show the message, but i commented out the rollback and it was find, how could i execute the rollback properly then ? > hi there i have noticed a bug where mysql_error is not returned on a > transaction, why is this ? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql_errror bug on innodb table
hi there i have noticed a bug where mysql_error is not returned on a transaction, why is this ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
