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

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

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

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, 9 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, 9 Months ago	Karma: 760
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, 9 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, 9 Months ago	Karma: 760
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