No. It's strange, I have about 25 sp's in this database and every one of them returns this error when called via a cf template?? Yet they all work fine when called via iSQL??
> I gotta ask, > > >> COUNT field incorrect > > there isn't a field called "count" in a table somewhere? > > a parameter or alias called "count" ? > > just an idea > cheers > barry.b > > > > -----Original Message----- > From: Rod Higgins [mailto:[EMAIL PROTECTED] > Sent: Friday, 11 July 2003 5:41 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: SQL Server ODBC error > > > That is the funny part there is no counts or variables named count in the > stored procedure. I just tested a few other sp's on the same database and > I'm receiving the exact same error. It can't be a exec permissions issue > on the sp's as I've setup the ODBC connection using the 'sa' account ??? > I've checked the sp syntax and it is fine .... (*starts to scratch head*). > > > 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/ --- 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/
