OK, thank you very much. In starting to do this, I've just done something similar to you - I put all the pertinent code in a single file (but not all the package info (mainly because I'm not sure how one can put all the package info in a single file)) and it works(!). I guess I've made some dumbass newbie style error somewhere. Anyway, I should now be able to easily isolate the problem in the main source, thanks very much.
Next stop, many_to_many relationship... James. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John > Siracusa > Sent: 19 September 2006 21:47 > To: Rose::DB::Object list > Subject: Re: [RDBO] Relationships - can't locate object method > > > I put the code you sent earlier into a test script and ran it. It > appeared to work for me. I don't actually have any db tables, but it > generated the expected SQL: > > # File: test.pl > [ all those class definitions you posted earlier ] > ... > local $Rose::DB::Object::Manager::Debug = 1; > my $books = > GARD::Book::Manager->get_books( > query => [title => { like => '%chess%' }], > require_objects => [ 'booktype' ]); > > I pointed it at an SQLite database and ran it: > > % perl ./test.pl > SELECT > t1.allgamesenteredby AS t1_allgamesenteredby, > t1.author AS t1_author, > t1.booktypecode AS t1_booktypecode, > t1.coverage AS t1_coverage, > t1.edition AS t1_edition, > t1.firstedpublished AS t1_firstedpublished, > t1.gamepages AS t1_gamepages, > t1.history AS t1_history, > t1.isbn AS t1_isbn, > t1.oldcomment AS t1_oldcomment, > t1.origpublished AS t1_origpublished, > t1.publisher AS t1_publisher, > t1.publishyear AS t1_publishyear, > t1.submittercode AS t1_submittercode, > t1.title AS t1_title, > t1.uid AS t1_uid, > t2.code AS t2_code, > t2.description AS t2_description, > t2.uid AS t2_uid > FROM > books t1, > booktypes t2 > WHERE > t1.title LIKE ? AND > t1.booktypecode = t2.code (%chess%) > DBD::SQLite::db prepare failed: no such table: books(1) at ... > > I think something else is going on here, but I'm not sure what. If > you can reduce it to a sample db schema and a perl script that can > reproduce the problem, package it all up and email it to me and I'll > debug it. > > -John > > -------------------------------------------------------------- > ----------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the > chance to share your > opinions on IT & business topics through brief surveys -- and > earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge &CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
