That sounds like a data-source setting to me. Check if its ODBC and look at connection strings or any possible connection settings you have. I don't think this is a coldfusion related setting at all.
Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -----Original Message----- From: William Fears [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 10:22 AM To: CF-Talk Subject: Re: Query Result Problem Any query will stop at 50 rows, for example we have a zip code database <cfquery name="zipTest" datasource="zipcode"> SELECT zipcode, state FROM zipcodes WHERE state='GA' </cfquery> <cfdump var="#zipTest#"> That cfdump outputs 50 records and it should be 1534 >The query? > >-----Original Message----- >From: Bill Fears [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 12, 2007 9: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:283557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
