Skip to main content
Inspiring
July 15, 2010
Question

Finite records in bindonload

  • July 15, 2010
  • 1 reply
  • 592 views

I need to have a combo box display data based on the selection of another combo box. Specifically I have a Parts table and I need the part description to show on its own field when the part is selected. I have used bindonload.

Here is my code:

<th>Part Number</th><td><cfselect name="PartID" bind="cfc:dfSources.getPart()" bindonload="true" />  </td>   
<th>Description&nbsp</th><cfselect name="Description" bind="cfc:dfSources.getPartDescription({PartID})" /></td>

This works very well for a few records - just about 300. After 400 records it is slow, and upwards of 500 it does not work.

Is there a limit to the number of records a bind can return?

    This topic has been closed for replies.

    1 reply

    Inspiring
    July 15, 2010

    There are ways to restrict the number of records you receive from queries, but you have a dilemma here.  If you restrict the number of selections, what do you do about people who want one of the ones you chose to not display?

    gitobuAuthor
    Inspiring
    July 15, 2010

    You are right Dan. This works well for a few hundred records where my query is "SELECT TOP 300" for example. I am leaning towards thinking that this feature works only for a handfull of records. I am not reaching a conclusion though.