Even just the COUNT part? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rod Higgins Sent: Friday, 11 July 2003 5:28 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL Server ODBC error
Hi Steve, I actually calling a stored procedure. The procedure is about 1500 lines or so, so I won't post it. Thanks Rod > 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/ --- 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/
