Re: retrieving only specified fields ?

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

On Thu, Jun 17, 2004 at 06:00:34PM +0300, raptor@xxxxxx.xxx wrote:
> if we have the setup u mentioned then i want to say :
> 
> my @cd = CD->retrieve_all();
> 
> to retrieve only fields "title, year" instead of all  "cdid, artist, title, year"
> for every row..
> And which column to retriewe should be dynamic f.e. pseudo code :
> 
> my @cd = CD->retrieve_all(qw(title year));
> my @cd = CD->retrieve_all(qw(cdid artist));
> my @cd = CD->retrieve_all(qw(artist title));
> 
> the same thing for search, shearch_where etc....

Can I ask why you can't just disregard the fields you don't want?
Surely the overheads associated with getting them and not using them are minimal?

Colm