Re: [RDBO] Self-referential many-to-many relationships.

2006-05-17 Thread Michael Drozdov
That was quick! Thank you. -- Regards, Michael --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server

Re: [RDBO] Self-referential many-to-many relationships.

2006-05-17 Thread John Siracusa
On 5/17/06 4:52 PM, Michael Drozdov wrote: > In other words, it remembers the parent_id=26 generated by query (1), > and misses child_id=27, generated by query (4). This was a bug. It's fixed in SVN now, and the fix will go out in the next RDBO release. Thanks for the report! :) -John -

Re: [RDBO] Self-referential many-to-many relationships.

2006-05-17 Thread John Siracusa
On 5/17/06 4:52 PM, Michael Drozdov wrote: > On a minor note, > local $Rose::DB::Object::Debug = 1 > doesn't print query (2). That's because it uses the Manager to do that one. There are separate debug variables for the Manager and Object. Set both to see everything: local $Rose::DB::Objec

[RDBO] Self-referential many-to-many relationships.

2006-05-17 Thread Michael Drozdov
Hi; I'm following example discussed in http://sourceforge.net/mailarchive/forum.php?thread_id=9327291&forum_id=46239 Here is the code: (I'm using MySQL and Rose::DB::Object version 0.724) create table foo ( idint unsigned not null AUTO_INCREMENT PRIMARY KEY, name varchar(25

Re: [RDBO] Self-referential many-to-many relationships.

2005-12-27 Thread John Siracusa
On 12/27/05 8:27 AM, John Siracusa wrote: > On 12/27/05 8:22 AM, John Siracusa wrote: >> [a bunch of stuff that's not applicable to your situation] Actually, I was mostly right earlier. (No, really this time! :) You have a conflict in your FooParent class between the foreign key and column names

Re: [RDBO] Self-referential many-to-many relationships.

2005-12-27 Thread John Siracusa
On 12/27/05 8:22 AM, John Siracusa wrote: > [a bunch of stuff that's not applicable to your situation] Er, sorry about that. I misread your example. I'm in a rush this morning. I'll look at it again later and post something that's actually correct... :) -John ---

Re: [RDBO] Self-referential many-to-many relationships.

2005-12-27 Thread John Siracusa
On 12/26/05 10:20 PM, Daniel Pittman wrote: > The error I get on trying to load the object is: > > Cannot create method FooParent::child - method already exists at > /usr/share/perl5/Rose/DB/Object/Metadata/MethodMaker.pm line 379 > [...] > If anyone can point me to where I have gone wrong, or ev

[RDBO] Self-referential many-to-many relationships.

2005-12-26 Thread Daniel Pittman
G'day. I am just starting out with RDBO, having previously used Class::DBI a fair bit. I have a couple of questions... In my trial project I need to establish a (well, two, actually) self-referential many-to-many relationship on one of my tables. The table structure is trivial: create table fo