first off... you don't need the quotes around the vars in your stored procedure, also your proc is called "updatetext" and not "selecttext".
<cfstoredproc datasource="#request.dsn#" procedure="selectText" returncode="no"> should be <cfstoredproc datasource="#request.dsn#" procedure="updateText" returncode="no"> ----- Original Message ----- From: "Damian Watson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 3:57 PM 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: > > > <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]
