ARI Soft - SQL Query - ARI Soft Forum

Featured Demos

e-mail: info@ari-soft.com

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.

more...
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.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

SQL Query

(1 viewing) (1) Guest

Page: 12

TOPIC: SQL Query

Forum Tools

#36363

SQL Query 11 Years, 5 Months ago	Karma: 0
Can someone give step by step instructions on how to set up a table both using CSV & SQL, I've tried both and nothing happens, I've put a path in for a CSV file and nothing happened so I tried pasting in an SQL query and still nothing happen, no error messages or anything, I'm just really testing at the moment, I will be planing on putting up a searchable fixture list

Karenp

The administrator has disabled public write access.

#36364

Re:SQL Query 11 Years, 5 Months ago	Karma: 748
Hello, What value do you use for "CSV -> Path to CSV file" parameter and what SQL query do you use in "SQL -> SQL query" parameter? For example if you want to show articles id list and tiles, use the following SQL query: SELECT id, title FROM #__content Regards, ARI Soft

admin

The administrator has disabled public write access.

#36365

Re:SQL Query 11 Years, 5 Months ago	Karma: 0
I used media/dlspreviouswinners.csv I would prefer to use CSV, the CSV is saved as a UTF-8 file Should I not get an error message if I did something wrong

Karenp

The administrator has disabled public write access.

#36380

Re:SQL Query 11 Years, 5 Months ago	Karma: 748
If CSV file has incorrect format or an incorrect path is used, "No data available." message will be shown. Could you provide a link to a page where we can see the problem and send screenshot(s) of module settings page by email? Regards, ARI Soft