[ic] $db-->query inner join

[Sam Batschelet]

On 3/10/09 12:18 PM, "Gert van der Spoel" <gert at 3edge.com> wrote:

>> 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
> 
> 
But according to the docs this is not a default setting an array needs to be
set with wantarray => 1, all I want is to return the final value because its
only 1 record/value.  Does it matter that I am using $db->query() vs
$Tag->query() that this is default?