Hi,

I'm trying to format a table of results in ARI SQL Table plugin.

In your example given with the plugin how would you set the cellspacing or cellpadding on the results?

{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT id AS ID, name AS NAME
FROM #__users
{/arisqltablequery}
{/arisqltable}





A second question, is it possible to add a column which can contain data which is not from the database, I'm going to be returning a single row of results and want to be able to add text into the first column as below:


My Text ¦ My Data from database column 1 ¦ My data from database column 2



Thanks

Hello,

1. Use cellPadding and cellSpacing attribute of {arisqltable} tag. For example

{arisqltable cellPadding="6" cellSpacing="3"

2. Use a virtual column:

{arisqltablecolumn alias="Virtual Column" virtual="true" pos="1"}
{coltemplate}Some text goes here{/coltemplate}
{/arisqltablecolumn}

Regards,
ARI Soft