On Mon, Nov 26, 2012 at 10:08:07AM +, Jillian Rowe wrote:
> I was cutting and pasting from several logs, sorry about that. Lets start
> fresh.
>
> SQL statement:
>
> SELECT me.PID, qdem.qdem0006, qdem.qdem0007, qdem.qdem0008, qdem.qdem0009,
> qdem.qdem0010 FROM qpid me LEFT JOIN qdem qdem
Monday, November 26, 2012 12:16 PM
To: DBIx::Class user and developer list
Subject: Re: [Dbix-class] ResultClass::HashRefInflator skipping last column
on table joins
On Mon, Nov 26, 2012 at 08:31:31AM +, Jillian Rowe wrote:
>
> #for this particular case, sometimes this has an actual val
On Mon, Nov 26, 2012 at 08:31:31AM +, Jillian Rowe wrote:
>
> #for this particular case, sometimes this has an actual value
> $c->stash(WHERE => undef);
>
> $c->log->debug(Dumper($c->stash->{FIELDS}));
> $c->log->debug(Dumper($c->stash->{TABLES}));
>
> ##Gets me
> $c->stash->{FI
Well, for some background I am creating a reporter page where a user selects
the variables they want from different tables. Its being used for clinical
survey data, one database per study. I have many tables that all have the same
structure, one per survey, and one table that contains all patien
On Mon, Nov 26, 2012 at 07:15:33AM +, Jillian Rowe wrote:
> Hello all,
>
> I am having trouble using DBIx::ResultClass::HashRefInflator on a result set
> that has table joins.
What you stated in the subject line is not possible - you are
misdiagnosing your problem. Please provide *actual* se
Hello all,
I am having trouble using DBIx::ResultClass::HashRefInflator on a result set
that has table joins.
$c->stash(rs => $c->model(DB::TABLE1))
$rs = $c->stash->{rs};
$rs = $rs->search(
undef,
{
select => [COL1, TABLE2.COL2, TABLE2.COL3, TABLE2.COL4],
join => [TAB