our datasource is setup as default: CF data source name ourDSN Description Driver MSSQLServer JDBC URL jdbc:macromedia:sqlserver://ourServerName:1433;databaseName=OurDSN;SelectMethod=direct;sendStringParamet ersAsUnicode=false;MaxPooledStatements=1000 Username ourUserName Login timeout 30 seconds Long text buffer size 64000 Timeout 1200 seconds Maintain connections Yes Interval 420 seconds Restricted SQL operations Disable connections No
On 7/12/07, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
