Nope. All correct. Was working fine and then stopped. Is working under SQL Server 2000 just fine.
-----Original Message----- From: Mosh Teitelbaum [mailto:mosh.teitelbaum@;evoch.com] Sent: Thursday, 24 October 2002 10:21 AM To: CF-Talk Subject: RE: It WAS working I tell you... Access sometimes returns this error message if you make reference to an object (table, column, etc.) that does not exist or is not identified in the query. Is it possible that you misspelled one of the column names? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Tilbrook, Peter [mailto:Peter.Tilbrook@;abcb.gov.au] > Sent: Wednesday, October 23, 2002 7:06 PM > To: CF-Talk > Subject: It WAS working I tell you... > > > 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