Doug, Rick Root posted a thread which reminded me of the issue you are having. He's talking about a way to optimize a zip-lookup function perhaps similar to yours. That post is at: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50216
Hope this is of some help. Seems to me that the resultset is too large for SQL Server to handle. You could try running SQL Profiler to view memory statistics or reconfiguring SQL Server to have more memory if you have some to spare. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
