Could it be that you haven't sized your varchars? VARCHAR(50), it may default to something though.
Ade -----Original Message----- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 15:57 To: [EMAIL PROTECTED] Subject: [ cf-dev ] has too many arguments specified Hi all, I've got this error I can't figure from calling an SP: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function selectText has too many arguments specified. The SP looks like this: CREATE PROCEDURE [updateText] @s_textTitle varchar, @s_textBody varchar, @i_textID int AS UPDATE contentText SET textTitle = '@s_textTitle', textBody = '@s_textBody' WHERE textID = @i_textID GO and the calling page: <cfstoredproc datasource="#request.dsn#" procedure="selectText" returncode="no"> <cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@s_textTitle" type="in" value="#form.s_textTitle#"> <cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@s_textBody" type="in" value="#form.s_textBody#"> <cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@i_textID" type="in" value="#form.i_textID#"> </cfstoredproc> Presumably it's something basic... Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
