I have a table with 2 columns containing "company" and "url", where company is a company name and url is the url to the company's website. I've created a url link by concatenating "url,'||',company" using this code:

 IF (wp_wpdatatable_5.url like 'http%' ,  concat(wp_wpdatatable_5.url,'||',wp_wpdatatable_5.linkname) , wp_wpdatatable_5.linkname) AS RESOURCE

This works fine, and outputs a link or just the company name if a url is missing.. All rows with "company" are populated, but some rows do not have a corresponding url. 

The problem is that the rows with just company names have no link, but rendering this column as a url link column shows them as links, but they are not and I want to show them just as company. How can I output the column where some of the cells are not links and others are?

Thanks,

Marv. 

Really like this plugin, guys.

Hi Milan,

You don't understand. My sql statement creates a link ( URL || COMPANY) if the url exists, but puts just the company name into the column if the url doesn't exists, so my sql is fine. The resulting column contains url links for some rows, but only company names for other rows. The table is fine in terms of the output.

The problem is that when that when I change that column from string to url link, the company names become clickable ! They become dead links. So, how can I prevent these rows from turning into links?

HI Milan,

No worries! I figured it out - instead using a url link column using the "||" feature , I concatenated the "a href=" link structure with the table output and put the code into a string field. 

Marv