Arihant rathi
Posts
-
converssion of pdf into images -
converssion of PDF pages into imageshi guys i have one problem . i want to upload a pdf file and want pages of this pdf file as a images in asp.net. means i have a pdf file and this file have 5-6 pages.and when i will upload this file ,i want these all pages should be upload as separate image in database. because i want to show all pages in thumbnails images. if any one of u can help me then it will be gr8 for me thanks
Ajay Rathi software engineer NOIDA(UP),INDIA
-
problem in javascripthi i m ajay can any one of u tell me that for javascript problem where i should write my problem... actually i want to make a fuction that can compare two dates....the date are in mm/dd/yyyy formate.. i want a alert that comes in that condition when second date will less thn first... and i want this onclick of button thxxx
Ajay Rathi software engineer NOIDA(UP),INDIA
-
problem in javascripthi i m ajay can any one of u tell me that for javascript problem where i should write my problem... actually i want to make a fuction that can compare two dates....the date are in mm/dd/yyyy formate.. i want a alert that comes in that condition when second date will less thn first... and i want this onclick of button thxxxx
Ajay Rathi software engineer NOIDA(UP),INDIA
-
how can i use google search engine in my sitehi i need search engine in my site.. so how can i use google search engine in my site thxxx
Ajay Rathi software engineer NOIDA(UP),INDIA
-
want paging in repeaterhi friends, i want paging with repeaters,can anyone of u help me to solve this problem.. thx
Regards Ajay Rathi software engineer NOIDA(UP),INDIA
-
problem in a tipical query(plzzz help me)you gave me solution of one problem "datename(month,month(start_date))" but this is giving me again and again only "january" nothing else.. so plz give me the other solution.. and wht you could not under stand in my first problem plz tell me.... i need the solution... plzzzzzzzz
Ajay Rathi software engineer NOIDA(UP),INDIA
-
help in typical query(plzzzzzzzzzzzzzz) [modified]hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
-
problem in a tipical query(plzzz help me)hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible
Ajay Rathi software engineer NOIDA(UP),INDIA
-
group by problem(plz help me)thx a lot of thx it's working u gave me a big support.... but i have one more problem related to this problem...actually when i m using that query which u gave me that is not working when i m using a sub query in that query ... following is that query.. sum(case when Type_of_view like 'Applicants' and Posting_Id_Fk in (select Id_PK from tbl_Post_Job where Company_Id_Fk = @Company_Id_Fk and Job_Title like @Job_Title and Job_Type like @Job_Type and Job_Location like @Job_Location ) then 1 else 0 end) as Applicants, in this query i know the value of @Company_Id_Fk, @Job_Type, @Job_Location ,@Job_Title
Ajay Rathi software engineer NOIDA(UP),INDIA
-
group by problem(plz help me)hi i m ajay rathi..i m facing a problem in group by clause in sql query..plz any one of u help me The problem is... following are 3 queries and i need to combine all three queries into one query..because this time these queries are giving me data in three table and i am showing this data in repeater in ASP.NET with SQL SERVER 2003.. select count(*)as active from tbl_Post_Job where Company_Id_Fk = 60 and Status = 'Active' and Post_Date between '01/01/2007' and '01/01/2008' group by year(Post_Date), month(Post_Date) select count(*)as billed from tbl_Post_Job where Company_Id_Fk = 60 and Status = 'Inactive' and Post_Date between '01/01/2007' and '01/01/2008' group by year(Post_Date), month(Post_Date) select count(*)as billed , month(Post_Date) as month_date ,year(Post_Date)as year_date from tbl_Post_Job where Company_Id_Fk = 60 and Status='Inactive' group by year(Post_Date), month(Post_Date) actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ 9,2007 | 4 | 8 10,2007 | 7 | 2 12,2007 | 6 | 6 ------------------------------------ please if any one of you can help me it's very good for me plzzzzzzzzzzzzzz thanks
Ajay Rathi software engineer NOIDA(UP),INDIA