CAUSE The alias, or label, of a calculated field cannot be identical to any of the field names used to calculate the field.
RESOLUTION Change the name of the alias or label used by the calculated expression or let Microsoft Access automatically assign an alias or label. For more details - http://support.microsoft.com/kb/97526 Thanks. -Sandy Vohra -----Original Message----- From: Frank Velazquez [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2008 1:35 PM To: CF-Newbie Subject: Circular reference caused by alias ... Sorry I pressed the Submit Button by mistake. Hello Guys! I am getting the following error when selecting a query from my MSaccess Db. Thios works fine when I test it in my PC, but when it's uploaded the following error appears! \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'HuntId' in query definition's SELECT list. The error occurred in D:\home\uberhunt.com\wwwroot\_admin\Hunts_Choose_DailyPrize.cfm: line 16 14 : </cfquery> 15 : 16 : <CFQUERY NAME="qHuntID" DATASOURCE="Hunts"> 17 : SELECT MAX (HuntId) as HuntId 18 : FROM DailyHunt ------------------------------------------------------------------------ -------- SQL SELECT MAX (HuntId) as HuntId FROM DailyHunt DATASOURCE Hunts VENDORERRORCODE -3005 SQLSTATE HY000 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Any one knows how to fix this? Thank you!!! Frank V. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3390 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
