np... should have spotted Ade's thing also, but wasn't looking at that part of the code;) ----- Original Message ----- From: "Damian Watson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 4:26 PM Subject: Re: [ cf-dev ] has too many arguments specified
> 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] -- ** 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]
