Comments by Sweetynewb (Top 78 by date)

okay but you are using inbuilt method. I need to create code using division name. Division name will be anything which user can enter.

but how to check that?

Thank you for link. but he didnt explain how to set y-axis from code behind.

its giving now.... i have written order by statement twice.. before closing bracket and after that :)

Its working but not giving latest date comment. thank you.
I will try for that.

after applying alias it is running but still one comment is not displaying. If i run separately then it gives that row but after union not.
I will try for this. thank you

it is datetime.

same error-Incorrect syntax near the keyword 'order'.

getting error-Incorrect syntax near the keyword 'order'.

yes but where should i write this? bcoz after return statement it exits codebehind funcion

Oh yes its working now. Actually i wrote form id=frm1 and so my javascript code was-
document.frm1.submit();

but now i made below changes and its working fine.

document.forms['frm1'].submit();

thanks for that link.

I am sorry, "Like" is not button, its anchor tag. and the page data is displayed dynamically

Even this query is right.
Thank you for help :)

Its datetime. i just changed ">" sign to "<" and it worked.
Thank you very much.

now i am able to get call_date but it is giving all users.
i mean for eg: user -2 has filled data upto 2/4/2013
still it shows in upper query result

using distinct it gives unique values, but iwant to display call_date column too.. i.e. last call date of user with name and id

it gets duplicate rows..

ok.

I am providing dummy data:-

1)educator_master data:-

eid first_name last_name
19 Tapan Kumar Chhanda
20 SK Mumtaz Ali
21 Sanjoy Poddar
22 Md.Mokibul Hoque
23 Md.Atiqul Ali
24 Ganesh Chakraborty
25 Dinesh Chakraborty

2)educator_call_dtls data:-
call_id eid call_date
108637 19 03/25/13
108639 19 03/26/13
108641 19 03/27/13
108642 19 03/28/13
109649 19 03/29/13
109650 19 03/30/13
109653 19 03/31/13
110389 19 04/01/13
110390 19 04/02/13
109663 20 03/28/13
109664 20 03/29/13
109665 20 03/30/13
109666 20 03/31/13
110079 20 04/01/13
110387 20 04/02/13
109901 22 03/27/13
109902 22 03/28/13
109907 22 03/29/13
109928 22 03/30/13
109941 22 03/31/13
107998 23 03/27/13
109124 23 03/28/13
110086 23 03/29/13
110087 23 03/30/13
110088 23 03/31/13
108646 24 03/27/13
108647 24 03/28/13
110028 24 03/29/13
110030 24 03/30/13
110032 24 03/31/13
103173 25 03/07/13
104101 25 03/08/13
104102 25 03/09/13
104103 25 03/10/13
104701 25 03/11/13


so if you look at eid =25 in 2nd table, he entered data till 11 amrch 2013 so his name shuld come in report

Thank you for try.. I solved that problem.

https://developers.google.com/youtube/youtube_player_demo

https://developers.google.com/youtube/js_api_reference#Queueing_Functions

I just want to load new video on click of link..

Which url?

Please suggest me any solution..

I think this solution will help me out. but i want group by(course) clause too.

i want to upload multiple files on server so i want to find folder from which i can upload multiple files.
Please help me to find out path an no. of files in that folder

yes i tried this but i can not use server.mappath()
It gives wrong path, i mean i want client path

ok. yes this is working now.

Superb.... got exactly what i want, even it does not need to check for year

It is giving all months data not last two..

Can you now help me??

hmm. because of limitation may be.. ok i am posting whole query below (Please look into it)-

CREATE Procedure getBFEAdminReport_MAIN_HQ -- '74',12,12,2012,2012
(
@eid varchar(500),
@from_month int,
@to_month int,
@from_year int,
@to_year int,
@desg int= null
)
as

CREATE TABLE #2
(
LIDList Int
)

-- Optional index on the temp table
CREATE INDEX idx1 ON #2 (LIDList)
INSERT INTO #2
SELECT Convert(Int, NullIf(SubString(',' + @eid + ',' , ID ,
CharIndex(',' , ',' + @eid + ',' , ID) - ID) , '')) AS LIDList
FROM tblToolsStringParserCounter
WHERE ID <= Len(',' + @eid + ',') AND SubString(',' +
@eid + ',' , ID - 1, 1) = ','
AND CharIndex(',' , ',' + @eid + ',' , ID) - ID > 0


