[ic] Newbie q - help with [query] for multi-table report

[interchange-users@icdevgroup.org (Stefan Hornburg Racke]

"Jordan" <savage@troubie.com> writes:

> I know just enough to get myself into trouble it seems.  I need help with
> the correct tag syntax to create a report.  The code follows, but here's the
> scoop in case any of it isn't clear:  I need to create a report that lists
> each product sku and every purchaser and quantity ordered, etc.  Eventually,
> I'll create a report page where I can enter the sku, and all the buyers and
> quantities ordered will come out in a printable list.  For now, I just need
> it to work on any level.  (but suggestions for the latter are also
> appreciated.).
> 
> Here's the code I have.  Can you tell me where I need to go from here?
> 
> [query sql="SELECT orderline.code, orderline.sku, orderline.quantity,
> orderline.subtotal, transactions.lname, transactions.fname,
> transactions.status, transactions.comments FROM orderline, transactions
> WHERE orderline.order_number = transactions.order_number ORDER BY
> orderline.sku, transactions.lname"
>       type=list
>       more=1
>         ml=50]
> 
>    [on_match]Matched<br>[/on_match]
>       [no_match]Not Found<br>[/no_match]
>       [list]
>         [sql-param orderline.code] [sql-param transactions.lname] [whatever
> tags are supposed to go here...?]<BR>

AFAIK using the column names only should work here, like [sql-param lname].

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.