now what output it gives?
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>...
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>
now what output it gives?
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 :
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
Bookmarks