I want the form field to look like this:
input type="hidden" name="selectionFormula" value =
"{myTable.myField} = 12345" where 12345 represents the
evaluated form of
#client.myVar# which is what was stored in the database.
Thus the inclusion of the evaluate() and de() [delay
evaluate] functions
in CF, see docs for full details. I can never remember when
one use
one, the other or both so some experimentation will be
required, but one
of these forms should work.
input type="hidden" name="selectionFormula" value =
"#evaluate(myQuery.userSF)#"
OR
input type="hidden" name="selectionFormula" value =
"#de(myQuery.userSF)#"
OR
input type="hidden" name="selectionFormula" value =
"#evaulate(de(myQuery.userSF))#"