I'm getting this wierd error under CFMX (with updater applied) with the following query:
<cfquery name="LookupCategories" datasource="#DataSourceName#"> SELECT CategoryID, CategoryName, CategoryDescription, CategoryAdded, CategoryCreator FROM Categories ORDER BY CategoryName ASC </cfquery> The error I am getting is: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The Error Occurred in C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 Called from C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 6 : ORDER BY 7 : CategoryName ASC 8 : </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
