RE: COUNT field incorrect
Without seeing the CFQUERY tag this is just a guess, but that error usually occurs when a) you've mistyped a column name, b) missed single quotes (or used them when you should not have), c) missed commas. --- Ben -Original Message- From: Tom Harris [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:06 PM To: CF-Talk Subject: COUNT field incorrect BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Thanks. Mediacomm Inc Tom Harris, President phone: 888-327-3122 or 517-347-3122 fax: 517-347-3235 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: COUNT field incorrect
An example of the query that is failing, as it is being called would be helpful for debugging purposes. DC - Original Message - From: "Tom Harris" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 13:05 Subject: COUNT field incorrect BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Thanks. Mediacomm Inc Tom Harris, President phone: 888-327-3122 or 517-347-3122 fax: 517-347-3235 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: COUNT field incorrect
BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Without seeing the SQL, some possible ideas; Count is one of the aggrigate functions, so maybe you're trying to run a Count but not specifying properly Field name mis-spelt? Count() of a field that doesn't exist... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