select EC.eid,(ED.first_name+' '+ED.last_name) as FullName,st.state_name,region.state_name as region,city.state_name as city,ED.designation,ED.employee_id,
sum(Case when DB.cd_type=0 Then 1 Else 0 End) as cnt_clinic,
sum(Case when DB.cd_type=1 Then 1 Else 0 End) as cnt_camp,
sum(Case when DB.activity_type=0 Then 1 Else 0 End) as cnt_spir,
sum(Case when DB.activity_type=1 Then 1 Else 0 End) as cnt_breat,
sum(Case when DB.activity_type=2 Then 1 Else 0 End) as cnt_vitalo,
sum(Case when DB.timing=0 Then 1 Else 0 End) as cnt_morning,
sum(Case when DB.timing=1 Then 1 Else 0 End) as cnt_eve,
sum(Case when DB.timing=2 Then 1 Else 0 End) as cnt_full
from doc_business_data DB
inner join educator_call_dtls EC on DB.call_id=EC.call_id
inner join doctor_master DM on DM.doc_id=DB.doc_id
inner join educator_master ED on ED.eid=EC.eid
inner join educator_state_master city on city.state_city_id=ED.city_id
inner join educator_state_master region on region.state_city_id=city.parent_id
inner join educator_state_master st on st.state_city_id = region.parent_id
where EC.eid in (select LIDList FROM #2) AND ED.designation <> 'BM' AND ED.designation <> 'SM' AND ED.designation <> 'SuperAdmin' and
(((year(EC.call_date) > @from_year) OR (year(EC.call_date)=@from_year AND month(EC.call_date) >=@from_mo

ok i will try to do this. Thank you.

Thank you for suggestion. i am trying that. Did you saw my whole query?

thanks for reply.
i need to use case in Sum function because there is one columns for 2 or 3 types( ex: timing column in table is used to store - moring, evening or full day.)

i did not understood your 3rd point- " Move IN checking from where clause to inner join"?

can you tell me how to apply indexing on my inner join tables?

Please help me to improve speed.

but i need to use inner join to get data

ok.. Please suggest me any other idea if views doesnt work then what need to use? Below is my stored procedure

CREATE Procedure getAdminReport -- '91,93,826,823,83,86,712,85,82,88',12,12,2012,2012
(
@eid varchar(500),
@from_month int,
@to_month int,
@from_year int,
@to_year int,
@desg int= null
)
as

CREATE TABLE #2
(
LIDList Int
)

-- Optional index on the temp table
CREATE INDEX idx1 ON #2 (LIDList)
INSERT INTO #2
SELECT Convert(Int, NullIf(SubString(',' + @eid + ',' , ID ,
CharIndex(',' , ',' + @eid + ',' , ID) - ID) , '')) AS LIDList
FROM tblToolsStringParserCounter
WHERE ID <= Len(',' + @eid + ',') AND SubString(',' +
@eid + ',' , ID - 1, 1) = ','
AND CharIndex(',' , ',' + @eid + ',' , ID) - ID > 0


select EC.eid,(ED.first_name+' '+ED.last_name) as FullName,st.state_name,region.state_name as region,city.state_name as city,ED.designation,ED.employee_id,
sum(Case when DB.cd_type=0 Then 1 Else 0 End) as cnt_clinic,
sum(Case when DB.cd_type=1 Then 1 Else 0 End) as cnt_camp,
sum(Case when DB.activity_type=0 Then 1 Else 0 End) as cnt_spir,
sum(Case when DB.activity_type=1 Then 1 Else 0 End) as cnt_breat,
sum(Case when DB.activity_type=2 Then 1 Else 0 End) as cnt_vitalo,
sum(Case when DB.timing=0 Then 1 Else 0 End) as cnt_morning,
sum(Case when DB.timing=1 Then 1 Else 0 End) as cnt_eve,
sum(Case when DB.timing=2 Then 1 Else 0 End) as cnt_full
from doc_business_data DB
inner join educator_call_dtls EC on DB.call_id=EC.call_id
inner join doctor_master DM on DM.doc_id=DB.doc_id
inner join educator_master ED on ED.eid=EC.eid
inner join educator_state_master city on city.state_city_id=ED.city_id
inner join educator_state_master region on region.state_city_id=city.parent_id
inner join educator_state_master st on st.state_city_id = region.parent_id
where EC.eid in (select LIDList FROM #2) AND ED.designation <> 'BM' AND ED.designation <> 'SM' AND ED.designation <> 'SuperAdmin' and
(((year(EC.call_date) > @from_year) OR

no but i have created subdomain and trying to access my website.

i am creating sub - directory using control panel. there is no other web config file

Still error persist.. what to do?

I am using vs 2.0.-> web application.
there is no property-"containskey"
What to do?

Hi Amit,

Can you tell me how to add new node , below selected node?
i mean new node should be child node of selected node.
Please help me out..

My previous code was working i firefox and IE
As you said, i made changes in function, but still its not working.
What is the problem for simple enable and disable?

New Code:
function getRdoValue()
{
if(document.getElementById("<%=rdo_yes.ClientID%>").checked)
{
document.getElementById("<%=dlst_type.ClientID%>").disabled=false;
document.getElementById("<%=dlst_course_wocktube.ClientID%>").disabled=false;
}
if(document.getElementById("<%=rdo_no.ClientID%>").checked)
{
document.getElementById("<%=dlst_type.ClientID%>").disabled=true;
document.getElementById("<%=dlst_type.ClientID%>").disabled=true;
}
}

I didnt much understood that example... i need to use external js file right?
from where i can able to download that file?

JS is enabled in chrome
Now?

Query:

select count(distinct(cb.chemist_name)) as SumChem
from educator_call_dtls ed
left join chem_business_data cb on cb.call_id=ed.call_id
where ed.eid=780 and month(ed.call_date)=11 and year(ed.call_date)=2012

Table:chem_business_data has 9 records:

ID chem_id call_id patient_count other_chemist_name location
46367 0 64866 0 MEDICAL SHOP DEVICE DEMO SALEM
46368 0 64869 0 MEDICAL SHOP DEVICE DEMO SALEM
48741 0 67806 0 MEDICAL SHOP DEVICE DEMO SALEM
48750 0 67812 0 MEDICAL SHOP DEVICE DEMO SALEM
48749 0 67810 0 CANOPY ERODE
49790 0 69546 0 MEDICAL SHOP DEVICE DEMO SALEM
51811 0 71874 0 MEDICAL SHOP DEVICE DEMO SALEM
51867 0 71912 0 MEDICAL SHOP DEVICE DEMO SALEM
51808 0 71869 0 MEDICAL SHOP DEVICE DEMO SALEM

I have generated script file which include-table creation and stored procedures
but "generate script" does not give data stored in tables?
What should i do?

ok i tried with your suggestion but still its not working.
its giving me error-
$ is not a function

And if i replace $ with - jQuery word it gives me exceptions which i didnt seen ever

<div id="aboutYouEditable" class="hidden">
<form action="#" method="post">
<fieldset id="popup_aboutYou">
<dl class="commonForm">

<dt>
<label for="popup_title">Title:*</label>
</dt>
<dd>
<div class="normalFieldWrapper">
<select name="popup_title" id="popup_title">
<option value="">Select</option>
<option value="mr">Mr.</option>
<option value="ms">Ms.</option> </select>
<span id="list_error1" class="popupError" style="display:none"></span>
</div>
</dd>
<dt>
<label for="popup_firstname">First name:*</label>
</dt>
<dd>
<div class="normalFieldWrapper">
<input type="text" name="popup_firstName" id="popup_firstname" /><span id="list_error2" class="popupError" style="display:none"></span>
</div>
</dd>
<dt>
<label for="popup_middlename">Middle name:</label>
</dt>
<dd>
<div class="normalFieldWrapper">
<input type="text" name="popup_middleName" id="popup_middlename" /><span id="list_error3" class="popupError" style="display:none"></span>
</div>
</dd>
<dt>
<label for="popup_lastName">Last name:*</label>
</dt>
<dd>
<div class="normalFieldWrapper">
<input name="popup_lastName" type="text" id="popup_lastName" /><span id="list_error4" class="popupError" style="display:none"></span>
</div>
</dd>

<dt>
<label for="popup_genderMale">Gender:</label>
</dt>
<dd>
<div class="normalFieldWrapper">
<input name="gender" type="radio" class="radioButton" id="popup_genderMale"/>
<label for="genderMale" class="radioButtonLabel">Male</label>
<input name="gender" type="radio" class="radioButton" id="popup_genderFemale" />
<label for="genderFemale" class="radioButtonLabel">Female</label><span id="list_error6" class="popupError" style="display:none"></span>
</div>
</dd>

</dl>
</fieldset>
<div class="buttonWrapper"> <span>Cancel</span> <span class="mainActionbu

not working

I tried your code, still its not working.
Actually popup is nothing but the div on same page..

How we can disable it? Can you give me example?
i dont want to call onbeforeunload() function on back button.

Thank you sir for example. I am confused in .swf & .flv files.
In my application i am able to play .swf file but not .flv.
Both file types are different. and in asp.net we can play .swf files?

Sir, can you give one example? ow embed tag will work with flv file? I used object tag with embed tag. Please reply me back

No luck sir. I tried to install AspNetFlashVideo Player but even that is not installing properly.

Thanks for your suggestion. I changed my SP added some conditions and it worked perfect for me
:)

Okay but i am extracting report. And stored procedure execution time is 4 mins. User can not wait for 4 mins to view report. Is it possible to fetch more than 1000 in less time? And so that user also get faster response?

No luck with 7 queries. but thank you for putting thought of dev_id in where condition. The number of devices are same for every user so i tried dev_id in where condition and it worked well.. Thank you very much.

means you are saying , write 7 queries for 7 devices and then select all variables like @zerostat,@zerosts_spacer? Sir m trying like this let c

No. we are checking month and year so the data will come for month March-April 2012
Because of client requirement,we need to display some devices so we can't put dev_id in where condition. How to select all at the end? can u give any example so that i can try

Parameter stuffing is declare local variables and assign procedure parameters to them.
I am doing website and everything is working fine only below procedure takes long time-


select
sum(Case when patient_dev.dev_id= 1 Then patient_dev.dev_qty ELse 0 End) as [Zerostat VT],
Sum(Case when patient_dev.dev_id= 2 Then patient_dev.dev_qty ELse 0 End) as [Zerostat Spacer],
Sum(Case when patient_dev.dev_id= 3 Then patient_dev.dev_qty ELse 0 End) as Rotahaler,
Sum(Case when patient_dev.dev_id= 4 Then patient_dev.dev_qty ELse 0 End) as [Huf Puf Kit],
Sum(Case when patient_dev.dev_id= 5 Then patient_dev.dev_qty ELse 0 End) as [New Revolizer],
Sum(Case when patient_dev.dev_id= 6 Then patient_dev.dev_qty ELse 0 End) as [New Baby Mask],
Sum(Case when patient_dev.dev_id= 7 Then patient_dev.dev_qty ELse 0 End) as [Breathe O Meter]
from doc_business_data DB
inner join educator_call_dtls EC on DB.call_id=EC.call_id
inner join educator_master em on em.eid=EC.eid
left join patient_doc_business pati_doc on DB.doc_busi_id=pati_doc.doc_busi_id
left join patient_device_dtls patient_dev on patient_dev.pb_id=pati_doc.pb_id
inner join educator_state_master city on city.state_city_id= em.city_id
inner join educator_state_master region on region.state_city_id =city.parent_id
inner join educator_state_master st on st.state_city_id=region.parent_id
where (((year(EC.call_date) >2012) OR (year(EC.call_date)=2012 AND month(EC.call_date) >=3 ))
AND ((year(EC.call_date)=2012 AND month(EC.call_date)<=4) OR year(EC.call_date) < 2012))
AND st.state_city_id=20 AND em.deleted=0 and em.eid is NOT NULL

i don't want crystal reports in pdf format or excel format.
my application is working fine on my machine, after uploading on server it gives crystal decision .... error

I copied dll files in bin folder and uploaded it, still its not working
plz help

i read that article. but there is an error in following line
oCmd.Parameters.Add("EmployeeID", sEmpId)

i am using visual studio 2008 and parameters.add requires "oledbtype" as 2nd parameter.

Plz help me....

We know the fields of table but this function can be used with different tables so 1st parameter of function will be Name of "table" and 2nd will be value for the field. Now i want to know how dynamically i should set those values to fields

ok. client PC has MS Word installed so i think no need to install MS work viewer.

That article requires 2003 versions
i uses Visual Studio 2008 and Microsoft office 2007
and when i tried to follow the steps, given in that article, it gives error

i want to show word document like in Nukri or monster portal
what to do now?
Any help?

I used mime type-"application/vnd.ms-word"
and microsoft viewer means?
I added references- Microsoft.Office.Interop.Word

thanks for reply
but i tried that code
and it works fine
but it allows to download that document. and i want to display it to show the user

eager to get this....

but when getting back i want to show that document on asp.net page
I am getting text file but not word document