ARI Soft - ARI Data Tables to Query but Not Dsiplay

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show 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?

ARI Soft Forum

Joomla components

ARI Data Tables

ARI Data Tables to Query but Not Dsiplay

(1 viewing) (1) Guest

Page: 1

TOPIC: ARI Data Tables to Query but Not Dsiplay

Forum Tools

#47382

ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago

Karma: 0

Hi,

I am curious whether it is possible to use ARI Data Tables to connect to a MySQL database but not display the results in a columner table?

I really like the simplicity and reliability of your extension for connecting and pulling MySQL data but I have a query where the number of columns of data is too long to manage effectively in a table. Strangely, I only need to pull a single row or record. Is this something that can be done?

My thought was to use ARI Data Tables to pull the row then populate a form with the single record where each field maps to a field on a form.

maybe there is another or better way to accomplish the same thing using your extension. I am open to suggestions.

Thanks in advance.

Ken

kefford

The administrator has disabled public write access.

#47383

Re: ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago	Karma: 0
A quick follow-up, what does the setting REVERT (yes/no) do under the heading Data Transformation under SQL block of the ARI Data Tables module options?

kefford

The administrator has disabled public write access.

#47389

Re: ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago	Karma: 748
Hello, 1. "Revert" is used to change rows and columns places. 2. The extension is used to show data. It doesn't support ability to modify data. Regards, ARI Soft

admin

The administrator has disabled public write access.

#47392

Re: ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago

Karma: 0

Thanks, and I have no need to modify data. I know ARI Data Tables does not support that. My thought is to fill a form down the web page for each column of the data record, purely for display purposes.

I still am not following your description of the Revert. Does that mean that ARI Data Tables will then display columns down the left (rather than across top)?

If so, maybe this will avoid my having to fill a form. I only have one record to display in this case, but again with no editing.

Ken

kefford

The administrator has disabled public write access.

#47393

Re: ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago Karma: 748

If "Revert" parameter is used, the following data:

Code:



#     | col1    | col2    | col3 



val 1 | val 1-1 | val 1-2 | val 1-3



val 2 | val 2-1 | val 2-2 | val 2-3

will be converted to:

Code:



#     | val1    | val2    



col1  | val 1-1 | val 2-1



col2  | val 1-2 | val 2-2



col3  | val 1-3 | val 2-3

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#47399

Re: ARI Data Tables to Query but Not Dsiplay 10 Years, 5 Months ago	Karma: 0
Ok, now I get it. This should actually give me what I want and avoid me having to fill a form. I will test it. Thanks. Ken

kefford

The administrator has disabled public write access.

Page: 1

Useful Links