I have a table which is created by ARI SQL Table, wrapped by ARI JDataTable. I would like to create a link, the anchor text of which is one field, the url another.

The link field is 'Venue', the URL is 'Ticketlink'.

Instead of rendering them as 2 separate columns, I want to output this:

<a href="Ticketlink">Venue</a>

Is this possible?

The test site page this is on is: pfuk.nanagram.co.uk/test2

Hello,

Use the following code between {arisqltable} and {/arisqltable} tags:



Regards,
ARI Soft

Thanks for your super-fast response. I have done that, but the <a> tag is rendering as text (i.e. <a href="www.adticket.de/Aquanario-Die-neue-Show/Frankfurt.html">Arena</a>) and even with the hidden parameter, the ticketlink column is still showing.

pfuk.nanagram.co.uk/test2

The full code is:

{arijdatatable}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="date" alias="Date" className="gig_date"}
{arisqltablecolumn id="ticketlink" alias="Tickets" hidden="true"}{/arisqltablecolumn}
{arisqltablecolumn id="venue" alias="Venue" className="gig_venue"}
{coltemplate}<a href="{$ticketlink}">{$venue}</a>{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn id="city" alias="City" className="gig_city"}
{arisqltablecolumn id="country" alias="Venue" className="gig_country"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT date, venue, ticketlink, city, country FROM giglist WHERE date >= curdate() ORDER BY date
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}

If you use a WYSIWYG editor, switch it to plain text mode before editing plugin code. If it doesn't help, could you send a temporary access to your J! backebd by email so we can investigate the problem?

Regards,
ARI Soft

Ok, schoolboy error, the code was messed up! That fixed the link, but the hidden column is still showing. I've sent you the admin credentials.

Try now please.

Regards,
ARI Soft