cfqueryparam causes no records to return some of the time

I have to do more testing but i may found a solution. I changed the cfsqltype to char instead of varchar.

The maxlength attribute looks like it might contribute to unexpected results.  When it doesn't work, does it crash or simply return something other than what you anticipated?

So you're saying that this:

<cfquery name="q" datasource="whatever">

select  a.coulmn1, a.coulmn2, c.coulmn3, a.coulmn4
from general_view a, second_view c
where a.id = c.id
and a.coumn1 = <cfqueryparam value="#form.selected_from_previous_dropdown#" cfsqltype="cf_sql_varchar" maxlength="20">
and c.some_other_column= ('#query2.other_column#')

</cfquery>

and this:

<cfquery name="q" datasource="whatever">

select  a.coulmn1, a.coulmn2, c.coulmn3, a.coulmn4
from general_view a, second_view c
where a.id = c.id
and a.coumn1 = '#form.selected_from_previous_dropdown#'

and c.some_other_column= ('#query2.other_column#')

</cfquery>

return different results?

What is the value of #form.selected_from_previous_dropdown# ?

--

Adam

PS: is that query reflective of your actual DB schema?  You spell "column" three different ways...