ahem... yeah. doh. Thanks Tomo :) ----- Original Message ----- From: "Tomo Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 4:08 PM Subject: Re: [ cf-dev ] has too many arguments specified
> 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] > > -- ** 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]
