nested template tag issue
Posted: 08 July 2009 03:37 PM   [ Ignore ]  
Summer Student
Total Posts:  20
Joined  06-22-2009

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!

Profile
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1743, on December 02, 2009 03:47 PM
Total Registered Members: 120485 Total Logged-in Users: 49
Total Topics: 126559 Total Anonymous Users: 19
Total Replies: 665411 Total Guests: 282
Total Posts: 791970    
Members ( View Memberlist )