|
-- =============================================
-- Author: anbu
-- Create date:
-- Description: sp to check login and to set theme
-- =============================================
CREATE PROCEDURE EscIndexLoginCheckTheme
@username varchar(500),
@password varchar(500)
AS
BEGIN
declare @IsAlreadyexist as int
declare @sessionvalue as int
if exists(Select empguid from empmaster where employeeid=@username and password=@password and status=0)
begin
select @IsAlreadyexist=0 -- Login Available
Select @sessionvalue= empmaster.EmpGUID,Themesetting.th_name from empmaster inner join EmpTheme on empmaster.EmpGUID = EmpTheme.EmpGUID inner join Themesetting on EmpTheme.themeid = Themesetting.themeid
where employeeid=@username and password=@password
end
else
Begin
select @IsAlreadyexist=1 -- Invalid Login
end
select @IsAlreadyexist as Result,@sessionvalue as id
END
i am getting the following error
"A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations."
|
|
|
|
|
Seems like a SQL question to me.... Did you google the error message ?
anbusenthil wrote: Select @sessionvalue= empmaster.EmpGUID,Themesetting.th_name from empmaster inner join EmpTheme on empmaster.EmpGUID = EmpTheme.EmpGUID inner join Themesetting on EmpTheme.themeid = Themesetting.themeid
where employeeid=@username and password=@password
Assuming the error means exactly what is says, in plain English, you can't selecet th_name into a table AND select EmpGUID into @sessionvalue at the same time. That's assuming the error message means exactly what it says.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
First of all this is ASP.NET Forum, there is separate Forum for SQL . So that would the proper place for ask this questions.
anbusenthil wrote: Select @sessionvalue= empmaster.EmpGUID,Themesetting.th_name from empmaster inner join EmpTheme on empmaster.EmpGUID = EmpTheme.EmpGUID inner join Themesetting on EmpTheme.themeid = Themesetting.themeid
where employeeid=@username and password=@password
Did you validate the statement?
|
|
|
|
|
pls correct t stored proc and send me back
tanx
|
|
|
|
|
anbusenthil wrote: pls correct t stored proc and send me back
We are here to give you the solution not to do the job for you. All of us has pointed out the error in the SP, now its your job to correct it.
|
|
|
|
|
If you can't fix it based on what we've told you, then you should talk to your teacher for help. I assume you're not working on commercial code, if you were, you'd be a thief, obviously.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
|
It's a database question which needs to be moved to General Database Section.
It seems that following line is creating problem for you:
Select @sessionvalue= empmaster.EmpGUID,Themesetting.th_name from empmaster inner join EmpTheme on empmaster.EmpGUID = EmpTheme.EmpGUID inner join Themesetting on EmpTheme.themeid = Themesetting.themeid
where employeeid=@username and password=@password
To get rid of this error, make sure that all columns are assigned to a local variable. For example, just create another variable and store th_name column into this. Your problem will be vanished.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
When I move a data directory containing few media files the session gets expiered. Can anybody help me out in find what is going wrong in the process of moving the directory.
Thanks in advance.
Sekhar
|
|
|
|
|
What is your session mode and Session expire time ? And How long time is taking to moving the directory ?
|
|
|
|
|
My session mode is 'InProc' and expiry timeout is '90' minutes. And it takes maximum 30 seconds to move the directory. Please Help.
Thanks.
Sekhar
|
|
|
|
|
hello
I am sending Mail using smtpclinet.send Method()
all work fine
but Issue is that when i send Mail it All time return True no Error if Undelivar Mail due to any reason like mailbox full,Wrong Mail Address etc.
so How can we notify that mail is undeliver due to Wrong any reason and Send Mail to Administrator that that mail is undeliver
I aslo Tried using
client.SendCompleted += new SendCompletedEventHandler(client_SendCompleted);
client.SendAsync(message, userMessage);
But That time it's give error Like mail sending Fail if E-Mail address is True
Please Provide Solution ASAP
Regards
Kirti Darji
kirti
|
|
|
|
|
Hi,
One thing needs to be clear. We are not supposed to give you a solution rather than we can help you to assist you. Nobody here is paid to provide you a solution. So using a sentence like "Please Provide Solution ASAP" may be rude sometimes.
As far as your problem is concerned, I would like to suggest you to go through the following links which may be useful:
http://forums.asp.net/p/1189023/2038523.aspx[^]
http://forums.asp.net/t/1111538.aspx[^]
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
|
i got wrong value after sorting grid ....i click on item command after after sorting i got wrong value....
|
|
|
|
|
This[^] will explain what you've done wrong.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
ratheeshnair123 wrote: i got wrong value after sorting grid ....i click on item command after after sorting i got wrong value...
What do you mean by wrong value ? what you did for sort the grid data?
|
|
|
|
|
how we can bind checkboxlist using jquery
One person's data is another person's program.
--J.Walia
|
|
|
|
|
Are there any differences at all in setting up the web.config for a .NET 3.5 app vs. a 2.0 to make use of the asp .net membership provider?
Is the same version 2.0.0.0 of the membership provider in the web.config still the one to use with the 3.5 version of the framework? Also, what if the connection string is encrypted in the registry, how would the connectionstringname and connection be set for membership to use then?
I have come up empty handed trying to find answers to the above questions.
Please help,
Thanks
Revolutionary: Disk drives go round and round.
|
|
|
|
|
I'm having a problem with getting my new site to upload. I'm using asp.net/vb.net as well as using the new ajax control toolkit as well and after uploading my page to my server I come acrossed an error that I'm not sure how to fix. The site is located at:
http://www.watsonowen.com/NewSite/SiteTemplate/
The error I'm getting is Parse error and states this "Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified."
If someone could please help me fix this problem I would greatly appreciate it.
|
|
|
|
|
Owen Watson wrote: The error I'm getting is Parse error and states this "Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified."
Does your hosted site have the specific framework and AjaxToolkit installed?
|
|
|
|
|
Seems rather obvious, the AjaxControlToolKit assembly is not in the correct location.
only two letters away from being an asset
|
|
|
|
|
Just place the AJAXControlToolkit.dll in the bin directory of your project or install it in the global assembly cache.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
I am trying to follow some instructions in a VB2005 book which changes the value of DefaultClientScript by viewing the DOCUMENT Properties. The problem I have is that I do not see this property listed. I tried searching for an answer and found many articles suggesting changing this on the Property Pages on the General Section. Trouble is I don't have any general section.
All I want to do is to change the default to VBScript
Am I missing something simple?
flowerppk
|
|
|
|
|