[ic] Difficulties grabbing sql data within perl tags.

[Davor Ocelic]

On Wed, 5 Jan 2005 19:02:41 +0800
"Cameron G" <ritontor at icenet.com.au> wrote:

> > > > On Wed, 5 Jan 2005 17:14:41 +0800
> > > > "Cameron G" <ritontor at icenet.com.au> wrote:
> > > >
> > > > > I'm positive I'm missing something terribly obvious here, but 
> > > > > right now I'm stumped. All I'm trying to do is hack the 
> > Detailed 
> > > > > reports page to display a list of the item descriptions 
> > that were
> > > > purchased -
> > > > > seemingly a simple task, merely a query that says "select
> > > > description
> > > > > from orderline where order_number = 'the order number'".

> > > > >  my $results = $Tag->query( { sql => $ordersql, } 

> > > > Use [perl tables="products store orderline"] or set the base 
> > > > attribute for query to orderline.

> > Cameron, have you tried setting the base attribute for the 
> > query tag to orderline as Racke proposed?
> > E.g. add to query tag:
> > base='orderline'

Isn't his problem that he is using $Tag->query() instead of

  $Db{products}->query({ sql => $ordersql })  ?