Error Diagnostic InformationODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = "SELECT * FROM CombinedData WHERE occ_code LIKE '47%' ORDER BY occ_title" Data Source = "MAAGCOMOUDATA2" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:1) to (6:58) in the template file C:\Inetpub\virtuals\maagcom.com\data\wake\oesdata2.cfm. Date/Time: 09/04/10 23:48:09 |