Procedure or function STOREDPROC has too man

rit01 · January 24th, 2006, 11:44 AM

Hi All

I have this problem and I havenât found the answer to it as yet. Though a few posts in this forum are close.

I have been using Visual Web Developer Express to create a FormView control that updates a SQL database using parameters and a stored procedure.

The error I am receiving is:

Quote:

quote:Procedure or function GUPDATE has too many arguments specified

Quote:

I have checked that I have the same parameters within the UpdateParameters of my ASPX page and my stored proc but still seem to get the error.

Can anyone point me in the right direction as what else I should check.

An example of my parameters are:

Code:

<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="Mail" Type="Boolean" />
<asp:Parameter Name="Gender" Type="Boolean" />
<asp:Parameter Name="Nation" Type="Int32" />

..and the stored proc...

Code:

@Title nvarchar(30),
@FirstName nvarchar(30),
@FamilyName nvarchar(30),
@Mail bit,
@Gender bit,
@Nation int

Many thanks

Rit

Imar · January 24th, 2006, 01:02 PM

Hi Rit,

Take a look at this post: http://p2p.wrox.com/topic.asp?TOPIC_ID=38876

Maybe you're suffering from the original_ problem as well?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar · January 24th, 2006, 01:13 PM

Never mind my previous post, as that doesn't probably apply here.

Take a look here instead: http://www.developersdex.com/asp/mes...P09.phx.gbl%3E

This thread seems to suggest that two way data binding may be the problem. If that doesn't help, can you post the rest of your code?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

rit01 · January 25th, 2006, 09:35 AM

Many thanks Imar,

I created the page using VWD and it seemed to work... shame as now I would like to have known what was causing the error... me or it?... I would say me.

Many thanks for your help though.

Rit

Imar · January 25th, 2006, 09:51 AM

Hi Rit,

Do you still have the old page? Comparing the two might explain the source of the problem....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.