update query in procedure issue

Question

0.00/5 (No votes)

See more:

SQL

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
--@status int
)
as
begin 
set nocount on

if (status !=1) or (status !=2)
begin 
update issuesdetails set assignedto = @employeeid , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
begin
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
 

end

First of all the "if (status !=1) or (status !=2)" this condition is not working , if i pass the parameter @status It works but I am not passing any parametr from front end so I cant pass this parameter . So Please give substitute for this also .

I tried using this , the previous issue of updating the status label for all the issue is resolved but now I cant update the status , On submit click no change occur.

Please give me some solution

[edit]Urgency deleted - OriginalGriff[/edit]

Posted 19-Apr-13 1:04am

Member 9954101

Updated 19-Apr-13 1:09am

Aarti Meswania

v3

Add a Solution

Comments

OriginalGriff 19-Apr-13 7:06am

Urgency deleted: It may be urgent to you, but it isn't to us. All that your stressing the urgency does is to make us think you have left it too late, and want us to do it for you. This annoys some people, and can slow a response.

PrashantSonewane 19-Apr-13 7:11am

Even before its now working, I wonder why you are not getting "Invalid column name 'status'" error. Where you have declared or selected that? Please try executing it again. you will get answer yourself. And how we will know what is status and what value it holds? Please improve the question.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2013-04-19T01:22:00

Solution 2

You can just swap the update statement like:

SQL

IF (status =1) OR (status =2)--What status is doing here? From where it came? Get the value for it from your table.
BEGIN 
	UPDATE issuesdetails SET assignedto=@employeeid,status =2 , testerassign=@testerid WHERE issuetrackerid=@issuetrackerid
END
ELSE
BEGIN
	UPDATE issuesdetails SET assignedto = @employeeid , testerassign=@testerid WHERE issuetrackerid=@issuetrackerid
END

--Amit

Posted 19-Apr-13 1:22am

_Amy

Comments

Member 9954101 19-Apr-13 7:39am

sorry I forget to link my previous question .I have two tables one is status having statusid and staatus name etc etc and the other table is issuedetails which is taking the status id from status table and updating the status on the label I have . So I am applying this procedure to update the issuesdetails. This Procedure is implemented on the click event which is updating the status when any value is selected from the dropdown list which i have on the page to assign .

I hope you get the issue

OriginalGriff · Answer 2 · 2013-04-19T01:08:00

Solution 1

Think about what you are saying:

SQL

if (status !=1) or (status !=2)

Show me a single value that fails that test. Did you mean AND rather than OR?

Posted 19-Apr-13 1:08am

OriginalGriff