Re: retrieving only specified fields ?

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

On Thu, Jun 17, 2004 at 02:45:30PM +0300, raptor@xxxxxx.xxx wrote:
> To reiterate my question .... how to return only specified fields not all of them i.e. :
> 
> not : select * from blah
> 
> but : select field1, field2 from blah

I'm not sure what your are asking (in the context of Class::DBI). 

Using an example from the docs :

               package CD;
               use base 'Music::DBI';
               CD->table('cd');
               CD->columns(All => qw/cdid artist title year/);

If you then make an instance, for example 'cdid' 123, i.e. :

  my $cd = CD->new(123);

.... you could think of that (for the purposes of illustration) as :

  SELECT cdid, artist, title, year FROM cd WHERE cdid = '123'

However the point is that you don't need to care about what the SQL is
as Class::DBI handles that for you.

Please phrase your question in terms of the above example and we will be
able to be more help.

Colm