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?
Go to bottomPage: 12
TOPIC: SQL Query
#52097
SQL Query 9 Years, 4 Months ago Karma: 0
Hi,

I use the following SQL query for Ari Data Tables:

SELECT Composer, Title, Category, Information FROM leergangpiano WHERE Level=1

How do I 'translate' this query for the Ari Data Table module in Ari Smart Content?

Thanks,
Marsm
The administrator has disabled public write access.
 
#52098
Re:SQL Query 9 Years, 4 Months ago Karma: 746
Hello,

Do you mean "ARI Smart Content - DataTable" module from "ARI Smart Content" v. 2.x?

Regards,
ARII Soft
The administrator has disabled public write access.
 
#52102
Re:SQL Query 9 Years, 4 Months ago Karma: 0
Yes, the "ARI Smart Content - DataTable" module from "ARI Smart Content" v. 2.2.0
The administrator has disabled public write access.
 
#52103
Re:SQL Query 9 Years, 4 Months ago Karma: 746
Open module settings page, find "Data source" parameter and click by "Select" button to select an existing data source (it can be an SQL query or CSV file) or create a new one. See also this video tutorial.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#52105
Re:SQL Query 9 Years, 4 Months ago Karma: 0
I already watched the video.

I created a new SQL query with parameters: DB connection to Joomla database and I use following query: SELECT Composer, Title, Category, Information FROM leergangpiano WHERE Level=1. But it isn't working at all (blank page on frontend).

I read in the manual that a SQL query looks something like SELECT id, title FROM #__content WHERE ({$REQUEST:search|empty:''} = '' OR title LIKE CONCAT('%', {$REQUEST:search|empty:''}, '%')).

My question is, is my query ok?

Thanks.
The administrator has disabled public write access.
 
#52106
Re:SQL Query 9 Years, 4 Months ago Karma: 746
The query looks fine. A blank page appers if a PHP error occurs. Check web server error log or set temporary "System -> Global Configuration -> Server -> Error Reporting" parameter to "Development" value in Joomla! settings and send info what PHP error occurs.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12