macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

CFGRID and BIND: missing rows

Subject: CFGRID and BIND: missing rows
From: "BD Hokie"
Date: Mon, 6 Aug 2007 00:24:30 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
I have a fairly simple CFFORM with a grid which pulls a list of users from a 
database. I'm using BIND to create a search function. the FORM posts to another 
page to pull up detailed information on the user selected. Everything works 
great when you first call the page. 

 However, it seems that once I try to narrow the results by passing a search 
term from the form, the first row of the refreshed GRID will not post properly. 
So if I have my list of users in the grid and then enter a term (such as 
"Joe"), the grid refreshes properly but when submitted the form throws an error 
because it's not passing any values to the processing page. I'm stumped. Below 
is the sample code I'm using is below. Thanks in advance for any help.

   <cfform name="HotlineUsers" action="viewuser.cfm" style="color:##999966"  >
   <cfinput type="text" name="searchterm" value="ANY" label="Search">
   <cfinput name="gobutton" value="Go" type="button" 
onclick="if(searchterm.value!= '') ColdFusion.Grid.refresh('listusers')" />
 <cfgrid format="html" name="listusers" pagesize="15" sort="true"  
 selectcolor="##99CC33" 
 bind="cfc:Users.finduser({cfgridpage},{cfgridpagesize},
             {cfgridsortcolumn},{cfgridsortdirection},{searchterm})">
             
 <cfgridcolumn name="userid" display="yes"  >
 <cfgridcolumn name="first" display="yes" header="First" width="100">
 <cfgridcolumn name="last" display="yes" header="Last" width="150">
 <cfgridcolumn name="email" display="yes" header="Email" width="150">
 <cfgridcolumn name="roles" header="Priveleges" width="200" >
 </cfgrid>
   <cfinput type="submit" name="submit" id="submit" value="Submit" />
 </cfform>





<Prev in Thread] Current Thread [Next in Thread>