Thread

Hi all,

Is it possible to assign the result of a query to a preload_replace variable? See my query code below:

{exp:query sql="SELECT cat_id FROM exp_categories WHERE parent_id = '{segment_3_category_id}' "}
{cat_id}
{/exp:query}

Also, is there a way to set a custom delimiter to the exp:query output? In this case, I am trying to generate a pipe-delimited output.

Thanks, as always, any help would be greatly appreciated.

Rudy

Moved to CodeShare Corner by Moderator

If I understand you correctly it will depend on where you are using it and parse order.  You can always do something like below:

{exp:query sql="SELECT cat_id as sub_cat_id FROM exp_categories WHERE parent_id = '{segment_3_category_id}' "}
{sub_cat_id}
{/exp:query}

As for the delimiter try this:

{exp:query sql="SELECT cat_id as sub_cat_id FROM exp_categories WHERE parent_id = '1' "}{sub_cat_id}|{/exp:query}

You are brilliant! I’ve added backspace=“1” to trim the excess pipe and it’s all set.

Thanks!
Rudy