Execute a sql query and assign result to a variable in FTL file -

i want execute sql query (if value exist in table or not) inside ftl file , based on result 1 or 0 want further operations.

if exists(select 1 datadb:tbl_conf                                 name="isenabled") 

i not want execute query again , again, store query's value variable , use anywhere in ftl file.

you can assign count variable base on can check condition

declare @a int select @a =count(*) datadb:tbl_conf name="isenabled" if (@a>0)