First, I would modify your query to make it a bit easier to follow, if your DB platform allows. Move your table joins from the WHERE clause to the FROM clause using the INNER JOIN syntax.
Then, strip out all, but one, of your WHERE filters. Test it with that single statement. Then, once you are sure that works, add another criteria to the WHERE clause. Repeat until you find the offending code. -----Original Message----- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2008 8:23 AM To: cf-talk Subject: Re: query not producing the right results What is the recordCount? Is it returning one record? Try <cfdump var="#YourQueryName#">* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
