>that seams to have worked for that query, but other queries still return a >limit of 50 records. So I have this question, that I could not answer myself >with a google search... Is possible that a SET ROWCOUNT x in one place would >affect every query from that server?
Its possible that it would persist. I dont know if its a bug or if its by design. Either way, as Doug said, find the query that has SET ROWCOUNT 50 and make sure that at the end of that query, you SET ROWCOUNT 0 to reset the count to unlimited for all other queries. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
