Well, I'd like to see the parsed query to be certain that your problem is fully addressed but, from what you've provided, I'd say Claude has honed in on your issue. You need to scope the formobjectitemid and archive columns with either the version or companynews table. This is best practice for any SQL statement that references more than one table.
If you'd like to provide the parsed query, you can do so in one of two ways: 1) copy the parsed query from your debug info or 2) comment out the CFQUERY tags and replace them with CFOUTPUT tags. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
