toprashantjha
Members-
Posts
16 -
Joined
-
Last visited
Never
Profile Information
-
Gender
Not Telling
toprashantjha's Achievements
Newbie (1/5)
0
Reputation
-
Hi, I have given all the permission to a user say 'prashant' on one of the DB say 'db1'. I need to restrict the user to access some tables on db1. I am using MySql Version - 5.1.50 Please suggest.
-
Could you please suggest me how to break up datetime into bussiness/non bussiness hours?
-
How to calculate number of bussiness hours beetween to given dates? For example - I want to get difference hours beetween '2011-12-25 24:00:00' and '2011-12-28 10:00:00' and the result should only consider the time beetween 9:00 to 17:00. Please help..
-
no...it does not work for me.. Actually i am using fpdf and html2fpdf libraries to convert html into pdf ..but images are not converting into pdf format.
-
Hi How to convert html( including images) document into PDF using php?? any help would be highly appreciated
-
Thanks for the reply.. Above query is correct only ..got the solution... the problem was not using delimiter ....
-
Hi all, I am very new with MYSQL.. i was trying to create one trigger as mentioned in the code given bellow... But it is not creating trigger and if i remove BEGIN and END from the query then it is working fine (if i go for only on action). any idea???? i am using MYSQL GUI V6.0 CREATE TRIGGER TBL_TEST_TRIGGER AFTER UPDATE ON TBL_TEST_PRASHANT_EMPLOYEE3 FOR EACH ROW BEGIN UPDATE TBL_TEST_PRASHANT_EMPLOYEE1 SET name = 'test' ; UPDATE TBL_TEST_PRASHANT_EMPLOYEE4 SET FLD_DEPT = 'test' ; END;
-
Hi all, This is the code that i am using to get browser's name. But the problem is , for every browser except IE it is returning MOZILLA (in case of SAFARI and all). could any body please give me some idea to get different browser name.... // set browser name if (!empty($_SERVER['HTTP_USER_AGENT'])) { $HTTP_USER_AGENT = $_SERVER['HTTP_USER_AGENT']; } else if (!empty($HTTP_SERVER_VARS['HTTP_USER_AGENT'])) { $HTTP_USER_AGENT = $HTTP_SERVER_VARS['HTTP_USER_AGENT']; } else if (!isset($HTTP_USER_AGENT)) { $HTTP_USER_AGENT = ''; } if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[2]; $browser_agent = 'opera'; } else if (ereg('MSIE ([0-9].[0-9]{1,2})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[1]; $browser_agent = 'ie'; } else if (ereg('OmniWeb/([0-9].[0-9]{1,2})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[1]; $browser_agent = 'omniweb'; } else if (ereg('Netscape([0-9]{1})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[1]; $browser_agent = 'netscape'; } else if (ereg('Mozilla/([0-9].[0-9]{1,2})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[1]; $browser_agent = 'mozilla'; } else if (ereg('Konqueror/([0-9].[0-9]{1,2})', $HTTP_USER_AGENT, $log_version)) { $browser_version = $log_version[1]; $browser_agent = 'konqueror'; } else if(ereg('Safari/([0-9\.]+)',$HTTP_USER_AGENT, $log_version )) { $browser_version = $log_version[1]; $browser_agent = 'konqueror'; } else { $browser_version = 0; $browser_agent = 'other'; } print $browser_agent;
-
Look at this code.. if ur need somthing lyk this den it might help u... <html> <body> <script type="text/javascript"> function ChangeVal(Obj) { var selected_option = Obj.selectedIndex; var ctrl_id = Obj.id; switch( ctrl_id ) { case "select1": document.getElementById("select2").selectedIndex = selected_option; break; case "select2": document.getElementById("select1").selectedIndex = selected_option; break; } } </script> <form> <select ID="select1" onchange="ChangeVal(this)"> <option value = 0>Name</option> <option value = 1>Add</option> </select> <select ID="select2" onchange="ChangeVal(this)"> <option value = 0>Name</option> <option value = 1>Add</option> </select> </form> </body> </html> Here if u change option for 1 select box then value for another will automatically changed...
-
I tried non xhtml version also.. still it is not working....
-
if the value of option to be selected in different select box is same then in that case after changing option in one select box u can get the selected index in JS (using obj.selectedIndex) and can select the other options accordingly(as obj.selectedIndex = val ).
-
hi all, in my application i have one selectbox and i need to disable some option and i was trying will DISABLED attribute within OPTION tag.. but it is not working in IE..The code is like this... <select> <option value="volvo">Volvo</option> <option value="saab" disabled="disabled">Saab</option> <option value="mercedes" disabled="disabled">Mercedes</option> </select> I am not getting another way to disable this.. could any body help me please...
-
hello all.. i have some query which takes a lot of time ... please make a look at the query given... # Create Temp Table to store Ticket Num With min add date time CREATE TEMPORARY TABLE TBL_TEMP_FORUMS_MIN_ADD_DATE_TIME_FOR_TICKET ( FLD_TICKET_NUM varchar(32) default NULL, FLD_MIN_ADD_DATE_TIME datetime NULL, FLD_TIME_DIFF_IN_HRS INT, INDEX(FLD_TICKET_NUM ), INDEX(FLD_MIN_ADD_DATE_TIME), INDEX(FLD_TIME_DIFF_IN_HRS) ); select * FROM TBL_TEMP_FORUMS_MIN_ADD_DATE_TIME_FOR_TICKET WHERE FLD_TICKET_NUM='TLY-5079408-8233684'; # Insert Into Temporary Table INSERT INTO TBL_TEMP_FORUMS_MIN_ADD_DATE_TIME_FOR_TICKET (FLD_TICKET_NUM,FLD_MIN_ADD_DATE_TIME , FLD_TIME_DIFF_IN_HRS) #EXPLAIN SELECT SQL_CALC_FOUND_ROWS FLD_TICKET_NUM, IF( TFMM.FLD_DIRECTION = 2, MIN(FLD_ADD_DATE_TIME), '0000-00-00 00:00:00') AS FLD_MIN_ADD_DATE_TIME , ( ( TIME_TO_SEC( CASE FLD_ISSUE_CLOSED WHEN 3 THEN TIMEDIFF( MAX(FLD_ISSUE_STATUS_UPDATE_DATE_TIME), MIN(FLD_ADD_DATE_TIME)) ELSE TIMEDIFF( '2008-09-26 23:59:59', MIN(FLD_ADD_DATE_TIME) ) END )/3600) - FLD_CSS_ISSUE_SLA_QTY) AS FLD_TIME_DIFF_IN_HRS FROM TBL_FORUMS_MSG_MAIN TFMM FORCE INDEX(FLD_ADD_DATE_TIME,FLD_TICKET_NUM) WHERE ( ( TFMM.FLD_DIRECTION = 2 AND TFMM.FLD_PARENT_ID > 0 ) OR TFMM.FLD_REPLY_FLAG = 0 ) AND TFMM.FLD_AUTO_RESPONSE_FLAG = 0 AND TFMM.FLD_ADD_DATE_TIME >= '2008-09-22 00:00:00' AND TFMM.FLD_ADD_DATE_TIME <= '2008-09-29 23:59:59' AND TFMM.FLD_ACC_ID IN (118,393,6) GROUP BY FLD_TICKET_NUM; ORDER BY FLD_TIME_DIFF_IN_HRS DESC; limit 999 ; select FOUND_ROWS(); #Create Temporary Table to Store Ticket Num Based on Selected Criteria DROP TABLE TBL_FORUMS_TEMP_TICKET_NUM; CREATE TEMPORARY TABLE TBL_FORUMS_TEMP_TICKET_NUM ( FLD_FIRST_RESPONSE_TIME_IN_HRS INT(5), FLD_TICKET_NUM varchar(32) NOT NULL , FLD_CSS_ISSUE_SLA_QUANTITY INT(1), FLD_CSS_ISSUE_TAT_QUANTITY INT(1), FLD_INWARD_INTERACTION_COUNT INT(1), INDEX(FLD_TICKET_NUM) ); # Insert data In Temporary Table # ISSUES WHERE TAT IS CROSSED INSERT INTO TBL_FORUMS_TEMP_TICKET_NUM (FLD_FIRST_RESPONSE_TIME_IN_HRS, FLD_TICKET_NUM, FLD_CSS_ISSUE_SLA_QUANTITY, FLD_CSS_ISSUE_TAT_QUANTITY, FLD_INWARD_INTERACTION_COUNT ) SELECT TTFMA.FLD_MIN_ADD_DATE_TIME AS FLD_MIN_ADD_DATE_TIME, TIME_TO_SEC( TIMEDIFF(TTFMA.FLD_MIN_ADD_DATE_TIME, TFMM.FLD_ADD_DATE_TIME ) )/3600 AS FIRST_RESPONSE_TIME_IN_HRS, TFMM.FLD_TICKET_NUM, TFMM.FLD_CSS_ISSUE_SLA_QTY, TFMM.FLD_CSS_ISSUE_TAT_QTY, SUM(IF(TFMM.FLD_PARENT_ID >=0 AND TFMM.FLD_DIRECTION=1,1, 0)) AS INWARD_INTERACTION_COUNT FROM TBL_FORUMS_MSG_MAIN TFMM FORCE INDEX(FLD_TICKET_NUM, FLD_ADD_DATE_TIME) INNER JOIN TBL_TEMP_FORUMS_MIN_ADD_DATE_TIME_FOR_TICKET TTFMA FORCE INDEX ( FLD_TIME_DIFF_IN_HRS ) ON(TFMM.FLD_TICKET_NUM = TTFMA.FLD_TICKET_NUM AND TFMM.FLD_PARENT_ID = 0 ) WHERE TFMM.FLD_DIRECTION =1 #AND TFMM.FLD_CSS_ISSUE_CATEGORY > 0 AND TFMM.FLD_ADD_DATE_TIME >= '2008-09-22 00:00:00' AND TFMM.FLD_ADD_DATE_TIME <= '2008-09-29 23:59:59' GROUP BY TFMM.FLD_TICKET_NUM HAVING ( FIRST_RESPONSE_TIME_IN_HRS > FLD_CSS_ISSUE_TAT_QTY OR FLD_MIN_ADD_DATE_TIME = '0000-00-00 00:00:00' ) ORDER BY TTFMA.FLD_TIME_DIFF_IN_HRS DESC; In my application it needs to be executed sequencely as it is given... the problem is when i remove order by clause from last query then it takes only 6 sec. to execute otherwise it takes around 16 seconds... i am not getting why its happning... Could any body please explain me the reason..
-
difference between different page loading method.
toprashantjha replied to toprashantjha's topic in Javascript Help
Thanks, so much. Got some idea... -
hi all, i am not getting the difference between different page reloading methods.. which are-- 1. history.go(0); 2. document.location.reload(); 3. document.location.replace(document.location); 4. document.location.href='url of page';