 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / October 2007Error message with stored procedure
Could someone help me, I'm getting this error message: Procedure or function UpdateResources has too many arguments specified. Here's my stored procedure, I am trying to update four columns, two are in the same table and two are in different tables. Any suggestions? CREATE PROCEDURE [UpdateResources] (@titleID int, @title varchar (255), @description varchar (2047), @quantityowned int) AS Update Titles SET [title]=@title, [description]=@description where titleID=@titleid Update classifications set [description]=@description Update resources set [quantityowned]=@quantityowned GO I have two columns called description, on in the titles table and one in the classification table. Thanks! This error message appears when you try to call a stored procedure and supply more parameters than those declared for that procedure. Look at the code where you call the UpdateResources procedure and check that you pass the correct parameter list. HTH, Plamen Ratchev http://www.SQLStudio.com > This error message appears when you try to call a stored procedure and > supply more parameters than those declared for that procedure. Look at the [quoted text clipped - 4 lines] > > Plamen Ratchevhttp://www.SQLStudio.com I've checked everything and can't figure it out. Here's the code on the other page any suggestions? <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TrainUserConnectionString %>" SelectCommand="GetResourceLibraryInfo" SelectCommandType="StoredProcedure" UpdateCommand="UpdateResources" UpdateCommandType="StoredProcedure"> <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" DefaultValue="1" Name="Type" PropertyName="SelectedValue" Type="String" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="titleID" Type="Int32" /> <asp:Parameter Name="title" Type="String" /> <asp:Parameter Name="description" Type="String" /> <asp:Parameter Name="quantityowned" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> I see only the definition for the update parameters, not the actual data binding. Look at the asp:BoundField tags and make sure the DataField values are correct and there is no duplication of names. Data bound fields automatically are added to a collection that gets submitted as parameters. See more details here: http://msdn2.microsoft.com/en-us/library/ms228051.aspx Also, make sure that ConflictDetection (a property of the data source) is not set to CompareAllValues (it is set to OverwriteChanges by default). If you have it set to CompareAllValues then two sets of parameters are passed, one for the updated and one for the original values. HTH, Plamen Ratchev http://www.SQLStudio.com Forgot to say - a good way to troubleshoot something like this is to use SQL Profiler to see what SQL statements actually get submitted. Plamen Ratchev http://www.SQLStudio.com > Forgot to say - a good way to troubleshoot something like this is to use SQL > Profiler to see what SQL statements actually get submitted. > > Plamen Ratchevhttp://www.SQLStudio.com okay Thanks will try that. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.