thanks doug, SELECT a,b,c,d,e,f FROM tbl1 WHERE 1=1
AND ( b = txt1 AND c = int1 ) OR ( d IN (txt2,txt3) AND e = txt4) ORDER BY f the only thing specific that i can think of regarding this query is that columns d and e return long text (type text in sql2k5). >Can you post the query? That would help alot. > > > >Doug B. >----- Original Message ----- >From: "Sicular, Alexander" <[EMAIL PROTECTED]> >To: "CF-Talk" <cf-talk@houseoffusion.com> >Sent: Friday, January 05, 2007 7:24 AM >Subject: slow query in cf but fast in Sql2k5 management studio. > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 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:265781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
