[ic] Query problem with shared database

[Jamie Neil]

Jon Jensen [jon@endpoint.com] wrote:
>
> You have to tell Interchange which table's DSN you want to use in the
> query tag, otherwise it will use the DSN for your first ProductFiles
> table. It doesn't parse your query, so it otherwise has no way to know
> what you want. Try:
>
> [query
> 	arrayref=main
> 	table=merchandising
> 	sql="..."
> ]
>
> Jon

Of course, :$ I thought I might have missed something obvious.

Out of interest, what happens if you do a query that uses two databases with
different DSNs?

Many thanks,

Jamie