Probably a longshot, but I had that problem once and it ended up being explained by the fact that I had copied a CFQUERY line that had a MAXROWS parameter set. Along the same lines, CFOUTPUT supports the MAXROWS parameter too.
On 2/14/07, Tero Pikala <[EMAIL PROTECTED]> wrote: > > Also check that you don't have un-committed transactions lurking > somewhere, > I've been confused with query results few times for that. > > > > -----Original Message----- > From: Coldfusion [mailto:[EMAIL PROTECTED] > Sent: 13 February 2007 23:35 > To: CF-Talk > Subject: RE: Query Oddness > > Run the Query then do a CFDUMP on the Query and see if the results match > Query Analyzer > If not, I would validate the right datasource is being used in both > instances. > > -----Original Message----- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 6:27 PM > To: CF-Talk > Subject: Re: Query Oddness > > Im not using cfqueryparam. Maybe I should try to here > > Bryan Stevenson wrote: > > I have actually seen CFQUERYPARAM cause odd results like that against > > Oracle > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development Electric Edge Systems Group > > Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: [EMAIL PROTECTED] > > web: www.electricedgesystems.com > > > > Notice: > > This message, including any attachments, is confidential and may > > contain information that is privileged or exempt from disclosure. It > > is intended only for the person to whom it is addressed unless > > expressly authorized otherwise by the sender. If you are not an > > authorized recipient, please notify the sender immediately and > > permanently destroy all copies of this message and attachments. > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
