>Shot in the dark here, but is there a query anywhere in your application, or >otherwise being executed against your database, that is using SET ROWCOUNT >50, and not resetting the rowcount attribute to 0 afterwards?
If Doug is right (and this seems to be a really good guess) an easy way to test (short of a search/replace) would be to set the Rowcount at the beginning of your states query and see if the number if different. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
