Attention!

These forums are not monitored. We provide the discussions forum as a place for users of free extensions to help each other and find answers, not as a place for our staff to deal with urgent support issues. Our staff very rarely responds to forum posts. Occasionally we will respond to forum posts but responses are not guaranteed.

If you have an active subscription for a commercial extension and wish to receive support please login to your Artetics.com account and submit a ticket. The ticketing system is the best way for you to get assistance in a timely manner.

Thank you!

Categories
Subscribe  
  RSS Feed
Subscribe to this site with an RSS Feed Reader
  Receive E-mail Updates
Subscribe to receive e-mail updates from this site
New

Hyperlink in a sqltable result

Art Table
  Art Table
Mona AbdelHady
  Mona AbdelHady
  Tuesday, 29 January 2013
  8 Replies
  2.3K Visits
0
Votes
Undo
I\'m trying to create a hyperlink in the results of a sqltabe:

{artsqltable query=\"select concat(\'<a href=`\', \'http://www.google.com\', \'`>\', deptName,\'</a>\' ) as Departments from Departments where deptYear IS NULL Order by deptName\" connectionString=\"mysql,localhost,DBName,user,password\"}{/artsqltable}

The following is what I get:

<a href=`http://www.google.com`>Advanced Placement (AP)</a>

Text filters are turned off.

Thanks