Using orion variables in sql query in alerts

rismail

Hi,

i spent 2 days trying to do the following :

am getting two many traps and wants to have them more readable so am using the following query but i keep getting error :

${SQL:SELECT description from table WHERE A='${vbdata4}' and b='${vbdata5}'}

where table is a custom tables created by me and have some info needs to be replaced when where condition met but am getting the following error :

${SQL:SELECT description from table WHERE a='$@vbdata4@'; and b='36'}

any one can help and tell me why the variable doesnt include the value ?

Thanks in advance,

EchoDelta

I get that type of reslut when there is no available value for the declared variable.