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
