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:269770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4