Question
variables stored in a database
OK night owls, see if anyone has a solution for this mind
bender!!
I need to post a form to a Crystal reports csp page. The form variables need to be dynamic and are stored in a database. By that I mean: this is in a database cell: {myTable.myField} = #client.myVar# exactly as you see it. On my cfm page I loop over the result set and the hidden input form field looks like this:
input type="hidden" name="selectionFormula" value = "#myQuery.userSF#" . What I WANT is if you view source on the cfm page 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.
My problem is that when the cfm page renders the value for the selectionFormla hidden field is exactly what was in the database (i.e. NOT evaluated) as so: {myTable.myField} = #client.myVar#. This of course blows my crystal report up because it doesn;t know what #client.myVar# is.
Any ideas on an elegant solution to this?
Thanks tons!!!
I need to post a form to a Crystal reports csp page. The form variables need to be dynamic and are stored in a database. By that I mean: this is in a database cell: {myTable.myField} = #client.myVar# exactly as you see it. On my cfm page I loop over the result set and the hidden input form field looks like this:
input type="hidden" name="selectionFormula" value = "#myQuery.userSF#" . What I WANT is if you view source on the cfm page 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.
My problem is that when the cfm page renders the value for the selectionFormla hidden field is exactly what was in the database (i.e. NOT evaluated) as so: {myTable.myField} = #client.myVar#. This of course blows my crystal report up because it doesn;t know what #client.myVar# is.
Any ideas on an elegant solution to this?
Thanks tons!!!