Question
Filtering cfquery dinamically
I am trying to update query values wihtout refreshing the
page. I want to do all this through a input text when the value
changes.
Example
<cfparam name="inputfield" default="0">
<cfquery name="getCols" datasource="#Application.DSN#">
SELECT COL1, COL2
FROM TABLE
WHERE COL1 = #inputfield#
</cfquery>
<cfform name="form">
<!---Input field that depends on the value will change the filterign on the query-->
<cfinut type="text" name="inputfield">
SKU Product: #getColumns.Col1#
Name Product: #getColumns.Col2#
</cfform>
Example
<cfparam name="inputfield" default="0">
<cfquery name="getCols" datasource="#Application.DSN#">
SELECT COL1, COL2
FROM TABLE
WHERE COL1 = #inputfield#
</cfquery>
<cfform name="form">
<!---Input field that depends on the value will change the filterign on the query-->
<cfinut type="text" name="inputfield">
SKU Product: #getColumns.Col1#
Name Product: #getColumns.Col2#
</cfform>
AdChoices