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

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

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