Re: set_sql weird cache issues?

[prev] [thread] [next] [Date index for 2005/07/01]

On Tue, 2005-06-28 at 20:54 +0100, marshyon@xxxxx.xxx wrote:
> 
> in a parent class 'DBI.pm', I am setting sql:
> 
> __PACKAGE__->set_sql("big_join", "select c.name 'customer', p.name 'product', p.notes 'notes' from purchase_order po, product p, customer c where po.product = p.id and po.customer = c.id order by customer");
> 
> in my script I am accessing values of the above
> 
> my @things = MyApp::M::DBI::list->search_big_join();

What is the primary key of MyApp::M::DBI::list?  What columns did you
define for it?  How about showing us the code for that class?

- Perrin