Re: INNODB and DataObjects

thats fine if i have to do a begin and commit thats fine, but rollback, how can this be triggered automatically on errors or something like thats, because thats the only time i'd need to use it ? On 20/04/2005, at 2:29 AM, Justin Patrin wrote:

On 4/18/05, Dan Rossi <pear@electroteque.org> wrote:

Me again, i think one of my issues is that the database on this one is using innodb transaction tables, i dont think the standard generator ran ok ? Should it be linking to the foreign keys ? Something is up ...

The DO generator doesn't handle foreign keys itself currently. This would be a great feature to have for the DBs that support it...patches welcome.

I also need to know how to include all the commit and rollback stuff, ie if there is an error rollback, is that setup ?

Not sure what you mean here. DB_DO doesn't do transaction stuff intrinsically. You can start / finish a transaction using $do->query('BEGIN'); $do->query('ROLLBACK'); $do->query('COMMIT'); however (I know this is in the manual somewhere...). -- Justin Patrin -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php