Yup, you were right there also. I have just discovered the default is 1 char.
----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 4:12 PM Subject: RE: [ cf-dev ] has too many arguments specified > 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] > > -- ** 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]
