[ic] $db-->query inner join

Gert van der Spoel gert at 3edge.com
Tue Mar 10 17:18:12 UTC 2009


> On 3/10/09 10:35 AM, "Stefan Hornburg" <racke at linuxia.de> wrote:
> 
> > Sam Batschelet wrote:
> >>
> >>
> >> 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};
> >
> > $Tag->perl({tables => 'inventory'});
> >
> > $db = $Db{inventory} # note capital D
> >
> > would work if both tables share the same DBI connection.
> >
> > Regards
> > Racke
> Thanks Racke seems to be running the query just curious why I am
> getting
> back an Array is this by design?


An array reference, by design yes:
http://www.interchange.rtfm.info/icdocs/tags/query.html





More information about the interchange-users mailing list