This content has been marked as final. Show 5 replies
> 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"
QuerySetCell(q1, "status", "approved", #Row_number#) - Row_number is
> q2.field = "prompt: #q1.status#"
i think you may have misinterpreted the op's question... or aybe i have...
but the way i read it is, the op has one db table with a column with a
value 'approved' and [another db table with a] column with actual value
'prompt: #q1.status#', and he expects his output of querying the second
column/table to replace the #q1.status# with his result of querying the
first column/table... which won't ever work...
Storing code in a db and trying to select it and execute it won't work unless you write the query output to a file first and then include the file. This usually makes it a bad idea.
That's right Azadi. I should have mentioned that the result sets have only one row each. I will try Dan Bracuk's idea, when I go back to work on Monday.
Thanks Dan. Using cffile worked great.