Comments by Member 7932936 (Top 50 by date)

i used my form name also.

i got same error

but i want to know when it is happening

i have added duplicate sessions also

my application is opened in window at the same time my browser window closing and there is no chance to press ctrl N

Thank you very much.it working fine

because i want to do "full text index" search on files.

I have stored as varbinary

when i set full text index on my column it shows error as full text index only for varchar not varbinary .

that's why iam trying to insert as varchar

i used varbinary but i want to insert as varchar

it's not working

yes

thanks alot

Session["logintime"]=convert.todatetime((obj.logintime).tostring());

thanks it's working fine

i used on another pc also but i got same 127.0.0.1


I want client ip address

it shows the output as 127.0.0.1 but my ip address is not 127.0.0.1

i used like time(7) only

thank you.it's working.fine

i used this but it is not working.even it shows mozilla firefox browser and close button

It's really very useful solution
Thanks

thank u

my problem is solved

ok.fine.
thank you

yes,i have to sent as minexp=1,3,4,...
and
maxexp=2,5,7..

even then i have to split in sqlserver

i tried that also
even i have problem with split

because I have checkboxes
like

1 to 2 years
2 to 3 years
4 to 5 years
like that
the user can select multiple checkboxes
i have to pass minexp and maxexp values by seperating with ','
so my problem with split function and selecting multi chexkboxes

haven't spaces but all large and small no it's working fine but problem with only 8 and 9 only

I write like above query it's working.
but when iam passing minexp >=8 and maxexp <=9
then i have to get one row

but my result is null

if null

my datetime set to 1/1/0001 but hasn't takes null value

I already used like that

but it has set default datetime 1/1/0001

i already define datetime? dt=null;
but it takes default value i.e 1/1/0001

my erro message is



Msg 191, Level 15, State 1, Procedure procadvancedsearch, Line 466
Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

my error message is


Msg 191, Level 15, State 1, Procedure procadvancedsearch, Line 466
Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

this is my stored procedure.


create proc procadvancedsearch(@keyword varchar(max)=null,@joblocation varchar(max)=null,@experience varchar(max)=null,@industry varchar(max)=null,@function varchar(max)=null,@role varchar(max)=null,@jobfreshbydays datetime=null)
as
begin
if(@keyword IS NOT NULL and @joblocation IS NOT NULL and @experience IS NOT NULL and @industry IS NOT NULL and @function IS NOT NULL and @role IS NOT NULL and @jobfreshbydays IS NOT NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where keyskills Like '%'+ @keyword+'%' and joblocation in (select items from dbo.Split(@joblocation,',')) and @experience between minexperience and maxexperience and jobindustry in (select items from dbo.Split(@industry,',')) and jobfunctionality in (select items from dbo.Split(@function,',')) and jobrole in (select items from dbo.Split(@role,',')) and jobposteddate between @jobfreshbydays and GETDATE()
end
else if(@keyword IS NOT NULL and @joblocation IS NULL and @experience IS NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where keyskills Like '%'+ @keyword+'%'
end
else if(@keyword IS NULL and @joblocation IS NOT NULL and @experience IS NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where joblocation in (select items from dbo.Split(@joblocation,','))
end
else if(@keyword IS NOT NULL and @joblocation IS NOT NULL and @experience IS NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where keyskills Like '%'+ @keyword+'%' and joblocation in (select items from dbo.Split(@joblocation,','))
end
else if(@keyword IS NULL and @joblocation IS NULL and @experience IS NOT NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where @experience between minexperience and maxexperience
end
else if(@keyword IS NOT NULL and @joblocation IS NULL and @experience IS NOT NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where keyskills Like '%'+ @keyword+'%' and @experience between minexperience and maxexperience
end
else if(@keyword IS NULL and @joblocation IS NOT NULL and @experience IS NOT NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobposteddate,e.joblocation,e.minexperience,e.maxexperience,e.jobdescription, d.companyname from emppostingjobs e Inner join admregforemp d on e.comptypeid=d.comptypeid where joblocation in (select items from dbo.Split(@joblocation,',')) and @experience between minexperience and maxexperience
end
else if(@keyword IS NOT NULL and @joblocation IS NOT NULL and @experience IS NOT NULL and @industry IS NULL and @function IS NULL and @role IS NULL and @jobfreshbydays IS NULL)
begin
select e.jobtitle,e.jobpostedd

because i don't want to upload the file many times when page gets refreshed

where i have to put \b

It does not working.

This code is not working.
this code is removing only spaces between the string.
But i want to remove last "and's" in my string

if my string is like ".net and asp.net and and and and and".It is not working.
It is working only for ".net and asp.net and" .

it removes only last "and".fine.But the error shows like index was outside the bounds of an array

string output = s.TrimEnd("and");
This removes only last "and".But I Want to Remove all last "and".
That means if my string ends with and and and and and and .....then i want to remove all last "and".How can remove ????

no.i want to remove last "and"

it is also showing error like index was out of bound arrey exception

if(TextBox1.Text.EndsWith("and"))
{
// this removes only last "and" only.But I want to remove total last"and"'s
TextBox1.Text = TextBox1.Text.Substring(0,TextBox1.Text.Length - 3);
// if i use this shows error like index out of range exception
TextBox1.Text.Replace("and", " ");

//TextBox1.Text.TrimEnd();

TextBox1.Text.Trim();

}
//}

string output=s.replace("and","");
I used this but it does not working.
it replace only last two characters in my last string.
that is it replaces only 'nd' as ""

yes.i used substring but it works only to remove one "and" only.i want to remove many "and"'s in my string.then how to remove many "and"'s