[ic] $db-->query inner join
Gert van der Spoel
gert at 3edge.com
Tue Mar 10 15:34:04 UTC 2009
> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> users-bounces at icdevgroup.org] On Behalf Of Sam Batschelet
> Sent: Tuesday, March 10, 2009 6:31 PM
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] $db-->query inner join
>
>
>
>
> On 3/10/09 10:14 AM, "jimbo" <jimbo at soundimages.co.uk> wrote:
>
> >> my $q = $db->query({
> >>
> >> sql => 'SELECT sum(quantity) FROM inventory INNER JOIN variants
> WHERE
> >> inventory.sku = variants.code and variants.sku=$sku',
> >>
> >> });
> >
> > Did you make sure to open the tables in the [perl] tag?
> >
> > [perl tables="inventory variants"][/perl]
> >
> > jimbo
> > ;-)>
> >
> I did it this way is this wrong? I am trying to not use ITL in this
> script
> if possible.
>
> my $db = $db{inventory, variants};
Well regardless of anything else : $db is something different than $Db ...
CU,
Gert
More information about the interchange-users
mailing list