hasn't anyone heard of "ALTER PROCEDURE" ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org
-----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:33 PM To: CF-Talk Subject: Re: SP pulling my hair out!!! <cfstoredproc datasource="#DSN#" procedure="sp_MYSP"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="1" value="#1#"> <cfprocparam type="In" cfsqltype="CF_SQL_MONEY" variable="2" value="#2#"> <cfprocparam type="In" cfsqltype="CF_SQL_DATE" variable="3" value="#3#"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="4" value="#4#"> <cfprocparam type="In" cfsqltype="CF_SQL_LONGVARCHAR" variable="5" value="#5#"> <cfprocparam type="In" cfsqltype="CF_SQL_LONGVARCHAR" variable="6" value="#6#"> <cfprocparam type="In" cfsqltype="CF_SQL_LONGVARCHAR" variable="7" value="#7#"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="8" value="#8#"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="9" value="#9#"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="10" value="#10#"> <cfprocparam type="Out" cfsqltype="CF_SQL_INTEGER" variable="11" dbvarname="@11"> </cfstoredproc> IF EXISTS (SELECT name FROM sysobjects WHERE name = 'sp_MYSP' AND type = 'P') DROP PROCEDURE sp_MYSP GO CREATE PROCEDURE sp_MYSP @1 int, @2 money, @3 datetime, @4 int, @5 varchar(100), @6 varchar(30), @7 varchar(30), @8 int, @9 int, @10 int, @11 int OUT Names were changed to protect the innocent Neil ----- Original Message ----- From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 10:02 PM Subject: RE: SP pulling my hair out!!! > 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 > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists