Neil, better post your code - hard to deal with this error without looking at it.
Mark -----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 8:46 PM To: CF-Talk Subject: SP pulling my hair out!!! I only have a little hair left so PLEASE throw ideas at me! I get this error: 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. I have tested the SP and it works properly. The stored procedure does exist and I copied and pasted every single variable name from the stored procedure. There is no way the field doesn't exist and I Have counted that the number of variables is identical. What could I be missing!!!? Neil ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
