Octavian Rasnita wrote:
my $uuu = $schema-resultset('User')-search({},{
prefetch = {blogs = 'blog_comments'},
select = ['me.id'],
as = ['user_id'],
});
print $uuu-first-username;
I know, but I would like to prefetch only just a few columns from the
joined tables, not all of them.
Even
Octavian Rasnita wrote:
From: iain iainhubb...@googlemail.com
my $uuu = $schema-resultset('User')-search({},{
prefetch = {blogs = 'blog_comments'},
select = ['me.id'],
as = ['user_id'],
});
print $uuu-first-username;
I think the single column that should be printed should be me.id,
From: Carl Johnstone dbixcl...@fadetoblack.me.uk
Octavian Rasnita wrote:
my $uuu = $schema-resultset('User')-search({},{
prefetch = {blogs = 'blog_comments'},
select = ['me.id'],
as = ['user_id'],
});
print $uuu-first-username;
I know, but I would like to prefetch only just a few columns from
Thomas L. Shinnick wrote:
I'm having some of the same questions regarding +select and +as . It
seems that using '+select' and '+as' does not stop other columns from
being returned. I'm using DBIC 0.08115.
What do you expect +select and +as to do??
+select
Indicates additional columns
From: Ronald J Kimball rkimball+dbixcl...@pangeamedia.com
Thomas L. Shinnick wrote:
I'm having some of the same questions regarding +select and +as . It
seems that using '+select' and '+as' does not stop other columns from
being returned. I'm using DBIC 0.08115.
What do you expect +select
my $uuu = $schema-resultset('User')-search({},{
prefetch = {blogs = 'blog_comments'},
select = ['me.id'],
as = ['user_id'],
});
print $uuu-first-username;
I think the single column that should be printed should be me.id, but
here is the generated SQL:
SELECT me.id, blogs.id, blogs.user,
From: iain iainhubb...@googlemail.com
my $uuu = $schema-resultset('User')-search({},{
prefetch = {blogs = 'blog_comments'},
select = ['me.id'],
as = ['user_id'],
});
print $uuu-first-username;
I think the single column that should be printed should be me.id, but
here is the generated SQL:
Trying again to forward to DBIC list, which rejected my previous try
at forwarding with additions...
From: Octavian Rasnita orasn...@gmail.com
To: The elegant MVC web framework catal...@lists.scsys.co.uk
Date: Sun, 17 Jan 2010 15:22:57 +0200
Subject: [Catalyst] Selecting from more tables (DBIC