So I'd like to encapsulate the returned data inside a link.

If the returned data is a list of names, I'd like the list to be clickable:

<a href="ViewLog?User=Name1">Name1</a>
<a href="ViewLog?User=Name2">Name2</a>
<a href="ViewLog?User=Name3">Name3</a>
<a href="ViewLog?User=Name4">Name4</a>


Right now, my "in theory" MySQL command is:


SELECT Name
AS CONCAT('<a href="ViewLog?User=', @Name, '">', @Name, '</a>')
FROM Table;

This works!


SELECT CONCAT('<a href="ViewLog?Name=', Name, '">', Name, '</a>') AS Name
FROM Users;


Thanks!

if you are giving this kind of solution
it means that the component does not support links right?

have some way to double click and open a new page?

thanks so much,

Hello,

The extension can detect link automatically for selected columns or links can be created based on selected data from a database or a CSV file.

Regards,
ARI Soft

thanks for your fast reply.
I am very interested on your product, but I need to know something before buy.

could I do something like that:

select name, address, phone from my_table

-------------------------------------
name | address | phone
-------------------------------------
user1 address1 phone1
user2 address2 phone2
user3 address3 phone3
user4 address4 phone4
-------------------------------------

add add a link to each user like below:

my_joomla_site//index.php/my_page ?

if yes, how?
creating a link on the query? select "<a href=''">+name+"<a>",address, phone from my_table

?

unfortunatelly I cant see this in any demo =(


thanks in advace,

valter

Sorry, but it is not clear how the link should look. Is it created based on data from the table? Is it unique link for each user or the same link is used for all users?

Regards,
ARI Soft