Hi, At first glance I'd say rename HuntID something else. Also, if memory serves, when you use Max in a SQL statement you need the Group By clause after the FROM clause.
SELECT MAX (HuntId) as MaxHuntId or something like that. Maybe that will work. Renee > 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:3391 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
