Is it possible that you have two different databases, i.e. a backup one? Dominic
On 12/07/07, William Fears <[EMAIL PROTECTED]> wrote: > > 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:283558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
