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?

Smart Content / Data Table problems
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Smart Content / Data Table problems
#54249
Smart Content / Data Table problems 8 Years, 11 Months ago Karma: 0
Hi folks,
recently updated FROM:
    Joomla 2.5, ARI Smart Content Component 1.9.4, ARI Data Tables Module 1.14.2........ TO
    Joomla 3.4, ARI Smart Content Component 2.2.17, ARI Data Tables Module 1.14.12


In the old site, I had the following code in the "Content" area of a Smart Content module (see ari-screen-prints-1 in the zip fle). ----- This worked perfectly.

In the new (updated) site I have the folowing code (see ari-screen-prints-2 in the zip fle for both the code AND the results).

I have stripped off all the {arisqltable] stuff from the old version, leaving just the SQL for the Smart Content SQL Source, but I just cant get this to work....... the actual SQL staement works perfectly of course, but I just cant get the headings formatted in the output, and also, I cant get the Time Convert to work.... (these do work properly in a straightforward MyPhpAdmin query).

I know I am missing something stupid, and that this is due to my ignorance, but if you could throw some light on this, I would be hugely grateful!

thanks,

Mike
File Attachment:
File Name: ari_screen_prints.zip
File Size: 71455
Last Edit: 2015/04/18 05:58 By quigley595.Reason: adding the zip file
The administrator has disabled public write access.
 
#54253
Re:Smart Content / Data Table problems 8 Years, 11 Months ago Karma: 746
Hello,

Use the following query:

SELECT
username AS `LOGON NAME`,
ID,
NAME,
EMAIL,
CONVERT_TZ(registerDate,'+00:00','+10:00') AS REGISTERED,
lastVisitDate AS `LAST VISIT`
FROM
#__users
WHERE
block = 1
ORDER BY
registerDate DESC

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54260
Re:Smart Content / Data Table problems 8 Years, 11 Months ago Karma: 0
Thank you so,so much!
I had the quote wrong.... sheesh...... how embarrassment (as a comedian here used to say).

Thanks a million folks for your time, your support and your great extensions

Mike
The administrator has disabled public write access.
 
Go to topPage: 1