Colin,
For the #user_created# variable, declare it like this -
<cfprocparam null="no" cfsqltype="cf_sql_timestamp"
dbvarname="@user_created"
type="In" value="#attributes.value10#">
Change cfsqltype from "CF_SQL_DATE" to "CF_SQL_TIMESTAMP".
Regards
Guy
-----Original Message-----
From: Colin Robinson [mailto:[EMAIL PROTECTED]]
Sent: Friday, 20 July 2001 11:21 PM
To: SQL
Subject: RE: ODBC Error Code = 07001 (Wrong number of parameters)
That is what I am doing but for the sake of making it clear what I was
passing I have used the result of that code
Colin
> -----Original Message-----
> From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
> Sent: 20 July 2001 13:57
> To: SQL
> Subject: RE: ODBC Error Code = 07001 (Wrong number of parameters)
>
>
> I wonder if SQL thinks you're trying to pass a string rather
> than a date...
> have you tried #CreateODBCDate(attributes.value10)#?
>
> Orlando
>
>
> -----Original Message-----
> From: Colin Robinson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 6:08 AM
> To: SQL
> Subject: RE: ODBC Error Code = 07001 (Wrong number of parameters)
>
>
> I have just discovered that if I change the data type of
> @user_created from
> cf_sql_date to cf_sql_varchar in the cf code and change the
> data type of the
> corresponding column in the database to varchar it works
> fine. I am however
> still unclear why the cf_sql_date data type would be ausing problems.
>
> Any ideas?
>
> Colin
>
> > -----Original Message-----
> > From: Colin Robinson [mailto:[EMAIL PROTECTED]]
> > Sent: 20 July 2001 12:53
> > To: SQL
> > Subject: RE: ODBC Error Code = 07001 (Wrong number of parameters)
> >
> >
> > I have double checked the data types and they all match.
> >
> > user_customer_id is not an identity field and in my original
> > code the bit
> > fields are hard coded to 0
> >
> > I am assuming that as the stored procedure works in query
> > analyser and that
> > even if I hard code the values into each cfprocparam it still
> > will not work
> > from cf that I must have something wrong in my cf tags but
> I cant see
> > anything.
> >
> > The hard coded sp gives the same error :
> >
> > <cfstoredproc datasource="mline" procedure="insertusers">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_forename"
> > type="In" value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_surname" type="In"
> > value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_email" type="In"
> > value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_customer_id"
> > type="In" value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_username"
> > type="In" value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_password"
> > type="In" value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_question"
> > type="In" value="a">
> > <cfprocparam cfsqltype="cf_sql_varchar"
> > dbvarname="@user_answer" type="In"
> > value="a">
> > <cfprocparam cfsqltype="cf_sql_bit"
> > dbvarname="@user_enabled" type="In"
> > value="0">
> > <cfprocparam cfsqltype="cf_sql_date"
> > dbvarname="@user_created" type="In"
> > value="{ts '2001-07-20 10:03:58'}">
> > <cfprocparam cfsqltype="cf_sql_bit"
> > dbvarname="@user_canbedeleted"
> > type="In" value="0">
> > <cfprocparam cfsqltype="cf_sql_integer"
> > dbvarname="@user_grouplevel"
> > type="In" value="0">
> > </cfstoredproc>
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: 20 July 2001 12:12
> > > To: SQL
> > > Subject: Re: ODBC Error Code = 07001 (Wrong number of parameters)
> > >
> > >
> > > Colin,
> > > Seems like I remember that error being caused by the wrong
> > > datatype. ie
> > > Trying to enter numeric data in a text field or vice versa..
> > > Looking you variables. Some questions come to mind.
> > > user_customer_id -- is that a varchar? is it an identity
> > > field? I would
> > > expect an error here if you are trying to insert a value into
> > > an identity
> > > field.
> > > user_canbedeleted and user_enabled bit fields are going to
> > be required
> > > fields are you passing
> > > 1 or 0 to these fields.
> > >
> > > I usually set a default value in the table for bit fields
> > > either 0 or 1.
> > >
> > > Jeff Craig
> > >
> > > ----- Original Message -----
> > > From: "Colin Robinson" <[EMAIL PROTECTED]>
> > > To: "SQL" <[EMAIL PROTECTED]>
> > > Sent: Friday, July 20, 2001 4:31 AM
> > > Subject: RE: ODBC Error Code = 07001 (Wrong number of parameters)
> > >
> > >
> > > > The stored procedure works fine from query analyser and changing
> > > > the cfsqltype does not appear to help.
> > > >
> > > > Any other suggestions ?
> > > >
> > > > TIA
> > > >
> > > > Colin
> > > >
> > > > > -----Original Message-----
> > > > > From: Correa, Orlando (ITSC)
> > [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 19 July 2001 22:48
> > > > > To: SQL
> > > > > Subject: RE: ODBC Error Code = 07001 (Wrong number of
> > parameters)
> > > > >
> > > > >
> > > > > If you can call the sp from query analyzer and it works
> > > > > fine... you might
> > > > > want to see if changing the CFSQLTYPE from
> > > > > CFSQLTYPE="CF_SQL_VARCHAR" to
> > > > > CFSQLTYPE="CF_SQL_LONGVARCHAR" on @user_question helps any...
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Colin Robinson [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, July 19, 2001 7:17 AM
> > > > > To: SQL
> > > > > Subject: ODBC Error Code = 07001 (Wrong number of parameters)
> > > > >
> > > > >
> > > > > I can't see the wood for the trees ! I can not seem to work
> > > > > out why I am
> > > > > getting the error message below. I have included the
> > > error message the
> > > > > stored procedure and the code, if anyone can see the mistake
> > > > > I have made it
> > > > > would be much appreciated.
> > > > >
> > > > > Colin
> > > > >
> > > > > <----- error message --------->
> > > > >
> > > > > 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 stored procedure --------->
> > > > >
> > > > > CREATE PROCEDURE insertusers
> > > > >
> > > > > ( @user_forename [varchar](50),
> > > > > @user_surname [varchar](50),
> > > > > @user_email [varchar](50),
> > > > > @user_customer_id [varchar](50),
> > > > > @user_username [varchar](50),
> > > > > @user_password [varchar](50),
> > > > > @user_question [varchar](500),
> > > > > @user_answer [varchar](50),
> > > > > @user_enabled [bit],
> > > > > @user_created [datetime],
> > > > > @user_canbedeleted [bit],
> > > > > @user_grouplevel [int]
> > > > > )
> > > > >
> > > > > AS INSERT INTO users ( user_forename,
> > > > > user_surname,
> > > > > user_email,
> > > > > user_customer_id,
> > > > > user_username,
> > > > > user_password,
> > > > > user_question,
> > > > > user_answer,
> > > > > user_enabled,
> > > > > user_created,
> > > > > user_canbedeleted,
> > > > > user_grouplevel
> > > > > )
> > > > >
> > > > > VALUES ( @user_forename,
> > > > > @user_surname,
> > > > > @user_email,
> > > > > @user_customer_id,
> > > > > @user_username,
> > > > > @user_password,
> > > > > @user_question,
> > > > > @user_answer,
> > > > > @user_enabled,
> > > > > @user_created,
> > > > > @user_canbedeleted,
> > > > > @user_grouplevel
> > > > > )
> > > > >
> > > > >
> > > > > <----- The coldfusion code --------->
> > > > >
> > > > > <cfstoredproc datasource="mline" procedure="insertusers"
> > > > > returncode="yes"
> > > > > debug>
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_forename" type="In"
> > value="#attributes.value1#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_surname"
> > > > > type="In" value="#attributes.value2#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_email"
> > > > > type="In" value="#attributes.value3#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_customer_id" type="In"
> > > value="#attributes.value4#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_username" type="In"
> > value="#attributes.value5#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_password" type="In"
> > value="#attributes.value6#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_question" type="In"
> > value="#attributes.value7#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_varchar"
> > > > > dbvarname="@user_answer"
> > > > > type="In" value="#attributes.value8#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_bit"
> > > > > dbvarname="@user_enabled"
> > > > > type="In" value="#attributes.value9#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_date"
> > > > > dbvarname="@user_created"
> > > > > type="In" value="#attributes.value10#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_bit"
> > > > > dbvarname="@user_canbedeleted" type="In"
> > > value="#attributes.value11#">
> > > > > <cfprocparam null="no" cfsqltype="cf_sql_integer"
> > > > > dbvarname="@user_grouplevel" type="In"
> > > value="#attributes.value12#">
> > > > > </cfstoredproc>
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
