difficult where - Coldfusion - Advanced Techniques

[macca2727]

I have tried the code below, i need my output to only show records that the
varible = the name of my column but only results with yes in that column

hope you understand

<cfif isdefined('form.selType')>
<cfset session.typevariable=#form.selType#>
</cfif>


<cfquery name="qEmployees2" dbtype="query">
SELECT *
FROM qEmployees
WHERE CarePro_ProServ_Education_Training = '#session.typevariable#'
</cfquery>

[cfdyn]

now what output it gives?

[macca2727]

I GET THE FOLLOWING ERROR

Query Of Queries runtime error.
Comparison Exception: While executing "="


The error occurred in C:\CFusionMX7\wwwroot\CFIDE\DPSGuideWeb\All
Files\WebSite\Files\ProductTypeResults.cfm: line 19

17 : SELECT *
18 : FROM qEmployees
19 : WHERE CarePro_ProServ_Education_Training = '#session.typevariable#'
20 : </cfquery>
21 :

[jazz823]

What is the field type in your database. als o do a cfdump to be sure your session variable is set prior to running the query