SELECT * FROM aTable WHERE indiv = #form.id#
The form line that creates form.id in the calling form is
<input name="id" type="hidden" id="id" value="102702" />
What doesn't work is:
SELECT * FROM aTable WHERE indiv = <cfqueryparam value="#form.id#" cfsqltype="cf_sql_integer">
indiv is type int.
I get the error message "Value can not be converted to requested type." The weird thing is this query worked fine until I added a couple of unrelated fields to this table. Where is the issue coming from?