Re: [ic] How to join tables with the [query] tag

["Donal H." <donalh@online.ie>]

> The problem comes when I try to join the tables 'transactions' and
> 'orderline' by the field 'order_number'. This allows knowing on which
> campaign was sold the product, etc. It says "Parse error near .affiliate".
> The exact parameters of the [query] tag are:
...
>         sql="
>              select transactions.affiliate,
>               transactions.campaign,

Are you using an sql database?

I tried a very basic "select [table].[column] from [table]" with a shop
using Postgres and it worked fine. With a shop that uses the standard IC
database, it generates that parse error! Sounds like either it's a bug in
the parser or else it's not supported with that database type.

-Donal


_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users