What driver are you using? ODBC? Do other queries using this datasource return more than 50 records?
Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -----Original Message----- From: Bill Fears [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 10:09 AM To: CF-Talk Subject: Query Result Problem We have a query that returns 53 records in Query Analyzer (which is correct) but that same query in a CF Page will only return 50 records. The query is not cached, no maxrows, no TOP keyword and there is nothing that stands out in CFAdmin. Server Specs: ColdFusion MX 7.0.2 Enterprise, Windows 2000 , SQL Server 2000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
