>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.
Actually, just a trick to display parsed query. If you insert a <cfabort> just above your </CFQUERY> tag (immediately after your SQL), and run your page, the program will abort and automatically display the parsed query. You don't have to change the cfquery tags to cfoutput tags. Dave -----Original Message----- From: Dina Hess [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 9:50 PM To: CF-Talk Subject: Re: CF7 lots of new "Ambiguous column name" issues 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214520 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54