cfgrid-flash- search

[lgschulz]

I would like to have 3 possible search fields that on submit it will search the
database and display the results in the cfgrid in flash format. Is this
possible. See my code below.



<cfform name="Hardware" height="1000" width="900" format="Flash"
skin="HaloGreen">
<!--- The input area is a panel. Styles to specify panel characteristics.
Child controls inherit the background color and font settings. --->
<cfformgroup type="Panel" label="Hardware Search"
style="marginTop:10; marginBottom:10; fontSize:14; fontStyle:italic;
headerColors:##FFFF00, ##999900; backgroundColor:##FFFFEE;
headerHeight:35; cornerRadius:12">

<!--- This vbox sets the font size and style, and spacing between and
around its child controls. --->
<cfformgroup type="vbox" style="fontSize:12; fontStyle:normal;
verticalGap:10; marginLeft:5; marginRight:5">


<cfformgroup type="horizontal" style="horizontialalign:left">
<cfinput type="text" name="part_number" label="Part Number" width="200">
<cfinput type="text" name="description" label="Description" width="400">
</cfformgroup>
<cfformgroup type="horizontal" style="horizontialalign:left">
<cfinput type="text" name="material_description" label="Mat'l Description"
width="300">

</cfformgroup>
<!--- Horizontal rules surround the e-mail address.
Styles specify the rule characteristics. --->
<cfformitem type="hrule" style="color:##999900; shadowColor:##DDDD66;
strokeWidth:4"/>
<cfformitem type="HTML" Style="marginTop:0; marginBottom:0">

</cfformitem>


<cfgrid name="grid" format="flash" query="Hardware"
selectmode="single" width="800" height="300">
<cfgridcolumn name="part_number"
width="120"
header="Part Number">
<cfgridcolumn name="procurement_document"
width="120"
header="Proc. Doc">
<cfgridcolumn name="description"
header="Description">
<cfgridcolumn name="material_description"
header="Mat'l Description"
headeralign="center">
</cfgrid>


<!--- Styles control the colors of the current, selected, and
rolled-over dates.
<cfinput type="datefield" name="mydate1" label="Date" width="200"
style="rollOverColor:##DDDDFF; selectionColor:##0000FF;
todayColor:##AAAAFF">--->
</cfformgroup> <!--- vbox --->
</cfformgroup> <!--- panel --->
<!--- A style centers the buttons at the bottom of the form. --->
<cfformgroup type="horizontal"style="horizontalAlign:center">
<cfinput type = "submit" name="submit" width="100" value = "Show Results">
<cfinput type = "reset" name="reset" width="100" value = "Reset Fields">
</cfformgroup>
</cfform>
</body>
</html>

[nimer]

This should be. When you select the search criteria, the form will reload and
post back to the server, you can then run a new 'Hardware' query, based on the
form submission. And then when the form is reloaded the grid will be bound to
the new query. hth, ---nimer

[grice]

I'm also trying to do this, but, I have over 5000 records in my database. I do
not want to query the entire the database before the page loads. Also, in your
code, I can't see where you are quering the database, and where you're posting
your form. Any help will be appreciated. Here's the code I have.... <cfform
format='flash' name='studentSearch'> <cfinput type='text' name='lastname'
label='Last Name' width='200'> <cfinput type='text' name='licenseID'
label='License ID' width='200'> <cfinput type='submit' name='search' value='
Get Student(s) '> <cfgrid name='students' query='getStudentsResults'
selectmode='single'></cfgrid> </cfform>

[lgschulz]

I found some code on the web at [url]http://asfusion.com/blog[/url]

It had two downloadable versions of a search. See if that will help.