Question
Using Combo Box selection in query
Greetings!
Check this out...
<cfoutput>
<form name="myForm" id="myForm" method="post">
<SELECT NAME="pickMe">
<cfloop query="marksTest">
<OPTION value="#marksTest.EXPLOIT#">#UCase(marksTest.EXPLOIT)#</OPTION>
</cfloop>
</SELECT>
</form>
</cfoutput>
<cfif isDefined("form.pickMe")>
<cfquery name="marksTest" dbType="query">
SELECT *
FROM myquery
</cfquery>
<cfdump var="#marksTest#">
</cfif>
<form name="myForm" id="myForm" method="post">
<SELECT NAME="pickMe">
<cfloop query="marksTest">
<OPTION value="#marksTest.EXPLOIT#">#UCase(marksTest.EXPLOIT)#</OPTION>
</cfloop>
</SELECT>
</form>
</cfoutput>
<cfif isDefined("form.pickMe")>
<cfquery name="marksTest" dbType="query">
SELECT *
FROM myquery
</cfquery>
<cfdump var="#marksTest#">
</cfif>
What I am trying to accomplish is that when the user makes a choice from the combo box it is used to perform a query. Am I on the right track here? Any tips or suggestions will be greatly appreciated. Thanks!
AdChoices