Show the query your using Steve
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rod Higgins Sent: Friday, 11 July 2003 4:18 PM To: CFAussie Mailing List Subject: [cfaussie] SQL Server ODBC error Hi, Don't know if this is a common error or not, cant find much about it via google ... ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error 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. The error appears when calling a stored procedure. The procedure works from iSQL (and perfectly on Sybase before I ported it) and I have made sure all input parameters are passed correctly to the procedure from within the cf template. I updated the ODBC drivers by upgrading MDAC to 2.71 sp1. The only reference to this error I can find from google is using double quotes in the query/sp. I have checked and there is no use of double quotes in the sp?? Config CF4.52 Ent, Win2k sp3, SQL 2000 sp3 any help appreciated thanks Rod --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
