Many thanks for your prompt reply. It now does the business. A great team and a great product!

One final question. Can I build an HTML line into a SQLTABLE column using cellTag? For instance I wish to create a link from NAME to a popup containing address etc. I could do it using my very original coding now that I have the CONTENTANYWHERE plugin but it would be nice to do it from SQLTABLE having got this far.

'cellTag' parameter accepts only 'td' or 'th' value. If you want to create column with custom formatting, you can create virtual column:



or build necessary HTML code with help CONCAT SQL function:



Regards,
ARI Soft

Brilliant! I'll have a play around.

Sorry! It's me again. I've tried
{arijtablesorter notSortableCols="0"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="NAME" alias="Name" width="20%" pos="0"}
{arisqltablecolumn id="CAT" alias="Membership Category" width="10%" pos="1"}
{arisqltablecolumn id="LEVEL" alias="Playing Level" width="20%" pos="2"}
{arisqltablecolumn id="ID" hidden="true"}
{arisqltablecolumn alias="Virtual Column" virtual="true" width="20%" pos="0"}
{coltemplate}<a href="index.php?option=com_qcontacts&amp;view=contact&amp;id={$ID}" target="_blank">{$NAME}</a>{/coltemplate}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT
t1.id AS ID, t1.name AS NAME,
t1.misc AS LEVEL, t2.title AS CAT
FROM #__qcontacts_details AS t1
JOIN #__categories AS t2 ON t1.catid = t2.id
WHERE catid != 126 ORDER BY yahoo_msg ASC
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}

and I get a working link with NAME, but only that. No other columns appear. I'm obviously not understanding a fundamental part of the logic.

Hello,

Sorry for delay, use the following code, please:



Regards,
ARI Soft

Thanks