Re: [PHP-DB] Sigleton DB connection tripping on itself

2006-07-19 Thread Chris
Vandegrift, Ken wrote: Well, I have a situation where an Order object holds a collection of LineItem objects and of course they all use the same DB connection via a singleton. The Order object has a method that creates new LineItem objects from an ORDER_DTL table. Code snippet: // SET ORDER IT

Re: [PHP-DB] Sigleton DB connection tripping on itself

2006-07-18 Thread Chris
Vandegrift, Ken wrote: Good Day List, I have a singleton DB connection that I am trying to use throughout my application but It keeps tripping on itself. My main question is: If I am in the middle of a transaction can I prepare multiple statements eand execute them or will this cause an err

[PHP-DB] Sigleton DB connection tripping on itself

2006-07-18 Thread Vandegrift, Ken
Good Day List, I have a singleton DB connection that I am trying to use throughout my application but It keeps tripping on itself. My main question is: If I am in the middle of a transaction can I prepare multiple statements eand execute them or will this cause an error? Here is a code exampl