Hello,

Firstly may I point out that I am blind and use a screen reader to access my computer which goes some way to explaining why I am having difficulty with this part of Data Tables.

Data Tables is installed, plugin enabled for article insertion and module is published.

I wish to query the Joomla database, lang_joom465
I have tried entering: SELECT * FROM lang_joom465; and then placed Data Tables in an article and also then in a module but it returns : Error while rendering position.

Having spent hours reading the Data Tables instruction manual, this forum, Wikipedia and www.w3schools.com/sql/sql_select.asp I am now totally at a loss.

Can someone please tell me in easy to follow steps, how do I get a Data Table to show: User's First name and last name for example?

From there I am sure it will become clear enough for me to work out the rest.

Many thanks in advance for your help with this.

Hello,

If you specify the correct table name, then your query looks normal. It seems "Error while rendering position." is show by site template and it hides a real error. Could you open module settings page, enable "SQL -> Debug" parameter and try to temporary load the module into a module position which is defined in site template. After this open a page with the module and check the error. If the same error will be shown, could you provide a temporary access to your J! backend by email so we can investigate the problem in mode details?

Regards,
ARI Soft

Hello again,

Thank you for your help, I have spent some more time messing around with my test site and ARI Data Tables plus trying different SQL syntax and finally got it to work!

I now have. a table within an article showing the first name of all registered users, this is one small step for a blind person, but a big one in the grand scheme of things.

Cheers.