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:3389 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
