Thread

I have a sub template with an embedded variable. I want to run a query if that variable is empty however the query is run regardless. Remove the query and the statement works fine…

{if "" == "{embed:currentid}" || !embed:currentid }

 no id
 
{if:else}
 
 {exp:query sql="SELECT .... WHERE `id`={embed:currentid}"}

 {/exp:query}

{/if}

Any help??

Your syntax is off. Why not simply use

{if embed:currentid != ""}
   {exp:query sql="..."}

   {/exp:query}
{/if}

Sorry, should have mentioned that’s how I originally had it, that snippet above is after exhausting all variants of the conditional.

template conditionals don’t prevent things inside them from running, they only decide which parts of the template are output to the browser.  You’ll need to use PHP conditionals and queries if you need to conditionally run a query.

Thanks ender, I’ll do that.

The PHP conditionals wouldn’t work because of embedded variables, so to solve this one I just put the second part of the statement in an embed. That works a treat: might help if people are having the same problem in the future.

Incidentally it will also solve {if no_results} in the query: you can just run another, different query to find alternative results.

{exp:query sql="SELECT `something` FROM `somewhere` WHERE 1"}

  {something}
  
  {if no_results}
    
    {embed="template_group/.alternative_query" currentid="{embed:currentid}"}
  
  {/if}
  
{/exp:query}