Re: Class::DBI::Set

[prev] [thread] [next] [Date index for 2004/06/28]

one approach would be using VIEW's..

> funny, i was just going to post a question along these lines.  i'm 
> wondering how i can setup CDBI so that i can do something like this:
> 
> my $Everything = Tracks->search_like(name => '%something') & 
> Artists->search_like(name => '%else')
> 
> so that $Everything will give me all the tracks that have a name like 
> '%something' that were made by artists with a name like '%else'.  how 
> are people doing this?  it's not so useful for me to just search on one 
> table.  Especially b/c i'd like to be able to this:
> 
> my $tracks = find_tracks(track_name => '%something', artist_name => 
> '$else');
> 
> steve