<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
