we are using JDBC v3.3 No matter what query we run on that server, we have the same issue.
On 7/12/07, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

