5 Replies Latest reply on Dec 9, 2008 7:04 PM by wolfv

    How to evaluate a double dereference?

    wolfv Level 1
      I am so stuck on this problem. Please tell me how it can be solved.

      q1 and q2 are result sets from a database.

      q1.status = "approved"

      q2.field = "prompt: #q1.status#"

      I need some syntax to evaluate q2.field so that it prints "prompt: approved"

      I tried Evaluate() and <cfoutput>#q2.field#</cfoutput> but nothing seems to work.

      Thank you in advance.