Cfgrid to display search results

[grice]

I'm using Cfform format = flash. I have 2 search fields, and a button. When a
user enters their search query, and hit submit, I want to populate my cfgrid
with the results. Can anyone give me some insight on how to pull this off?
Thanks -GR

[dbenitez]

I did this piece of code really quick, i hope it can help you.

-Diego Benitez


<cfform action="#cgi.SCRIPT_NAME#" name="search" method="post">
<cfformgroup type="vertical">
<cfformgroup type="horizontal">
<cfinput name="fiel1" label="Field1: "><cfinput name="field2" label="Field2: ">
</cfformgroup>
<cfinput name="Search" type="submit" value="Search">
<cfif isdefined('form.search')>
<cfquery name="LookUp" datasource="datasource">
SELECT * FROM table WHERE column1 LIKE '%#form.field1#%' and column2 LIKE
'%#form.field2#%'
</cfquery>
<cfgrid query="LookUp" name="SrchGrid"></cfgrid>
</cfif>
</cfformgroup>
</cfform>

[grice]

that was what I was lookin for, thanks a ton for the help.