Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

ARISqlTable query remain linked to Joomla DB
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: ARISqlTable query remain linked to Joomla DB
#49652
ARISqlTable query remain linked to Joomla DB 9 Years, 10 Months ago Karma: 0
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?
The administrator has disabled public write access.
 
#49655
Re:ARISqlTable query remain linked to Joomla DB 9 Years, 10 Months ago Karma: 746
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
The administrator has disabled public write access.
 
Go to topPage: 1