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...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/