show if's

Not sure if this is possible.

Basically I have created a table in a database called 'portfolio' Within that table I have created 4 columns 'PortfolioWebsite', 'PortfolioEmail', 'PortfolioSM' and 'PortfolioSEO'

These columns are either empty (by default) or filled with 1 if the insert or update page check box has been checked for that entry

Now, what I am trying to do is a show if based on the column content rather than whole recordset so that if the column has 1 in it, then the front end will display the icon, if the column is empty then the icon is not shown.

The code, without any show ifs at all) at the moment:

<span id="sprytrigger1"><a href="#"><img alt="Website Design" border="0" height="30" src="/uploads/images/portfolio/website-icon.jpg" width="30" /></a></span> 
<span id="sprytrigger2"><a href="#"><img alt="Email Marketing" border="0" height="29" src="/uploads/images/portfolio/email-icon.jpg" width="30" /></a></span>&nbsp;
<span id="sprytrigger3"><a href="#"><img alt="Search Engine Optimisation" border="0" height="30" src="/uploads/images/portfolio/search-icon.jpg" width="27" /></a></span>&nbsp;
<span id="sprytrigger4"><a href="#"><img alt="Social Media" border="0" height="30" src="/uploads/images/portfolio/social-icon.jpg" width="41" /></a></span>

or woould I need to create a recordset for each of these and use the relevant show if for that?

Cheers

use the show if utility, on the server behaviors click the plus button and select Webassist -> Utilities -> Show region Utility, fro the If setting, click the lightning bolt icon and select one of the columns from your recordset. Leave the Is option set to Equals, for the value enter 1.