Procedure Or Function '' Has Too Many Arguments Specified.
Im getting this error when looping through a gridview. Im trying to save each row into the database. The weird thing is that it saves the first row, but errors out on the second.
If I only add one item to the gridview, it works. The second row is screwing it up somehow.
Any ideas?
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Some of my code to get an idea of how im doing it:
(This
is for a shopping cart. It displays the products in the shopping cart.
If the order is approved by the CC processing company, each product
entry is saved in the DB. The gridview is being populated by my
ShoppingCart Profile Object.)
SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["rdevie"].ConnectionString);
SqlCommand objCmd = new SqlCommand("InsertOrderDetails", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objConn.Open();
foreach (GridViewRow row in gvOrderDetails.Rows)
{
objCmd.Parameters.Add("@idOrder", SqlDbType.Int).Value = orderNum;
objCmd.Parameters.Add("@fldName", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblName")).Text;
objCmd.Parameters.Add("@fldUnitPrice", SqlDbType.Money).Value = ((Label)row.FindControl("lblUnitPrice")).Text;
objCmd.Parameters.Add("@fldQuantity", SqlDbType.Int).Value = Convert.ToInt32(((Label)row.FindControl("lblQuantity")).Text);
if (!String.IsNullOrEmpty(((Label)row.FindControl("lblSku")).Text))
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSku")).Text;
else
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = DBNull.Value;
objCmd.Parameters.Add("@fldSize", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSize")).Text;
objCmd.Parameters.Add("@fldLogo", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblLogo")).Text;
objCmd.Parameters.Add("@fldPlacement", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblPlacement")).Text;
objCmd.Parameters.Add("@fldColor", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblColor")).Text;
objCmd.ExecuteNonQuery();
}
objCmd.Dispose();
objConn.Close();
objConn.Dispose();
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Argument Not Specified For Parameter 'arguments' Of Public Function Select(arguments As System.Web.DatasourceSelect Arguments As Collections Ienumerable
I have an SqlDataSource control on my aspx page, this is connected to database by a built in procedure that returns a string dependent upon and ID passed in. I have the followinbg codewhich is not complet, I woiuld appriciate any help to produce the correct code for the code file Function GetCategoryName(ByVal ID As Integer) As String sdsCategoriesByID.SelectParameters("ID").Direction = Data.ParameterDirection.Input sdsCategoriesByID.SelectParameters.Item("ID").DefaultValue = 3 sdsCategoriesByID.Select() <<<< THIS LINE COMES UP WITH ERROR 1End Function ERROR AS FOLLOWS argument not specified for parameter 'arguments' of public function Select(arguments as System.Web.DatasourceSelect Arguments as Collections ienumerable Help I have not got much more hair to loose Thanks Steve
View Replies !
View Related
Gridview / SqlDataSource Error - Procedure Or Function &<stored Procedure Name&> Has Too Many Arguments Specified.
Can someone help me with this issue? I am trying to update a record using a sp. The db table has an identity column. I seem to have set up everything correctly for Gridview and SqlDataSource but have no clue where my additional, phanton arguments are being generated. If I specify a custom statement rather than the stored procedure in the Data Source configuration wizard I have no problem. But if I use a stored procedure I keep getting the error "Procedure or function <sp name> has too many arguments specified." But thing is, I didn't specify too many parameters, I specified exactly the number of parameters there are. I read through some posts and saw that the gridview datakey fields are automatically passed as parameters, but when I eliminate the ID parameter from the sp, from the SqlDataSource parameters list, or from both (ID is the datakey field for the gridview) and pray that .net somehow knows which record to update -- I still get the error. I'd like a simple solution, please, as I'm really new to this. What is wrong with this picture? Thank you very much for any light you can shed on this.
View Replies !
View Related
SqlDataSource.SelectParameters Causing Procedure Or Function Stored Procedure Has Too Many Arguments Specified.
Hi everybody, I am having trouble how to fixed this code. I am trying to supply the parameterinside a stored procedure with a value, and displays error message shown below. If I did not supply the parameter with a value, it works. How to fix this?Error Message:Procedure or function <stored proc name> has too many arguments specified.Thanks,den2005 Stored procedure: Alter PROCEDURE [dbo].[sp_GetIdeaByCategory] @CatId <span class="kwd">int</span> = 0 AS BEGIN SET NOCOUNT ON; Select I.*, C.*, U.* From Idea I inner join IdeaCategory C on I.CategoryID = C.IdeaCategoryID inner join Users U on I.UserID = U.UserID Where I.CategoryID = @CatId Order By LastModifiedDate Desc End oDataSource.ConnectionString = constr; oDataSource.SelectCommand = storedProc;<span class="cmt">//storedproc - sp_GetIdeaByCategory</span> oDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; oDataSource.SelectParameters.Add(<span class="st">"@CatId"</span>, catId); gdvCategories.DataSourceID = oDataSource.ID; gdvCategories.DataBind(); <<--- Error occured here
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
Hi,I have a simple stored procedure that basically SELECT some data from database. I am calling this stored procedure using a sqldatasource. The first time I try it, it works perfectly fine. But I get the error message "Procedure or function has too many arguments specified" the second time I try to search for thing. This is the code that I have that called the stored procedure: Session("SearchItem") = txtSearch.Text.Trim SqlDataSource1.SelectCommand = "_MyStoredProcedure" SqlDataSource1.SelectParameters.Add("SearchItem", Session("SearchItem")) SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure Gridview1.DataSourceID = "SqlDataSource1" Gridview1.DataBind() The following is the code in the stored procedure: CREATE PROCEDURE [dbo].[_MyStoredProcedure] ( @SearchItem nvarchar(255) = NULL)ASSELECT Field1, Field2, Field3 FROM Registration WHERE((@SearchItem IS NULL) OR (Field1 LIKE '%' + @SearchItem + '%') OR (Field2 LIKE '%' + @SearchItem + '%'))GO Please help.Stan
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
I have a Typed Dataset in an applcation <<Table structure in database is also same as Dataset>> <xs:element name="WC_CMNT_TXT"> <xs:complexType> <xs:sequence> <xs:element name="WC_CMNT_TXT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" msdata:AutoIncrementSeed="-2" msdata:AutoIncrementStep="-1" /> <xs:element name="WC_RSPRC_ID" type="xs:int" /> <xs:element name="WC_CMNT_TYP_ID" type="xs:int" /> <xs:element name="CMNT_TXT" type="xs:string" minOccurs="0" /> <xs:element name="ENT_TISTMP" msdata:ReadOnly="true" type="xs:dateTime" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> First Column is a Primary key. CMNT_TXT is fetched using WC_RSPRC_ID and WC_CMNT_TYP_ID and binded to a text box. if no row is returned then empty row s created in a dataset by this.dsCommentText.WC_CMNT_TXT.AddWC_CMNT_TXTRow(132,9,String.Empty,System.DateTime.Now); Till here it s working fine. Now when i update the data in a database using data-adapter , i get the error message as "Procedure or function AddWC_CMNT_TXT has too many arguments specified" Insert Commnad is as below : SqlDataAdapter da = new SqlDataAdapter(); da.TableMappings.Add("Table","WC_CMNT_TXT"); #region Insert Command SqlCommand cmdInsert = new SqlCommand(); cmdInsert.UpdatedRowSource = UpdateRowSource.OutputParameters; cmdInsert.CommandText = "cas_wrkstn_dbo.AddWC_CMNT_TXT"; cmdInsert.CommandType = System.Data.CommandType.StoredProcedure; cmdInsert.Parameters.Add(new SqlParameter("@cmnt_txt", SqlDbType.VarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "CMNT_TXT", DataRowVersion.Current, null)); cmdInsert.Parameters.Add(new SqlParameter("@wc_rsprc_id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "WC_RSPRC_ID", DataRowVersion.Current, null)); cmdInsert.Parameters.Add(new SqlParameter("@wc_cmnt_typ_id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "WC_CMNT_TYT_ID", DataRowVersion.Current, null)); cmdInsert.Parameters.Add(new SqlParameter("@wc_cmnt_txt_id", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "WC_CMNT_TXT_ID", DataRowVersion.Current, null)); cmdInsert.Parameters.Add(new SqlParameter("@ent_tistmp", SqlDbType.DateTime, 8, ParameterDirection.Output, false, 0, 0, "ENT_TISTMP", DataRowVersion.Original, null)); da.InsertCommand = cmdInsert; Stored Procedure s : ALTER procedure AddWC_CMNT_TXT ( @cmnt_txt varchar(5000), @wc_cmnt_typ_id int, @wc_rsprc_id int, @wc_cmnt_txt_id int output, @ent_tistmp datetime output ) as set nocount on; declare @error int; insert into WC_CMNT_TXT ( CMNT_TXT , WC_RSPRC_ID, WC_CMNT_TYP_ID, ENT_TISTMP ) values ( @cmnt_txt , @wc_rsprc_id , @wc_cmnt_typ_id, getdate() ) if @@rowcount = 1 begin select @wc_cmnt_txt_id = WC_CMNT_TXT_ID , @ent_tistmp = ENT_TISTMP from WC_CMNT_TXT with (nolock) where (WC_CMNT_TXT_ID = scope_identity()) end select @error = @@error return @error Please suggest wht to do
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
Hello All, I am having a very strange problem which I cannot figure out. I am using the ASP.NET 2.0 SqlDataSource control to insert a news item into a SQL Express database. When inserting the a message I receive the following error: Procedure or function has too many arguments specified However according to me every thing adds up. Can anyone please help me figure out what is wrong? Here is the code: SqlDataSource: <asp:SqlDataSource ID="sqlNews" runat="server" ConnectionString="<%$ ConnectionStrings:FlevoOptiekDB %>" SelectCommandType="StoredProcedure" SelectCommand="dbo.usp_News_ByID" InsertCommandType="StoredProcedure" InsertCommand="dbo.usp_News_Insert" UpdateCommandType="StoredProcedure" UpdateCommand="dbo.usp_News_Update" DeleteCommandType="StoredProcedure" DeleteCommand="dbo.usp_News_Delete" OldValuesParameterFormatString="{0}"> <SelectParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iNewsID" /> <asp:Parameter Name="p_iAlbumID" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iAlbumID" /> </InsertParameters> <DeleteParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </DeleteParameters> </asp:SqlDataSource>Stored procedure:ALTER PROCEDURE dbo.usp_News_Insert( @p_sTitle VARCHAR(256), @p_sDescription TEXT, @p_sStaticUrl VARCHAR(256), @p_dtmPublished DATETIME, @p_iPhotoID INT, @p_iAlbumID INT)AS /* SET NOCOUNT ON */ INSERT INTO dbo.tbNews(news_Title, news_Description, news_StaticUrl, news_Published, photo_ID, album_ID) VALUES(@p_sTitle, @p_sDescription, @p_sStaticUrl, @p_dtmPublished, @p_iPhotoID, @p_iAlbumID) RETURN Thanks, Maurits
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
I have two tables: Person (member_no, name) and Participant (participant, member_no) member_no is the primary key in Person.The stored procedure is:CREATE PROCEDURE dbo.InsertRecs@member_no char(10),@name char(10),@participant char(10)ASbegininsert into person (member_no, name)values (@member_no, @name)select @member_no = @@Identityinsert into participant (participant, member_no)values (@participant, @member_no)endGOWhen I run this via the DetailsView control and try to insert a record I always get "Procedure or function InsertRecs has too many arguments specified"If I remove the second table from the stored procedure it works fine.Does anyone have any ideas?
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
Hi there I'm a newbie to ASP.net development.I'm getting this error message "Procedure or function has too many arguments specified." when inserting/editing/deleting data from the formview control. I executed the stored procedures and had no problems with it but when executed from the web page i encountered the error message mentioned earlier. Would appreciate it very much if someone can point out what it is that i'm doing wrong. Thanks in advance. Customer table:Customer_ID nchar(10), primary keyFname varchar(50)Lname varchar(50)Job_ID smallint Stored Procedures:1) InsertCustomersALTER PROCEDURE dbo.InsertCustomers@CustID nchar(10),@FName varchar(50),@LName varchar(50),@JobID smallintASInsert into Customers (Customer_ID, FName, LName, Job_ID)Values (@CustID, @FName, @LName, @JobID)RETURN 2) UpdateCustomersALTER PROCEDURE dbo.UpdateCustomers@FName varchar(50),@LName varchar(50),@JobID smallint,@CustID nchar(10)ASUpdate Customers set FName = @FName, LName = @LName, Job_ID = @JobIDWhere Customer_ID = @CustID RETURN 3) DeleteCustomersALTER PROCEDURE dbo.DeleteCustomers@CustID nchar(10)ASDelete Customers where Customer_ID = @CustID RETURN Web Page:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default4.aspx.vb" Inherits="Default4" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <table width="100%"> <tr> <td colspan="2"> <asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="Customer_ID" DataSourceID="SqlDataSource1" Width="100%"> <EditItemTemplate> Customer_ID: <asp:Label ID="Customer_IDLabel1" runat="server" Text='<%# Eval("Customer_ID") %>'> </asp:Label><br /> Fname: <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'> </asp:TextBox><br /> lname: <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'> </asp:TextBox><br /> job_id: <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'> </asp:TextBox><br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> </asp:LinkButton> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </EditItemTemplate> <InsertItemTemplate> Customer_ID: <asp:TextBox ID="Customer_IDTextBox" runat="server" Text='<%# Bind("Customer_ID") %>'> </asp:TextBox><br /> Fname: <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'> </asp:TextBox><br /> lname: <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'> </asp:TextBox><br /> job_id: <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'> </asp:TextBox><br /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> </asp:LinkButton> <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </InsertItemTemplate> <ItemTemplate> Customer_ID: <asp:Label ID="Customer_IDLabel" runat="server" Text='<%# Eval("Customer_ID") %>'> </asp:Label><br /> Fname: <asp:Label ID="FnameLabel" runat="server" Text='<%# Bind("Fname") %>'></asp:Label><br /> lname: <asp:Label ID="lnameLabel" runat="server" Text='<%# Bind("lname") %>'></asp:Label><br /> job_id: <asp:Label ID="job_idLabel" runat="server" Text='<%# Bind("job_id") %>'></asp:Label><br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> </asp:LinkButton> <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> </asp:LinkButton> <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New"> </asp:LinkButton> </ItemTemplate> </asp:FormView> </td> </tr> <tr> <td colspan="2"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>" InsertCommand="InsertCustomers" InsertCommandType="StoredProcedure" SelectCommand="SelectCustomers" SelectCommandType="StoredProcedure" UpdateCommand="UpdateCustomers" UpdateCommandType="StoredProcedure" DeleteCommand="DeleteCustomers" DeleteCommandType="StoredProcedure"> <InsertParameters> <asp:Parameter Name="CustID" Type="String" /> <asp:Parameter Name="FName" Type="String" /> <asp:Parameter Name="LName" Type="String" /> <asp:Parameter Name="JobID" Type="Int16" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="FName" Type="String" /> <asp:Parameter Name="LName" Type="String" /> <asp:Parameter Name="JobID" Type="Int16" /> <asp:Parameter Name="CustID" Type="String" /> </UpdateParameters> <DeleteParameters> <asp:Parameter Name="CustID" Type="String" /> </DeleteParameters> </asp:SqlDataSource> </td> </tr> <tr> <td colspan="2"> </td> </tr> </table> </form></body></html>
View Replies !
View Related
Procedure Or Function Has Too Many Arguments Specified
Hi there I'm a newbie to ASP.net development.I'm getting this error message "Procedure or function has too many arguments specified." when inserting/editing/deleting data from the formview control. I executed the stored procedures and had no problems with it but when executed from the web page i encountered the error message mentioned earlier. Would appreciate it very much if someone can point out what it is that i'm doing wrong. Thanks in advance. Customer table:Customer_ID nchar(10), primary keyFname varchar(50)Lname varchar(50)Job_ID smallint Stored Procedures:1) InsertCustomersALTER PROCEDURE dbo.InsertCustomers@CustID nchar(10),@FName varchar(50),@LName varchar(50),@JobID smallintASInsert into Customers (Customer_ID, FName, LName, Job_ID)Values (@CustID, @FName, @LName, @JobID)RETURN 2) UpdateCustomersALTER PROCEDURE dbo.UpdateCustomers@FName varchar(50),@LName varchar(50),@JobID smallint,@CustID nchar(10)ASUpdate Customers set FName = @FName, LName = @LName, Job_ID = @JobIDWhere Customer_ID = @CustID RETURN 3) DeleteCustomersALTER PROCEDURE dbo.DeleteCustomers@CustID nchar(10)ASDelete Customers where Customer_ID = @CustID RETURN Web Page:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default4.aspx.vb" Inherits="Default4" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <table width="100%"> <tr> <td colspan="2"> <asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="Customer_ID" DataSourceID="SqlDataSource1" Width="100%"> <EditItemTemplate> Customer_ID: <asp:Label ID="Customer_IDLabel1" runat="server" Text='<%# Eval("Customer_ID") %>'> </asp:Label><br /> Fname: <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'> </asp:TextBox><br /> lname: <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'> </asp:TextBox><br /> job_id: <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'> </asp:TextBox><br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> </asp:LinkButton> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </EditItemTemplate> <InsertItemTemplate> Customer_ID: <asp:TextBox ID="Customer_IDTextBox" runat="server" Text='<%# Bind("Customer_ID") %>'> </asp:TextBox><br /> Fname: <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'> </asp:TextBox><br /> lname: <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'> </asp:TextBox><br /> job_id: <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'> </asp:TextBox><br /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> </asp:LinkButton> <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </InsertItemTemplate> <ItemTemplate> Customer_ID: <asp:Label ID="Customer_IDLabel" runat="server" Text='<%# Eval("Customer_ID") %>'> </asp:Label><br /> Fname: <asp:Label ID="FnameLabel" runat="server" Text='<%# Bind("Fname") %>'></asp:Label><br /> lname: <asp:Label ID="lnameLabel" runat="server" Text='<%# Bind("lname") %>'></asp:Label><br /> job_id: <asp:Label ID="job_idLabel" runat="server" Text='<%# Bind("job_id") %>'></asp:Label><br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> </asp:LinkButton> <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> </asp:LinkButton> <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New"> </asp:LinkButton> </ItemTemplate> </asp:FormView> </td> </tr> <tr> <td colspan="2"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>" InsertCommand="InsertCustomers" InsertCommandType="StoredProcedure" SelectCommand="SelectCustomers" SelectCommandType="StoredProcedure" UpdateCommand="UpdateCustomers" UpdateCommandType="StoredProcedure" DeleteCommand="DeleteCustomers" DeleteCommandType="StoredProcedure"> <InsertParameters> <asp:Parameter Name="CustID" Type="String" /> <asp:Parameter Name="FName" Type="String" /> <asp:Parameter Name="LName" Type="String" /> <asp:Parameter Name="JobID" Type="Int16" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="FName" Type="String" /> <asp:Parameter Name="LName" Type="String" /> <asp:Parameter Name="JobID" Type="Int16" /> <asp:Parameter Name="CustID" Type="String" /> </UpdateParameters> <DeleteParameters> <asp:Parameter Name="CustID" Type="String" /> </DeleteParameters> </asp:SqlDataSource> </td> </tr> <tr> <td colspan="2"> </td> </tr> </table> </form></body></html>
View Replies !
View Related
Procedure Or Function Has Too Many Arguments
Dear all,I have the following stored proc:-SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS OFF GOALTER PROCEDURE dbo.stpLoginUser(@login Varchar(255),@password Varchar(255),@email Varchar(255) OUTPUT,@username Varchar(255) OUTPUT,@id int OUTPUT)ASBEGIN/*Check for valid login and password*/SET @username = ' 'Select @id = id_u, @username = first_name, @email = email from pod_Users where email = @login AND u_password = @passwordENDGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOand basically the user enters a username and a password.However I got the following error:-Procedure or function has too many argumentsI tried renaming my stored proc name but to no avail.I am calling this stored proc from a vb.net program as follows:-Dim conn As SqlConnectionDim cmd As SqlCommandDim RetVal As Integer = -1Dim FullName As String' create the conection object for scalar reader to useconn = New SqlConnectionconn.ConnectionString = ConnectionString' return the players pk_playercmd = New SqlCommandcmd.CommandType = CommandType.StoredProcedurecmd.Connection = conncmd.CommandText = "stpLoginUser"cmd.Parameters.Add("@login", SqlDbType.NVarChar, 255)cmd.Parameters("@login").Value = usernamecmd.Parameters.Add("@password", SqlDbType.NVarChar, 255)cmd.Parameters("@password").Value = passwordcmd.Parameters.Add("@username", SqlDbType.NVarChar, 255)cmd.Parameters("@username").Direction = ParameterDirection.Outputcmd.Parameters.Add("@email", SqlDbType.NVarChar, 255)cmd.Parameters("@email").Direction = ParameterDirection.Outputcmd.Parameters.Add("@id", SqlDbType.Int)cmd.Parameters("@id").Direction = ParameterDirection.OutputTryconn.Open()cmd.ExecuteNonQuery()RetVal = cmd.Parameters("@id").Value()FullName = cmd.Parameters("@username").Value()'CatchCatch e As ExceptionConsole.WriteLine(e.ToString()) ' Print the error message to the user.RetVal = -1Finallyconn.Close()End TryCan anybody help me pls?Thanks for your help
View Replies !
View Related
Procedure Or Function Sppaintinsert Has Too Many Arguments Specified, Please Help
Hi,I cant see why this will not work, when i run the page and try and perform a function it clicks me out and underlines SQLCommand.ExecuteNonQuery() with this error Procedure or function sppaintinsert has too many arguments specified Code below: Imports System.IO Imports System.Data Imports System.Data.SqlClientPartial Class admin Inherits System.Web.UI.PageProtected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click Dim strFileName As String Dim strFilePath As String Dim strFolder As String Dim strPicTitle As StringDim SQLConnection As Data.SqlClient.SqlConnectionDim SQLCommand As Data.SqlClient.SqlCommand strFolder = "C:Documents and SettingsRoss HintonMy DocumentsVisual Studio 2005WebSitesjessicawebsitePictures" strFileName = oFile.PostedFile.FileName strFileName = Path.GetFileName(strFileName) strPicTitle = TextBox1.Text If (Not Directory.Exists(strFolder)) Then Directory.CreateDirectory(strFolder) End If strFilePath = strFolder & strFileName If File.Exists(strFilePath) Then lblUploadResult.Text = strFileName & " already exists on the server!" ElseSQLConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|picturesdb.mdf;Integrated Security=True;User Instance=True")SQLCommand = New SqlCommand SQLCommand.CommandType = CommandType.StoredProcedure If DropDownList.SelectedItem.Value = 0 Then SQLCommand.CommandText = "paintingpictures" Else SQLCommand.CommandText = "spdrawinsert" End If SQLCommand.Connection = SQLConnection SQLConnection.Open() SQLCommand.Parameters.AddWithValue("@image", "Pictures" + strFileName) ' sp parameter nameSQLCommand.Parameters.AddWithValue("@Title", strPicTitle) SQLCommand.ExecuteNonQuery() oFile.PostedFile.SaveAs(strFilePath) lblUploadResult.Text = strFileName & " has been successfully uploaded." End If frmConfirmation.Visible = TrueEnd Sub End ClassALTER PROCEDURE paintingpictures @image VARCHAR(50) AS INSERT INTO pictable([image]) VALUES (@image)
View Replies !
View Related
Procedure Or Function &<stored_procedure_name&> Has Too Many Arguments Specified.
Thanks in advance, I am getting the "Procedure or function JobsDb_Development_Update has too many arguments specified." error. Below is the sp and the vwd generated sqldatasource, any suggestions? Thanks Nick Update Stored Procedure: ALTER PROCEDURE [dbo].[JobsDb_Development_Update] @sDevelopmentArea varchar(255), @sDevelopmentGoals text, @sDevelopmentPlans text, @sCurrentStatus text, @sFutureState text, @sDetermineFactor text, @bMentorRequested bit,@sMentorList text, @dtCheckPointDate datetime, @dtDateUpdated datetime, @iPlanPKID int AS UPDATE JobsDb_Development SET DevelopmentArea = @sDevelopmentArea, DevelopmentGoals = @sDevelopmentGoals, DevelopmentPlans = @sDevelopmentPlans, CurrentStatus = @sCurrentStatus, FutureState = @sFutureState, DetermineFactor = @sDetermineFactor, MentorRequested = @bMentorRequested, MentorList = @sMentorList, CheckPointDate = @dtCheckPointDate, DateUpdated = @dtDateUpdated WHERE (PlanPKID = @iPlanPKID) SQL Data Source: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyProviderConnectionString %>" DeleteCommand="JobsDb_Development_Delete" DeleteCommandType="StoredProcedure" InsertCommand="JobsDb_Development_Insert" InsertCommandType="StoredProcedure" SelectCommand="JobsDb_Development_SelectOne" SelectCommandType="StoredProcedure" UpdateCommand="JobsDb_Development_Update" UpdateCommandType="StoredProcedure"> <SelectParameters> <asp:ControlParameter ControlID="txtUserName" Name="sUserName" PropertyName="Text" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="iPlanPKID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="sDevelopmentGoals" Type="String" /> <asp:Parameter Name="sDevelopmentPlans" Type="String" /> <asp:Parameter Name="sCurrentStatus" Type="String" /> <asp:Parameter Name="sFutureState" Type="String" /> <asp:Parameter Name="sDetermineFactor" Type="String" /> <asp:Parameter Name="bMentorRequested" Type="Boolean" /> <asp:Parameter Name="sMentorList" Type="String" /> <asp:Parameter Name="dtCheckPointDate" Type="DateTime" /> <asp:Parameter Name="dtDateUpdated" Type="DateTime" /> <asp:Parameter Name="iPlanPKID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="sUserName" Type="String" /> <asp:Parameter Name="sDevelopmentArea" Type="String" /> <asp:Parameter Name="sDevelopmentGoals" Type="String" /> <asp:Parameter Name="sDevelopmentPlans" Type="String" /> <asp:Parameter Name="sCurrentStatus" Type="String" /> <asp:Parameter Name="sFutureState" Type="String" /> <asp:Parameter Name="sDetermineFactor" Type="String" /> <asp:Parameter Name="bMentorRequested" Type="Boolean" /> <asp:Parameter Name="sMentorList" Type="String" /> <asp:Parameter Name="dtCheckPointDate" Type="DateTime" /> <asp:Parameter Name="dtDateAdded" Type="DateTime" /> <asp:Parameter Name="dtDateUpdated" Type="DateTime" /> <asp:Parameter Direction="InputOutput" Name="iPlanPKID" Type="Int32" /> </InsertParameters> </asp:SqlDataSource>
View Replies !
View Related
HELP!!! - Procedure Or Function SpInsertNewProduct Has Too Many Arguments Specified
Hi All, I'm getting this annoying message when I try to call my Sp on an insert. I've executed the SP straight from SQL Server 2005 Express and it works fine. but I think I have a problem how I'm calling it. The SP------------------------------------------------------------------------- ALTER PROCEDURE dbo.spInsertNewProduct( @productName nvarchar(50), @productSummary text, @productDesc text, @productPhoto int, @productFeaturelist text, @productTestimonials text, @productFile1 int, @productFile1_Title nvarchar(50), @productFile2 int, @productFile1_Title nvarchar(50), @NewProductID int OUTPUT)AS -- inserts new product INSERT INTO [tbl_products] ([productName], [productSummary], [productDesc], [productPhoto], [productFeaturelist], [productTestimonials], [productFile1], [productFile1_Title], [productFile2], [productFile2_Title]) VALUES (@productName, @productSummary, @productDesc, @productPhoto, @productFeaturelist, @productTestimonials, @productFile1, @productFile1_Title, @productFile2, @productFile2_Title); -- Read the just-inserted productID into @NewProductID SET @NewProductID = SCOPE_IDENTITY(); ------------------------------------------------------------------------- The DataSource------------------------------------------------------------------------- <asp:SqlDataSource ID="dsproduct" runat="server" ConnectionString="<%$ ConnectionStrings:myConn %>" InsertCommand="spInsertNewProduct" InsertCommandType="StoredProcedure"> <InsertParameters> <asp:Parameter Name="productName" Type="String" /> <asp:Parameter Name="productSummary" Type="String" /> <asp:Parameter Name="productDesc" Type="String" /> <asp:Parameter Name="productPhoto" Type="String" /> <asp:Parameter Name="productFeaturelist" Type="String" /> <asp:Parameter Name="productTestimonials" Type="String" /> <asp:Parameter Name="productFile1" Type="String" /> <asp:Parameter Name="productFile1_Title" Type="String" /> <asp:Parameter Name="productFile2" Type="String" /> <asp:Parameter Name="productFile2_Title" Type="String" /> <asp:Parameter Direction="Output" Name="NewProductID" Type="Int32" /> </InsertParameters> </asp:SqlDataSource>------------------------------------------------------------------------- In code behind I grab params from front end dropdowns:------------------------------------------------------------------------- Sub InsertProduct(ByVal Src As Object, ByVal Args As DetailsViewInsertEventArgs) dsProduct.InsertParameters("productPhoto").DefaultValue = CType(dvEditProduct.FindControl("ddlProdImage"), DropDownList).SelectedValue dsProduct.InsertParameters("productFile1").DefaultValue = CType(dvEditProduct.FindControl("ddlProdFile1"), DropDownList).SelectedValue dsProduct.InsertParameters("productFile2").DefaultValue = CType(dvEditProduct.FindControl("ddlProdFile2"), DropDownList).SelectedValue lblStatus.Text = "Product has been added to the database" End Sub------------------------------------------------------------------------- I can't see how in the VB front end file how there can be too many params? Any help is greatly appreciated!
View Replies !
View Related
Procedure Or Function StoredProcedure1 Has Too Many Arguments Specified
Hi, I keep on getting the same error for my stored procedure:System.Data.SqlClient.SqlException: Procedure or function StoredProcedure1 has too many arguments specified.The procedure itself looks like this:@imie varchar(255), @nazwisko varchar(255), @email varchar(255), @username varchar(255), @password varchar(255), @id_roli Int, @PESEL varchar(11), @ulica text, @numer_domu int, @numer_mieszkania int, @kod_pocztowy varchar(7), @miasto text, @telefon text, @id_kandydat int, @id_kierunku int, @id_stan int ASBeginSet nocount on Insert into Uzytkownik (imie, nazwisko, email, username, password, id_roli, PESEL, ulica, numer_domu, numer_mieszkania, kod_pocztowy, miasto, telefon) values ( @imie, @nazwisko, @email, @username, @password, @id_roli, @PESEL, @ulica, @numer_domu, @numer_mieszkania, @kod_pocztowy, @miasto, @telefon) select @id_kandydat=@@IDENTITY Insert into Kandydat_na_Kierunek (id_kandydat, id_kierunku, id_stan) Values (@id_kandydat, @id_kierunku, @id_stan) SET NOCOUNT OFF ENDand the code that uses it: SqlConnection con; con = new SqlConnection("Data Source=ELF;Initial Catalog=logos;Integrated Security=True"); SqlCommand cmd = new SqlCommand("StoredProcedure1", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@imie", TextBox3.Text)); cmd.Parameters.Add(new SqlParameter("@nazwisko", TextBox4.Text)); cmd.Parameters.Add(new SqlParameter("@email", TextBox6.Text)); cmd.Parameters.Add(new SqlParameter("@username", Label2.Text)); cmd.Parameters.Add(new SqlParameter("@password", Label1.Text)); cmd.Parameters.Add(new SqlParameter("@id_roli", '1')); cmd.Parameters.Add(new SqlParameter("@PESEL", TextBox5.Text)); cmd.Parameters.Add(new SqlParameter("@ulica", TextBox8.Text)); cmd.Parameters.Add(new SqlParameter("@numer_domu", TextBox9.Text)); cmd.Parameters.Add(new SqlParameter("@numer_mieszkania", TextBox10.Text)); cmd.Parameters.Add(new SqlParameter("@kod_pocztowy", TextBox11.Text)); cmd.Parameters.Add(new SqlParameter("@miasto", TextBox12.Text)); cmd.Parameters.Add(new SqlParameter("@telefon", TextBox13.Text)); if (DropDownList1.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList1.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } if (DropDownList2.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList2.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } if (DropDownList3.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList3.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } con.Open(); cmd.ExecuteNonQuery(); con.Close();Could somebody explain what is wrong with this? I dpn't really unserstand the meaning of error. Any help will be apreaciated.Regards,N.
View Replies !
View Related
Procedure Or Function SavePhotoHotelLang Has Too Many Arguments Specified.
Hi all I having suffering from a strange behavior when trying to update. I receive the following error : Here is my code: Procedure or function SavePhotoHotelLang has too many arguments specified. <asp:SqlDataSource ID="SqlDataSourceHotelPhotoList" runat="server" ConnectionString="<%$ ConnectionStrings:smileDBConnectionString %>"SelectCommand="SELECT phl.PhotoHotelLangId, ph.smallfilepath, ph.photorank, pht.Type, phl.name, phl.description, ph.PhotoHotelId FROM datPhotoHotel ph INNER JOIN datPhotoHotelType pht ON ph.PhotoHotelTypeId = pht.PhotoHotelTypeId LEFT OUTER JOIN datPhotoHotelLang phl on ph.PhotoHotelId = phl.PhotoHotelId WHERE HotelId = @HotelId and ( LanguageId = @languageId or LanguageId is null)" UpdateCommand="SavePhotoHotelLang" UpdateCommandType="StoredProcedure"> <SelectParameters> <asp:QueryStringParameter Name="HotelId" QueryStringField="HotelId" Type="int32" /> <asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue" Type="int32" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="name"/> <asp:Parameter Name="Description" /> <asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue"/> <asp:Parameter Name="PhotoHotelLangId" /> <asp:Parameter Name="PhotoHotelId" /> </UpdateParameters> </asp:SqlDataSource> <Grids:BulkEditGridView ID="GvHotelPhotoList" runat="server" DataSourceID="SqlDataSourceHotelPhotoList" AutoGenerateColumns="false" SaveButtonID="saveBtn" DataKeyNames="PhotoHotelLangId, PhotoHotelId"> <Columns> <asp:TemplateField> <itemtemplate> <asp:Image id="smallimage" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image> </itemtemplate> <Edititemtemplate> <asp:Image id="smallimageedit" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image> </Edititemtemplate> </asp:TemplateField> <asp:BoundField DataField="Name" HeaderText="Name"/> <asp:BoundField DataField="Description" FooterText="Description"/> <asp:BoundField DataField="photorank" HeaderText="Rank" ReadOnly="true"/> <asp:BoundField DataField="Type" FooterText="Type" ReadOnly="true"/> </Columns></Grids:BulkEditGridView> ">'>'> alter procedure SavePhotoHotelLang @name varchar(100), @Description varchar(500), @languageId int, @PhotoHotelLangId int, @PhotoHotelId intasbegin if ( @PhotoHotelLangId is null ) begin insert into dbo.datPhotoHotelLang ( name, Description, languageId ) values (@name, @Description, @languageId, @PhotoHotelId) end else begin update dbo.datPhotoHotelLang set name = @name, Description = @Description where PhotoHotelLangId = @PhotoHotelLangId endend
View Replies !
View Related
Procedure Or Function DeleteSender Has Too Many Arguments Specified.
I'm Deleting my record in the database using stored procedure and I'm always getting this error :Procedure or function DeleteSender has too many arguments specified. same as I insert record... here's my stored proc for delete:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[DeleteSender]@RecNo int ASDELETE FROM [Sender] WHERE [RecNo] = @RecNo for insert:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[InsertSender](@SenderID nvarchar(50), @SenderLastName nvarchar(50), @SenderFirstName nvarchar(50), @SenderAddress nvarchar(50), @SenderCity nvarchar(50), @SenderState nvarchar(25), @SenderZip nvarchar(10), @SenderTel nvarchar(25), @FS int, @TB int, @Status nvarchar(10), @EndBalance money)ASINSERT INTO [Sender] ([SenderID], [SenderLastName], [SenderFirstName], [SenderAddress], [SenderCity], [SenderState], [SenderZip], [SenderTel], [FS], [TB], [Status], [EndBalance]) VALUES (@SenderID, @SenderLastName, @SenderFirstName, @SenderAddress, @SenderCity, @SenderState, @SenderZip, @SenderTel, @FS, @TB, @Status, @EndBalance) aspx:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %><%@ Register src="FormControl.ascx" TagName="FormControl" TagPrefix="uc1" %><%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %><%@ Register Assembly="RadComboBox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %><%@ Register Assembly="RadInput.Net2" Namespace="Telerik.WebControls" TagPrefix="radI" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Sender</title> <link href="sender.css" rel="stylesheet" type="text/css" /></head><body> <form id="form1" runat="server"> <div class="wrapper"> <div class="banner"> <radG:RadGrid ID="rgSender" runat="server" GridLines="None" DataSourceID="sqlDataSource1" EnableAJAX="True" ShowStatusBar="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" Skin="3D" AutoGenerateColumns="False"> <MasterTableView CommandItemDisplay="Top" DataKeyNames="RecNo" DataSourceID="sqlDataSource1"> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> <EditFormSettings EditFormType="Template"> <FormTemplate> <table border="0"> <tr> <td> <asp:Label ID="Label1" runat="server" Text="Record No.:" Visible='<%# rgSender.EditIndexes.Count > 0 %>'></asp:Label></td> <td> <radI:RadTextBox ID="rtbRecNo" runat="server" Text='<%# Bind("RecNo") %>' Visible='<%# rgSender.EditIndexes.Count > 0 %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label8" runat="server" Text="Zip Code:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbZip" runat="server" Text='<%# Bind("SenderZip") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label2" runat="server" Text="Sender ID:"></asp:Label></td> <td><radI:RadTextBox ID="rtbSenderID" runat="server" Text='<%# Bind("SenderID") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label9" runat="server" Text="Telephone #:"></asp:Label></td> <td><radI:RadTextBox ID="rtbTel" runat="server" Text='<%# Bind("SenderTel") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label3" runat="server" Text="First Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFName" runat="server" Text='<%# Bind("SenderFirstName") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label10" runat="server" Text="Total Free Sent:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFS" runat="server" Text='<%# Bind("FS") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label4" runat="server" Text="Last Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbLName" runat="server" Text='<%# Bind("SenderLastName") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label11" runat="server" Text="Total Box Sent:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbBS" runat="server" Text='<%# Bind("TB") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label5" runat="server" Text="Address:"></asp:Label></td> <td><radI:RadTextBox ID="rtbAddress" runat="server" Text='<%# Bind("SenderAddress") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label12" runat="server" Text="Status:"></asp:Label></td> <td><radI:RadTextBox ID="rtbStatus" runat="server" Text='<%# Bind("Status") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label6" runat="server" Text="City:"> </asp:Label></td> <td> <radI:RadTextBox ID="rtbCity" runat="server" Text='<%# Bind("SenderCity") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label13" runat="server" Text="End Balance:"></asp:Label></td> <td><radI:RadTextBox ID="rtbEndBalance" runat="server" Text='<%# Bind("EndBalance") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label7" runat="server" Text="State:"></asp:Label></td> <td><radI:RadTextBox ID="rtbState" runat="server" Text='<%# Bind("SenderState") %>'> </radI:RadTextBox> </td> <td> <asp:Button ID="btnUpdate" Text='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"Insert","Update") %>' runat="server" CommandName='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"PerformInsert","Update") %>'></asp:Button> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button></td> </tr> </table> </FormTemplate> </EditFormSettings> <Columns> <radG:GridEditCommandColumn ButtonType="ImageButton"/> <radG:GridTemplateColumn HeaderText="Sender ID" UniqueName="TCSenderID"> <ItemTemplate> <asp:Label ID="lblSenderID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderID") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="First Name" UniqueName="TCSenderFName"> <ItemTemplate> <asp:Label ID="lblSenderFName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderFirstName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="Last Name" UniqueName="TCSenderLName"> <ItemTemplate> <asp:Label ID="lblSenderLName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderLastName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridButtonColumn UniqueName="ButtonColumn" ConfirmText="Are you sure?" Text="Delete" CommandName="Delete" ButtonType="ImageButton" ImageUrl="RadControls/Grid/Skins/Default/Delete.gif" /> </Columns> </MasterTableView> </radG:RadGrid></div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConString_TO_Cargo %>" SelectCommandType="StoredProcedure" SelectCommand="sp_SelectSender" DeleteCommandType="StoredProcedure" DeleteCommand="DeleteSender" InserCommandType="StoredProcedure" InsertCommand="InsertSender" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Sender] SET [SenderID] = @SenderID, [SenderLastName] = @SenderLastName, [SenderFirstName] = @SenderFirstName, [SenderAddress] = @SenderAddress, [SenderCity] = @SenderCity, [SenderState] = @SenderState, [SenderZip] = @SenderZip, [SenderTel] = @SenderTel, [FS] = @FS, [TB] = @TB, [Status] = @Status, [EndBalance] = @EndBalance WHERE [RecNo] = @original_RecNo AND [SenderID] = @original_SenderID AND [SenderLastName] = @original_SenderLastName AND [SenderFirstName] = @original_SenderFirstName AND [SenderAddress] = @original_SenderAddress AND [SenderCity] = @original_SenderCity AND [SenderState] = @original_SenderState AND [SenderZip] = @original_SenderZip AND [SenderTel] = @original_SenderTel AND [FS] = @original_FS AND [TB] = @original_TB AND [Status] = @original_Status AND [EndBalance] = @original_EndBalance"> <DeleteParameters> <asp:Parameter Name="RecNo" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> <asp:Parameter Name="original_RecNo" Type="Int32" /> <asp:Parameter Name="original_SenderID" Type="String" /> <asp:Parameter Name="original_SenderLastName" Type="String" /> <asp:Parameter Name="original_SenderFirstName" Type="String" /> <asp:Parameter Name="original_SenderAddress" Type="String" /> <asp:Parameter Name="original_SenderCity" Type="String" /> <asp:Parameter Name="original_SenderState" Type="String" /> <asp:Parameter Name="original_SenderZip" Type="String" /> <asp:Parameter Name="original_SenderTel" Type="String" /> <asp:Parameter Name="original_FS" Type="Int32" /> <asp:Parameter Name="original_TB" Type="Int32" /> <asp:Parameter Name="original_Status" Type="String" /> <asp:Parameter Name="original_EndBalance" Type="Decimal" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> </InsertParameters> </asp:SqlDataSource> <br /> <radG:RadGrid ID="rgSenderDetails" runat="server" AutoGenerateColumns="False" GridLines="None"> <MasterTableView> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> </MasterTableView> </radG:RadGrid><br /> </div> </form></body></html> hope you can help me guys/// stings...
View Replies !
View Related
Procedure Or Function InsertUpdateArtist_Tracks Has Too Many Arguments Specified.
Hi While coding with ASP.NET 2.0 I came across this error "Procedure or function InsertUpdateArtist_Tracks has too many arguments specified." Its quite frustrating because I dont know what arguments are being referred to because I've clearly assigned the correct parameters with their correct values to this Stored procedure :InsertUpdateArtist_Tracks Please can some help me with this? is there something fundamentality wrong with my code (Below) or is this a know Microsoft stuff up? or by the way I'm using SQL Server 2005 and ASP.NET 2.0 Below is my sample code: .............. 'Insert or Update Artist_tracks table Response.Write("<br><b>Inserting or Updating Artist_tracks table</b>") AT_Title = SearchArtistsResults(i).title AT_Meta_ID = SearchArtistsResults(i).meta_id AT_AA_ID = AA_ID Dim ParamTitle As SqlParameter Dim ParamMeta As SqlParameter Dim ParamAA_ID As SqlParameter dbCommand.CommandText = "InsertUpdateArtist_Tracks" dbCommand.CommandType = Data.CommandType.StoredProcedure dbCommand.Connection = conn ParamTitle = dbCommand.Parameters.Add(New SqlParameter("@AT_Title", Data.SqlDbType.VarChar, 50)) ParamTitle.Value = AT_Title ParamTitle.Direction = Data.ParameterDirection.Input Response.Write("<br>Sent through this Title =" & AT_Title) ParamMeta = dbCommand.Parameters.Add(New SqlParameter("@AT_Meta_ID", Data.SqlDbType.Int)) ParamMeta.Value = AT_Meta_ID ParamMeta.Direction = Data.ParameterDirection.Input Response.Write("<br>Sent through this Meta_id =" & AT_Meta_ID) ParamAA_ID = dbCommand.Parameters.Add(New SqlParameter("@AT_AA_ID", Data.SqlDbType.Int)) ParamAA_ID.Value = AT_AA_ID ParamAA_ID.Direction = Data.ParameterDirection.Input Response.Write("<br>Sent through this AT_AA_ID =" & AT_AA_ID) conn.Open() dbCommand.ExecuteNonQuery() conn.Close() .................. Thanks in Advance
View Replies !
View Related
Error: Procedure Or Function Has Too Many Arguments Specified
Hi, I've found that I'm not the first one to get the error "Procedure or function x has too many arguments specified" while working with Stored Procedures (which is no surprise at all). But all suggested solutions didn't help, maybe this is because I misunderstood the whole concept. The situation is: On my page there is a FormView control including the EditItemTemplate. The database contains a Stored Procedure called UpdatePersonByID which is working fine as long as executed in Visual Web Developer. Here's the procedure code: ALTER PROCEDURE dbo.UpdatePersonByID ( @LastName varchar(50), @FirstName varchar(50), @Phone varchar(50), @PhonePrivate varchar(50), @PhoneMobile varchar(50), @Email varchar(50) ) AS UPDATE tblPersons SET PersonLastName = @LastName, PersonFirstName = @FirstName, PersonPhone = @Phone, PersonPhonePrivate = @PhonePrivate, PersonPhoneMobile = @PhoneMobile, PersonEmail = @Email WHERE PersonLastName = @LastName RETURN This is not exactly what it will finally have to do, of course the WHERE-clause later will contain an ID comparison. But since I tried to break down my code as much as possible I changed it to what you see right now. Here's the aspx-source (the red stuff is what I think is important): <%@ Page Language="VB" MasterPageFile="fb10.master" AutoEventWireup="false" CodeFile="codebehind/staff.aspx.vb" Inherits="staff" meta:ResourceKey="PageResource" %> <%@ MasterType VirtualPath ="~/fb10.master" %> <asp:Content ID="ContentStaff" ContentPlaceHolderID="cphContentMain" Runat="Server"> <h3 id="hdStaff" runat="server" meta:resourcekey="Staff" /> <!-- DataSource srcStaff collects all persons from staff table in database. --> <asp:SqlDataSource ID="srcStaff" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="SelectPersonNames" /> <asp:DropDownList ID="ddlStaff" runat="server" DataSourceID="srcStaff" DataTextField="CompleteName" DataValueField="PersonID" AutoPostBack="True"> </asp:DropDownList> <!-- DataSource srcPerson gets person selected in DropDownList "ddlStaff". --> <asp:SqlDataSource ID="srcPerson" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SelectPersonByID" SelectCommandType="StoredProcedure" UpdateCommand="UpdatePersonByID" UpdateCommandType="StoredProcedure" OldValuesParameterFormatString="{0}" > <SelectParameters> <asp:ControlParameter ControlID="ddlStaff" DefaultValue="1" Name="ID" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="LastName" Type="String" /> <asp:Parameter Name="FirstName" Type="String" /> <asp:Parameter Name="Phone" Type="String" /> <asp:Parameter Name="PhonePrivate" Type="String" /> <asp:Parameter Name="PhoneMobile" Type="String" /> <asp:Parameter Name="Email" Type="String" /> </UpdateParameters> </asp:SqlDataSource> <!-- DataSource srcBuildings gets all buildings from building table in database. --> <asp:SqlDataSource ID="srcBuildings" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SelectBuildings" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:FormView ID="fvStaff" runat="server" DataSourceID="srcPerson"> <EditItemTemplate> <!-- DataSource srcRooms gets all rooms from room table in database. --> <asp:SqlDataSource ID="srcRooms" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SelectRoomsByBuildingID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:ControlParameter ControlID="ddlBuildings" DefaultValue="1" Name="ID" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> <asp:Label cssClass="lblIdentifier" ID="lblLastName" runat="server" meta:resourcekey="LastName" /> <asp:TextBox cssClass="staff" ID="LastName" runat="server" Text='<%# Bind("PersonLastName") %>'></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblFirstName" runat="server" meta:resourcekey="FirstName" /> <asp:TextBox cssClass="staff" ID="FirstName" runat="server" Text='<%# Bind("PersonFirstName") %>'></asp:TextBox><br /> <asp:Label CssClass="lblIdentifier" ID="lblBuilding" runat="server" meta:resourcekey="Building"></asp:Label> <asp:DropDownList ID="ddlBuildings" cssClass="small" runat="server" DataSourceID="srcBuildings" DataTextField="BuildingAbbreviation" DataValueField="BuildingID" AutoPostBack="True" SelectedValue='<%# Bind("RoomBuildingID") %>' OnSelectedIndexChanged="ddlBuildings_SelectedIndexChanged"> </asp:DropDownList><br /> <asp:Label cssClass="lblIdentifier" ID="lblRoom" runat="server" meta:resourcekey="Room" /> <asp:DropDownList ID="ddlRooms" cssClass="small" runat="server" DataSourceID="srcRooms" DataTextField="RoomName" DataValueField="RoomID" AutoPostBack="true" SelectedValue='<%# Bind("PersonRoomID") %>'> </asp:DropDownList><br /> <asp:Label cssClass="lblIdentifier" ID="lblPhone" runat="server" meta:resourcekey="Phone" /> <asp:TextBox cssClass="staff" ID="Phone" runat="server" Text='<%# Bind("PersonPhone") %>'></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblPhonePrivate" runat="server" meta:resourcekey="Private" /> <asp:TextBox cssClass="staff" ID="PhonePrivate" runat="server" Text='<%# Bind("PersonPhonePrivate") %>'></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server" meta:resourcekey="Mobile" /> <asp:TextBox cssClass="staff" ID="PhoneMobile" runat="server" Text='<%# Bind("PersonPhoneMobile") %>'></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblEmail" runat="server" meta:resourcekey="Email" /> <asp:TextBox cssClass="staff" ID="Email" runat="server" Text='<%# Bind("PersonEmail") %>'></asp:TextBox><br /> <asp:LinkButton cssClass="lnkButton" ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="<%$resources:translations, Cancel%>"></asp:LinkButton> <asp:LinkButton cssClass="lnkButton" ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="<%$resources:translations, Update%>"></asp:LinkButton> </EditItemTemplate> <InsertItemTemplate> <asp:Label cssClass="lblIdentifier" ID="lblLastName" runat="server" meta:resourcekey="LastName" /> <asp:TextBox ID="PersonLastNameTextBox" runat="server"></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblFirstName" runat="server" meta:resourcekey="FirstName" /> <asp:TextBox ID="PersonFirstNameTextBox" runat="server"></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblBuilding" runat="server" meta:resourcekey="Building" /> <asp:TextBox ID="BuildingAbbreviationTextBox" runat="server"></asp:TextBox><br /> <asp:Label cssClass="lblIdentifier" ID="lblRoom" runat="server" meta:resourcekey="Room" /> <asp:TextBox ID="RoomNameTextBox" runat="server"></asp:TextBox><br /> <asp:LinkButton cssClass="lnkButton" ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="<%$resources:translations, Cancel%>"></asp:LinkButton> <asp:LinkButton cssClass="lnkButton" ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="<%$resources:translations, Insert%>"></asp:LinkButton> </InsertItemTemplate> <ItemTemplate> <asp:Label cssClass="lblIdentifier" ID="lblLastName" runat="server" meta:resourcekey="LastName" /> <asp:Label cssClass="lblValue" ID="PersonLastNameLabel" runat="server" Text='<%# Bind("PersonLastName") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblFirstName" runat="server" meta:resourcekey="FirstName" /> <asp:Label cssClass="lblValue" ID="PersonFirstNameLabel" runat="server" Text='<%# Bind("PersonFirstName") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblBuilding" runat="server" meta:resourcekey="Building" /> <asp:Label cssClass="lblValue" ID="BuildingAbbreviationLabel" runat="server" Text='<%# Bind("BuildingAbbreviation") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblRoom" runat="server" meta:resourcekey="Room" /> <asp:Label cssClass="lblValue" ID="RoomLabel" runat="server" Text='<%# Bind("RoomName") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblPhone" runat="server" meta:resourcekey="Phone" /> <asp:Label cssClass="lblValue" ID="PhoneLabel" runat="server" Text='<%# Bind("PersonPhone") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lplPhonePrivate" runat="server" meta:resourcekey="Private" /> <asp:Label cssClass="lblValue" ID="PhonePrivateLabel" runat="server" Text='<%# Bind("PersonPhonePrivate") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server" meta:resourcekey="Mobile" /> <asp:Label cssClass="lblValue" ID="PhoneMobileLabel" runat="server" Text='<%# Bind("PersonPhoneMobile") %>'></asp:Label><br /> <asp:Label cssClass="lblIdentifier" ID="lblEmail" runat="server" meta:resourcekey="Email" /> <asp:Label cssClass="lblValue" ID="EmailLabel" runat="server" Text='<%# Bind("PersonEmail") %>'></asp:Label><br /> <asp:LinkButton cssClass="lnkButton" ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="<%$resources:translations, Delete%>"></asp:LinkButton> <asp:LinkButton cssClass="lnkButton" ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="<%$resources:translations, Edit%>"></asp:LinkButton> </ItemTemplate> </asp:FormView> </asp:Content> And then once again a totally different question: Is there a way to post the highlighted aspx or vb code into this forum and keep the colors? i think I've seen that in some posts but didn't wanna do it manually. Thanks once again for trying to help, Toob
View Replies !
View Related
Procedure Or Function ImportLand Has Too Many Arguments Specified
Can anybody help me with this error? I am not even sure where to start looking. i am looping through an arrayList that populates the SqlParameters. I open the database outside the loop, close it outside the loop and execute myCommand.ExecuteNonQuery(); inside the loop for every loop. The error I am getting is: System.Data.SqlClient.SqlException: Procedure or function ImportData has too many arguments specified. Thanks!
View Replies !
View Related
Procedure Or Function Recoms Has Too Many Arguments Specified
my sql procedure is like below select * from tbl where ID in (@IDs) for example @IDs is "11,23,44,55,66,77,88,99,223,223,445,666" So it has alot of arguments.sometimes it can be too long that's the reason to get error message What must I do ?
View Replies !
View Related
Procedure Or Function Login Has Too Many Arguments Specified
i wrote a simply code but i got error " Procedure or function Login has too many arguments specified." i need help....... (c# code- stored procedure is below c# code) -------------- SqlConnection conn = new SqlConnection("data source=cafe06\sqlexpress;initial catalog=ferixxx;Integrated Security=True"); SqlCommand sqlcom = new SqlCommand("Login", conn); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("@user", SqlDbType.NVarChar,50 ); sqlcom.Parameters[0].Value = user.Text;--->>>(textbox) sqlcom.Parameters.Add("@password", SqlDbType.NVarChar,50); sqlcom.Parameters[1].Value = password.Text;--->>>(textbox) SqlDataAdapter adap = new SqlDataAdapter(sqlcom); DataTable table = new DataTable(); conn.Open(); adap.Fill(table); datag.DataSource = table; datag.DataBind(); conn.Close(); stored procedure create procedure [Login] @user nvarchar(50), @password nvarchar(50) AS select *from members where user=@user and password=@password GO
View Replies !
View Related
Procedure Or Function Sp_MSupdatesysmergearticles Has Too Many Arguments Specified.
Hi, I've been on this one all day - and now tearing my hair out. I have a large SQL2005 database (migrated from SQL2000) which I'm trying to replicate using a VB6 front end. The application and database concerned have been working with no problems using merge replication for the last 5 years - however, I now need to port to SQL 2005. In the VB6 app, I'm using the SQLMerge9 control to handle the replication side of things. The code I'm using is exactly as per the code which works under SQL 2000, however, I'm getting an error message "Procedure or function sp_MSupdatesysmergearticles has too many arguments specified." when I try to initialize the subscription. I've seen one other item on the web with this problem, and this was someone trying to replicate a 2005 client with a 2000 server. I'm using SQL2005 both ends with merge replication -the replication is set up for SQL2005 clients only, and the database (which incidentally is being created on the subscriber correctly) is in SQL2005 compatibility mode. Any help would be gratefully appreciated - I haven't got much hair left now. The code I'm using is as follows: On Error GoTo Err_Handler Set SQLMergeCtl = New SQLMerge Dim strSQL As String Dim cnn As ADODB.Connection ' add subscriber strSQL = "EXEC sp_dropsubscriber '[subscriber name]'" Set cnn = New ADODB.Connection cnn.Open [connection string] strSQL = "EXEC sp_addsubscriber '[machine name]', 0 , '[user name]', '[password]', @security_mode = 0" On Error Resume Next cnn.Execute strSQL If Err <> 0 Then MsgBox Error End If strSQL = "sp_dropmergesubscription @publication = '[publication name], @subscriber = '[machine name]', @subscriber_db = '[subscriber database name]', @subscription_type = 'pull'" cnn.Execute strSQL If Err <> 0 Then MsgBox Error End If On Error GoTo Err_Handler cnn.Close Set cnn = Nothing SQLMergeCtl.Publisher = [publisher name] SQLMergeCtl.PublisherSecurityMode = DB_AUTHENTICATION SQLMergeCtl.PublisherDatabase = [database name] SQLMergeCtl.Publication = [publication name] SQLMergeCtl.PublisherLogin = [user name] SQLMergeCtl.PublisherPassword = [password] SQLMergeCtl.DistributorSecurityMode = DB_AUTHENTICATION SQLMergeCtl.Distributor = [distributor name - actually same as the publisher] SQLMergeCtl.DistributorLogin = [user name] SQLMergeCtl.DistributorPassword =[password] SQLMergeCtl.Subscriber = [local machine name] SQLMergeCtl.SubscriberSecurityMode = DB_AUTHENTICATION SQLMergeCtl.SubscriberLogin = [local user name] SQLMergeCtl.SubscriberPassword =[local password] SQLMergeCtl.SubscriberDatabase = [local database name] SQLMergeCtl.SubscriptionType = PULL SQLMergeCtl.ProfileName =[profile name] On Error Resume Next SQLMergeCtl.AddSubscription CREATE_DATABASE, NONE If Err <> 0 Then <--snip--> End If On Error GoTo Err_Handler SQLMergeCtl.Initialize 'Run SQLMergeCtl.Run 'Terminate SQLMergeCtl.Terminate <--snip--> code here to add merge agent removed for brevity - it's not getting this far anyway <--snip> Exit_Handler: Exit Sub Err_Handler: MsgBox Error Resume Exit_Handler
View Replies !
View Related
Procedure Or Function Sp_AddDealer Has Too Many Arguments Specified (error Via SqlDataSource)
Procedure or function sp_AddDealer has too many arguments specified. I am experiencing the 'too many arguments specified' error. I am running on SQL 2005. The Parameters lists on SQL server (when I view a dropdown under the sp name) shows a 'returns integer' (but without the @ the signifies a parameter).I have looked around the forums and haven't seen quite this flavor of this error. My forehead is sore from beating it against the wall... any clue would be appreciated! The error occurs when I click the 'new' link button, enter some data and then click the update link button after ... BOOM - Procedure or function sp_AddDealer has too many arguments specified. Thanks!! Chip Kigar Here is the stored Procedure: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo ALTER PROCEDURE [dbo].[sp_AddDealer] @sCarcareSystem varchar(100), @sDealerName varchar(50), @sDealerPhysAddrStreet varchar(200), @sDealerPhysAddrCity varchar(100), @sDealerPhysAddrState varchar(10), @sDealerPhysAddrZip varchar(20), @nReturnCode bigint output, @nReturnId bigint output AS SET NOCOUNT ON DECLARE @m_nCt bigint SET @nReturnCode = 0 SET @nReturnId = 0 -- VALIDATE IF (@nReturnCode = 0) BEGIN SELECT @m_nCt = COUNT(tblDealers.[_DealerId]) FROM tblDealers WHERE [Dealer Name] = @sDealerName IF (@m_nCt >0) BEGIN SET @nReturnCode = -2000 --'Error for exsiting Dealer' SET @nReturnId = 0 END END -- PROCESS IF (@nReturnCode = 0) BEGIN SET @nReturnCode = -2 --' Error getting new record id' DECLARE @m_nNewRecId bigint SET @m_nNewRecId = 0 EXEC sp_GetNewRecId @m_nNewRecId output IF (@m_nNewRecId > 0) BEGIN SET @nReturnCode = -1 --'Error adding Dealer' INSERT INTO tblDealers ( [_DealerId], [Carcare System], [Dealer Name], [Dealer Phys Addr Street], [Dealer Phys Addr City], [Dealer Phys Addr State], [Dealer Phys Addr Zip] ) VALUES ( @m_nNewRecId, @sCarcareSystem, @sDealerName, @sDealerPhysAddrStreet, @sDealerPhysAddrCity, @sDealerPhysAddrState, @sDealerPhysAddrZip ) SET @nReturnCode = 0 --'Success' SET @nReturnId = @m_nNewRecId END END Here is the SQLDataSource. I plugged the ID parameter, so I got a schema back, but no data. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="sp_AddDealer" InsertCommandType="StoredProcedure" SelectCommand="sp_GetDealerByDealerId" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:Parameter DefaultValue="2" Name="nDealerId" Type="Int64" /> <asp:Parameter DefaultValue="" Direction="Output" Name="nReturnCode" Type="Int64" /> <asp:Parameter Direction="Output" Name="nReturnId" Type="Int64" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="sCarcareSystem" Type="String" /> <asp:Parameter Name="sDealerName" Type="String" /> <asp:Parameter Name="sDealerPhysAddrStreet" Type="String" /> <asp:Parameter Name="sDealerPhysAddrCity" Type="String" /> <asp:Parameter Name="sDealerPhysAddrState" Type="String" /> <asp:Parameter Name="sDealerPhysAddrZip" Type="String" /> <asp:Parameter Direction="InputOutput" Name="nReturnCode" Type="Int64" /> <asp:Parameter Direction="InputOutput" Name="nReturnId" Type="Int64" /> </InsertParameters> </asp:SqlDataSource> Here is the Formview: <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"> <EditItemTemplate> _DealerId: <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:TextBox><br /> Carcare System: <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:TextBox><br /> Dealer Name: <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:TextBox><br /> Address Street: <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:TextBox><br /> Address City: <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:TextBox><br /> Address State: <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:TextBox><br /> Address Zip: <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:TextBox><br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> </asp:LinkButton> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </EditItemTemplate> <InsertItemTemplate> _DealerId: <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:TextBox><br /> Carcare System: <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:TextBox><br /> Dealer Name: <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:TextBox><br /> Address Street: <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:TextBox><br /> Address City: <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:TextBox><br /> Address State: <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:TextBox><br /> Address Zip: <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:TextBox><br /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> </asp:LinkButton> <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </InsertItemTemplate> <ItemTemplate> _DealerId: <asp:Label ID="_DealerIdLabel" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:Label><br /> Carcare System: <asp:Label ID="Carcare_SystemLabel" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:Label><br /> Dealer Name: <asp:Label ID="Dealer_NameLabel" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:Label><br /> Address Street: <asp:Label ID="Address_StreetLabel" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:Label><br /> Address City: <asp:Label ID="Address_CityLabel" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:Label><br /> Address State: <asp:Label ID="Address_StateLabel" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:Label><br /> Address Zip: <asp:Label ID="Address_ZipLabel" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:Label><br /> <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New"> </asp:LinkButton> </ItemTemplate> </asp:FormView>
View Replies !
View Related
Serious Perfomance Problem Using UDFs As Function Arguments. (I Suspect A Bug, Show Me I'm Wrong!)
(From an exchange originally posted on SQLServer.com, which wasn't resolved...) To return views tailored to the user, I have a simple users table that holds user IDs, view names, parameter names, and parameter values that are fetched based on SUSER_SNAME(). The UDF is called MyParam, and takes as string arguments, the name of the view in use, and a parameter name. (The view the user sees is really a call to a corresponding table returning UDF, which accepts some parameters corresponding to the user.) But the performance is very dependent on the nature of the function call. Here are two samples and the numbers reported by (my first use of) the performance monitor: Call to table returning UDF, using local variables: declare @orgauth varchar(50) set @orgauth = dbo.MyParam('DeptAwards', 'OrgAuth') declare @since datetime set @since = DATEADD(DAY,-1 * dbo.MyParam('DeptAwards', 'DaysAgo'),CURRENT_TIMESTAMP) select * from deptAwardsfn(@orgauth,@since) [187 CPU, 16103 Reads, 187 Duration] Call to same table returning UDF, using scalar UDFs in parameters: SELECT * from deptAwardsFn ( dbo.MyParam('DeptAwards', 'OrgAuth') ,DATEADD(DAY,-1 * dbo.MyParam('DeptAwards', 'DaysAgo'),CURRENT_TIMESTAMP) ) [20625 CPU, 1709010 Reads, 20632 Duration] (My BOL documentation claims the CPU is in milliseconds and the Duration is in microseconds -- which I question.) Regardless of the unit of measure, it takes a whole bunch longer in the second case. My only guess is that T-SQL is deciding that the parameter values (returned by dbo.MyParam) are nondeterministic, and continually reevaluates them somehow or other. (What ever happened to call by value?) Can anyone shed some light on this strange (to me) behavior? ----- (and later, from me)--- (I have since discovered that the reference to CURRENT_TIMESTAMP in the function argument is the cause, but I suspect that is an error -- it should only capture the value of CURRENT_TIMESTAMP once, when making the function call IMHO.)
View Replies !
View Related
Too Many Arguments In Procedure
i have written procedure like belowALTER PROCEDURE GetDetails (@vpid int, @vpname varchar(30) OUTPUT, @vprice int OUTPUT ) ASselect @vpname=productname,@vprice=price from fastfood where prod_id=@vpid RETURN and codeSqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ConnectionString;SqlCommand cmd = new SqlCommand("GetDetails",con);cmd.CommandType = CommandType.StoredProcedure; con.Open(); Hashtable items=new Hashtable();items = (Hashtable)Session["basketdata"];string name,price; foreach(int s in items.Keys) { SqlParameter p1 = new SqlParameter("@vpid", SqlDbType.Int, 10);p1.Direction = ParameterDirection.Input; p1.Value = s; cmd.Parameters.Add(p1); //cmd.Parameters.Add("@vpid", SqlDbType.Int, 10).Value=s;cmd.Parameters.Add("@vpname", SqlDbType.Char, 30).Direction=ParameterDirection.Output; cmd.Parameters.Add("@vprice", SqlDbType.Int, 10).Direction=ParameterDirection.Output; cmd.ExecuteNonQuery(); name = cmd.Parameters["@vpname"].Value.ToString();price = cmd.Parameters["@vprice"].Value.ToString(); %> } showing too many arguments to procedure
View Replies !
View Related
Using Stored Procedure Arguments
Hello. I am pretty new to SQL Stored Procedure, and ran into a problem. I am guessing there is a simple solution to this, as I am self-teaching myself this stuff. I currently have a procedure that creates a new table, by reading in columns from a variety of Linked Servers (ODBC connection to to Sybase databases) I will want to generalize a procedure by setting as arguments the ODBC connection name and the name of the new table that will be created ("CREATE TABLE") so I can pass these in. As a test of this idea, I created this as a simple procedure, but I get a syntax error when I try to Check Syntax this. Do I have to do something else when I reference the string "argu1" to specify a new table name, or an OPEN QUERY Linked table name? Thanks and Happy New Year! CREATE PROCEDURE gis.pr_PARCEL_TEST( @argu1 char(25)) AS CREATE TABLE @argu1 GO
View Replies !
View Related
Too Many Arguments In Stored Procedure?
Hello, When I try to call a stored procedure I get an SQL-exception reading "Procedure or function insert_member has too many arguments specified." As far as I can see the number of parameters in the application match the number of arguments in the stored procedure. I supply 10 parameters in the application and 10 in the procedure. Is the location of the declaration of the argument cgpID a problem? ALTER PROCEDURE [dbo].[insert_member] ( @mbrFirstName nvarchar(15), @mbrLastName nvarchar(15), @mbrStreetAddress nvarchar(15), @mbrPostalAddress nvarchar(15), @mbrTelephoneHome nvarchar(15), @mbrTelephoneJob nvarchar(15), @mbrEmail nvarchar(15), @mbrActivityGroupID int, @mbrPaymentMethod int ) AS INSERT INTO dbo.member(mbrFirstName, mbrLastName, mbrStreetAddress, mbrPostalAddress, mbrTelephoneHome, mbrTelephoneJob, mbrEmail) VALUES (@mbrFirstName, @mbrLastName, @mbrStreetAddress, @mbrPostalAddress, @mbrTelephoneHome, @mbrTelephoneJob, @mbrEmail) declare @cgpID int set @cgpID = (select cgpID from currentgroup where cgpActivityGroupID = @cgpActivityGroupID) INSERT INTO member_currentgroup (mbrID, cgpID, mcgPaymentMethod) values (@@identity, @cgpID, @mcgPaymentMethod)
View Replies !
View Related
Stored Procedure- Passing Arguments
I have the following stored procedure ALTER PROCEDURE dbo.TextEntered @searchString varchar(30) /* ( @parameter1 datatype = default value, @parameter2 datatype OUTPUT ) */ AS Select GAVPrimaryKey, NAME from towns where NAME like @searchString order by NAME RETURN doesn't work!!!! I would like to produce the following where s is @searchString: Select GAVPrimaryKey, NAME from towns where NAME like 's%' order by NAME Any ideas how I might acomplish this I have tried almost everything !
View Replies !
View Related
ERROR: Too Many Arguments Passed To Stored Procedure
Hi, We have an application written in ASP that calls a MS-SQL stored procedure and passes several parameters. Once in a while, we get this error, but most of the time it works. We can also run this in SQL query analyzer without ever a problem. We've looked at the obvious and found nothing wrong. Please help! Any suggestions are appreciated. (I posted this in ASP discussion board but no one replied) Colleen -------------------------------------------------------------------------------- |
View Replies !
View Related
Variable Number Of Arguments In A Stored Procedure
Can a Sql Server SP have variable number of arguments??? If yes, can somebody point me to a resource demonstrating that??? I need to send variable number of arguments to some of my SPs & iterate them with either foreach or traditional for loop. Any support would be greatly appreciated. If variable number of arguments are not feasible, then can I pass them as an array to the SP (again a Sample code would be desirable)???
View Replies !
View Related
Retrieving Result Set From Dynamically Called Stored Procedure Or Function In A Function
Is there any way I can retrieve the result set of a Stored Procedurein a function.ALTER FUNCTION dbo.fn_GroupDeviceLink(@groupID numeric)RETURNS @groupDeviceLink TABLE (GroupID numeric, DeviceID numeric)ASBEGINDeclare @command nvarchar(255)SELECT @command = Condition// @command is an SQL string or stored procedue nameFROM DeviceGroupWHERE GroupID = @groupIDINSERT @groupDeviceLinkEXEC @commandRETURNENDIs there any way i can do anything like this. @command is a variableholding the name of a stored produre. I need to run that storedprocure and return the values in such a way that they can be used in aSELECT StatementMy goal is SELECT * FROM Device INNER JOINdbo.fn_GroupDeviceLink(@groupID) ON ....this fn_GroupDeviceLink should run the proper stored procedure andreturn the values. What i also want to do is play with that result setof the specific stored procedure before i return it. Is this possible?If not, what is the work arround?ThanksMark
View Replies !
View Related
Procedure Or Function 'stored Procedure Name' Expects Parameter Which Was Not Supplied
Has anyone encountered this before? Procedure or Function 'stored procedure name' expects parameter '@parameter', which was not supplied. It seems that my code is not passing the parameter to the stored procedure. When I click this hyperlink: <asp:HyperLink ID="HyperLink1" Runat="server" NavigateUrl='<%# "../Division.aspx?CountryID=" + Eval("CountryID")%>' Text='<%# Eval("Name") %>' ToolTip='<%# Eval("Description") %>' CssClass='<%# Eval("CountryID").ToString() == Request.QueryString["CountryID"] ? "CountrySelected" : "CountryUnselected" %>'> </asp:HyperLink> it is suppose to get the country name and description, based on the country id. I am passing the country id like this. protected void Page_Load(object sender, EventArgs e) { PopulateControls(); } private void PopulateControls() { string countryId = Request.QueryString["CountryID"]; if (countryId != null) { CountryDetails cd = DivisionAccess.GetCountryDetails(countryId); divisionNameLabel.Text = cd.Name; divisionDescriptionLabel.Text = cd.Description; } } To my app code like this: public struct CountryDetails { public string Name; public string Description; } public static class DivisionAccess { static DivisionAccess() public static DataTable GetCountry() { DbCommand comm = GenericDataAccess.CreateCommand(); comm.CommandText = "GetCountry"; return GenericDataAccess.ExecuteSelectCommand(comm); } public static CountryDetails GetCountryDetails(string cId) { DbCommand comm = GenericDataAccess.CreateCommand(); comm.CommandText = "GetCountryDetails"; DbParameter param = comm.CreateParameter(); param.ParameterName = "@CountryID"; param.Value = 2; param.DbType = DbType.Int32; comm.Parameters.Add(param); DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); CountryDetails details = new CountryDetails(); if (table.Rows.Count > 0) { details.Name = table.Rows[0]["Name"].ToString(); details.Description = table.Rows[0]["Description"].ToString(); } return details; } As you can see I have two stored procedures I am calling, one does not have a parameter and the other does. The getcountry stored procedure returns the list of countries in a menu that I can click to see the details of that country. That is where my problem is when I click the country name I get Procedure or Function 'GetCountryDetails' expects parameter '@CountryID', which was not supplied Someone please help! Thanks Nickdel68
View Replies !
View Related
Procedure Or Function?
Trying to get a handle on how to attack this problem of adding a new record in a table that has 2 joins to access (user) and associate with a grandparent table (hotel). There is also a date condition with a separate table (contracts) in order to start the operation. Select from Contracts where TermBegin and TermEnd <> today For each contract hotel{ #Do they already have user? Match User.ID + Organization.ID + Hotel.ID If not{ Create Person } I'm not sure how to return the negative results of the 3 table join of User.Id + Organization.ID + Hotel.Id Thanks for any tips/iedas
View Replies !
View Related
Procedure Or Function Has Too Many Argument Specified.
Hey, friends, i have a problem on my bank transaction page now: Procedure or function has too many argument specified.people can log in by their usernames, 1 username can have many accounts, there are 2 account types:'c', 's'. after people login, they are only allowed to withdraw money from their own account: here is some of my codes: 1 else if (DropDownList3.SelectedItem.Text == "withdraw")2 {3 SqlConnection sqlCon = new SqlConnection("Data Source=bandicoot.cs.rmit.edu.au;Initial Catalog=shuli;User ID=test;Password=test");4 SqlCommand cmd = new SqlCommand("usp_withdraw", sqlCon);5 string spResult = "";6 cmd.CommandType = CommandType.StoredProcedure;7 cmd.Parameters.Add("@username", SqlDbType.NVarChar).Value = Session["username"].ToString();8 cmd.Parameters.Add("@AccountFrom", SqlDbType.VarChar).Value = TextBox3.Text;9 cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = TextBox5.Text;10 cmd.CommandType = CommandType.StoredProcedure;11 sqlCon.Open();12 spResult = cmd.ExecuteScalar().ToString();13 if (string.Compare(spResult, "Execute successfully") == 0)14 {15 SqlDataSource with = new SqlDataSource();16 with.ConnectionString = ConfigurationManager.ConnectionStrings["shuliConnectionString"].ToString();17 18 with.InsertCommand = "insert into Transactions(TransactionType,AccountNumber,DestAccount,Amount,Comment,ModifyDate) values ('W','" + TextBox3.Text + "','" + TextBox3.Text + "','" + TextBox5.Text + "','" + TextBox2.Text + "','" + DateTime.Now.ToLocalTime() + "')";19 int inertRowNum = with.Insert();20 Server.Transfer("~/deposit_withdraw_confirm.aspx");21 }22 else23 {24 Server.Transfer("~/deposit_withdraw_error.aspx");25 }26 here is my store procedure set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo-- =============================================-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- =============================================ALTER Procedure [dbo].[usp_withdraw]( @AccountFrom Varchar(20), @Amount Decimal(10,2))AsDECLARE @ReturnMsg AS VARCHAR(20)DECLARE @balance AS Decimal(10,2)DECLARE @username AS nvarchar(50)SELECT @balance = balanceFROM Account,LoginWHERE Account.CustomerID=Login.CustomerID AND Login.UserID= @username and AccountNumber = @AccountFromIF ( SELECT AccountType FROM Account, Login Where Account.CustomerID=Login.CustomerID AND Login.UserID= @username and AccountNumber = @AccountFrom ) ='c'BEGIN BEGIN TRAN IF (@balance - @Amount) > 199 BEGIN UPDATE Account SET balance= balance-@Amount WHERE AccountNumber=@AccountFrom And (balance - @Amount) > 199 SET @ReturnMsg = 'Execute successfully' COMMIT TRAN END ELSE BEGIN SET @ReturnMsg = 'Execute with error' ROLLBACK TRAN END SELECT @ReturnMsg ENDIF ( SELECT AccountType FROM Account Where AccountNumber = @AccountFrom ) ='s'BEGIN BEGIN TRAN IF (@balance - @Amount) > 0 BEGIN UPDATE Account SET balance= balance-@Amount WHERE AccountNumber=@AccountFrom And (balance - @Amount) > 0 SET @ReturnMsg = 'Execute successfully' COMMIT TRAN END ELSE BEGIN SET @ReturnMsg = 'Execute with error' ROLLBACK TRAN END SELECT @ReturnMsg ENDI think the problem is in Line 7cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = Session["username"].ToString();this is to get the current login user's uername.
View Replies !
View Related
When To Use A Function And When To Use A Stored Procedure.
Hi, I thought that procedures do not return a value: well they only return a 1 or 0 depending on whether the procedure executed correctly. Functions are what you're supposed to use when you want to get a result set of some sort: ie a table or a scalar value. Apparently that is not the case becuase you can return values from procedures. I've attempted to find out what the differences are between the two and when it is appropriate to use a procedure and when it is appropriate to use a function but I'm still unsure. Can someone please tell me the difference. Thanks. Przemek
View Replies !
View Related
Function Inside The Procedure
i have created the table empid,empname,dob,salary for the insert i need to create procedure of insert empid,empname,dob,salary i got the function for autogenerated number for empid mmy question how to put function inside the procedure? my function below,pls guide me its very urgent. create function NextCustomerNumber() returns char(5) as begin declare @lastval char(5) set @lastval = (select max(customerNumber) from Customers) if @lastval is null set @lastval = 'C0001' declare @i int set @i = right(@lastval,4) + 1 return 'C' + right('000' + convert(varchar(10),@i),4) end Desikankannan
View Replies !
View Related
Function From Stored Procedure
Hi Everyone, i want to create a function in Stored procedure and then call this function that returns true or false from a stored procedure . is this possible? please help me if you know something that can help me. thanks Tvin
View Replies !
View Related
Calling A Function From A Stored Procedure
Hello all, I'm trying to construct a select statement in a stored procedure that filters based on the returned values of a number of functions. My function works fine, but when I try to call the function from the stored procedure I get an error. I'm going to try explain the thought process behind what I'm doing. Hope I make enough sense.The purpose of the stored procedure is to perform a wildcard search on a tool. The tool contains a number of FK that link to different tables (e.g., manufacturer, vendor). So I'm creating functions that also search the manufacturer and vendor and return the matching IDs. Example of tool SELECT statement:SELECT tool_number, tool_description FROM tool WHERE tool_manufacturer IN (UDFmanufacturer_SearchName(@search_string) This gives me an error:'UDFmanufacturer_SearchName' is not a recognized built-in function name. Function code (removed some wrapping code for simplicity):SELECT manufacturer_id FROM manufacturer WHERE manufacturer_name LIKE '%' + @search_string + '%'These statements both work if I run a independent query: SELECT * FROM UDFmanufacturer_SearchName('mol') SELECT * FROM tool WHERE tool_manufacturer IN (SELECT *FROM UDFmanufacturer_SearchName('mol')) This code fails:SELECT * FROM ato_tool WHERE ato_tool_manufacturer IN (UDFmanufacturer_SearchName('mol')) I'm stuck. I haven't been able to find anything that shows me where I'm going wrong. Any thoughts or suggestions are appreciated. Thanks,Jay
View Replies !
View Related
Call Function From Stored Procedure
Hi All, I'll admit that I'm not the greatest at stored procedure/functions but I want to learn as much as possible. So I have two questions: 1) I had VS2005 autogenerate a sqldatasource that created Select/Insert/Update stored procedures. When Updating a record and calling the stored procedure, I want to query another table (we'll call it tblBatchNo) that has only one record, Batchno. I want to put that current batchno into the Update statement and update the record with the current batchno. Can someone point me in the right direction? Remember that I'm still a beginner on this subject. 2) Can someone provide any links to online tutorials on t-sql? Thanks in advance. Curtis
View Replies !
View Related
|
TRACKER
