Hello -

I am using the following code to display name and website from mySql table and hoping to hyperlink website to customers website:

{arijdatatable}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="name" alias="Company Name" width="30%"}
{/arisqltablecolumn}
{arisqltablecolumn id="website" alias="Website URL" width="70%" format=<a href="($value}">{$columns:website}</a>}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT name,website
FROM dealerships
where website >' '
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}

The data is retrieved however the hyperlink doesn't work.

Thanking all in advance for any assistance with this issue.

Hello,

Hello,

The plugin code is incorrect. {arisqltablecolumn} tag doesn't support "format" attribute. Use the following code:



Regards,
ARI Soft

Hi and thank you for your reply.

Is it possible to have the hyperlink open in a new page less address bar and scrollbars.

This is an example of what I am trying to accomplish from another application:

SELECT
`<output name="WEB" type="link" linktype="open" open="location=0,scrollbars=1" target="_blank" text="View Details"/>`
FROM sheet4
WHERE `Industry` LIKE '%Restaurant%'
AND `WEB` > ' '

Thanking you in advance for your assistance.

Use the following code:



Regards,
ARI Soft