I need to conditionality some code in my display
{IIF,"'[Vac]'='1'","<img class='Pbutton' src=[PORTALPATH]green_light1.gif height=16 border='0' alt='Vacancy'> ", " "}
To only be displayed when IsHosted = '1'
I thought the right way to do this was to wrap the IFF above in
{IFF,"'IsHosted' = '1',"
The IFF line from Above
","",""}
and then Escape the original with ^E

No mater what I do I get the line of code displayed (with or without the \\\'s)

Also IsHosted is a case in the query and is either a 0 ir 1, yet ListX seems to view it as True. Can I still use 1 in the IFF or do I need to use True? I thought that when we moved from SQL Server 2000 to 2005 this difference was taken care of.

/DaveS

Teh first thing i see is the misplaced double quote, after the comma, after the test. Could be able to do this {iif,[IsHosted]=1',{iif,[Vac]=1,whatever,whatever},whatever}, i think. I have found that the double and single queotes are not always necessary in the iif statements, so I leave them out to greatly reduce the complexity of the statement