Finite records in bindonload

[gitobu]

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?

[Dan_Bracuk]

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?

[gitobu]

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.