When I insert this code
{exp:session_variables:get name = "referrer_id"}
to my template, it displayed the correct value, but when I nested this tag in side query module tag
{exp:query sql="select transaction_date, customer_first_name, customer_last_name, customer_email, receipt_url, order_total from exp_foxee_orders where custom_fe_reseller_id ={exp:session_variables:get name = "referrer_id"}"}
it doesn’t seem to retreive the value, also if I use a number to replace
{exp:session_variables:get name = "referrer_id"}
in the query, it will give me the correct result.
So my question is that is my syntax wrong?
Thank you very much!
