Hi all,

I build a test query to get data from a mysql db:

{arisqltable}
{ariconnectionstring dbHost="db1" dbName="analisi" dbUser=""

dbPass="" dbType="mysql" persistent="false"}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true"}
{coltemplate}{$NAME} - {$ID}{/coltemplate}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT `Ticker`, `PricingDate`, `PClose` FROM `Prices` WHERE `Ticker` = 'AI.FP'

{/arisqltablequery}
{/arisqltable}

The output I recieve is the following:

Errore: 1146 - Table 'AAMJoomla.Prices' doesn't exist SQL=SELECT `Ticker`, `PricingDate`, `PClose` FROM `Prices` WHERE `Ticker` = 'AI.FP'

It seems that arisqltable try to get data from the Joomla db "AAMJoomla"

Could you please help me?

Hello,

Could you provide a link to a page where the problem occurs and a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft