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/
