Try changing it to:

cfsqltype="CF_SQL_TIMESTAMP"




-----Original Message-----
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 10:50 PM
To: CF-Talk
Subject: Re: SP pulling my hair out!!!


<cfprocparam type="In"  cfsqltype="CF_SQL_DATE"              variable="3"
value="#3#">
@3 datetime,


This is the culprit.  What is the normal way to handle this?!

Neil



---- Original Message -----
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 10:33 PM
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
> >
> >
> >
> >
>

______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to