[Catalyst] general question: catalyst syntax

[Will Smith]

I guess I have to rephrase my question:
  how can I get the array of cd_name of cd table when I have artistid (foreign key of artist table)
   
  something like in sql: select cd_name where artistid='...'
   
  thanks

Will Smith <willbelair at yahoo.com> wrote:
      hi, 
  I have a piece of code in the Controller : (cd table: cd_id, cd_name, artistid)
   
  my @mycd = music::M::CDBI::Cd->search(artistid => "${myartist_id}");
   
  when I access @mycd in the TT, the values returned are the cd_id only. 
  How can I access the cd_name, within the Controller (not in the TT),
  and in the TT
   
  thanks 

    
---------------------------------
  Yahoo! Music Unlimited - Access over 1 million songs. Try it free._______________________________________________
Catalyst mailing list
Catalyst at lists.rawmode.org
http://lists.rawmode.org/mailman/listinfo/catalyst
  


		
---------------------------------
 Yahoo! DSL Something to write home about. Just $16.99/mo. or less
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/catalyst/attachments/20051124/997d4305/attachment.htm