Hi
I have a web form which is a part of asp.net application. This process updates a row of a table. This works fine. However I needed to add a DueDate field in the form and update the DueDate field in the back end as well. So I added the DueDate field in the form and changed the stored procedure and the corresponding code in asp.net. Now the update does not work.
I am getting the following error message:
@poduedate...
gamaz
Last Activity: Aug 5 '09, 06:36 PM
Joined: Jul 20 '08
Location:
-
gamaz started a topic Error message: @poduedate is not a parameter for procedure prr_out_projsearch_update1in ASP .NETError message: @poduedate is not a parameter for procedure prr_out_projsearch_update1
Last edited by Frinavale; Mar 5 '09, 04:28 PM. Reason: Added [code] tags: Please post code in [code] [/code] tags -
Thanks for your help. I appreciate it.... -
Thanks for your help CK. I appreciate it very much. Actually I think I could not explain the problem I am having properly. I need to use the database based on the parameter passed to the site. The correct procedure logic will be as follows:
STORED PROCEDURE CODE:
create procedure process_custome r
@custid varchar(50),
@sales_ytd money,
@sales_lstyr money,
@site varchar(10)
...Leave a comment:
-
Handling multiple database with stored procedure
Hi,
I am trying to work on a stored procedure that will work with multiple database. I have a prototype of multiple databases. Those are named as the following: ts2_aldkm_app, ts2_aldkp_app, ts2_aldkt_app. The middle part of the database name corresponds to the site name e.g aldkm corresponds to site aldkm etc. Each database has one table tblCustomer which is scripted as follows:
if exists (select * from dbo.sysobjects...
No activity results to display
Leave a comment: