User Profile

Collapse

Profile Sidebar

Collapse
nma
nma
Last Activity: Oct 21 '08, 01:42 PM
Joined: Aug 17 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nma
    replied to Color remains the same after onClick
    in Javascript
    Hi iam_clint,
    But how am I going to insert in my original coding..does this function need to be declare somewhere in the beginning of my codes.
    At the moment in my original codes when onClick happen it will get some event (video keyframe list). Can I combine this two event (the code you give above + the one in my original codes) within one single onClick lines of codes?


    Code:
    ........onClick="window.frames.eventsDisplay.location
    ...
    See more | Go to post
    Last edited by acoder; Sep 18 '08, 01:05 PM. Reason: fixed code tags

      Leave a comment:

    • nma
      replied to Color remains the same after onClick
      in Javascript
      Sorry for my poor explaination..
      Yes I want it only at one time cell selected (say red color)..then when user click at another cell that current cell will be selected and the previous cell back to original color

      It is actually a timeline bar...

      p/s the code you give is correct in terms of highlighted number of click user made on the timeline show red colored cell appear along the timeline/cells

      ...
      See more | Go to post

        Leave a comment:

      • nma
        replied to Color remains the same after onClick
        in Javascript
        Hi iam_clint
        I'm correcting the codes like below..there is red color on the cell once I mouseout but it remains many red color appear depending on as many times I click on the cell.
        What is wrong with the code?
        Thanks

        [PHP]
        <td width="<?php echo ($cellwidth); ?>" height="17" bgcolor="#00ff0 0" onmouseover="if (this.getAttrib ute('selected') ==null) { this.setAttribu te('selected',...
        See more | Go to post

          Leave a comment:

        • nma
          started a topic Color remains the same after onClick
          in Javascript

          Color remains the same after onClick

          Hi

          Can anyone help me..
          How can I make onClick color remains the same =red?
          Currently if it is mouseover it change to red, onmouseover it change to original background color. I need it to remain red once it is click so that I know where is the last location I click on the bar


          [PHP]

          <td width="<?php echo ($cellwidth); ?>" height="17" bgcolor="yellow "...
          See more | Go to post
          • nma
            replied to How to calculate duration in a query
            in SQL Server
            Hi Delerna,

            it possible right to convert the seconds into another column for minutes/hour from these query?

            nma
            See more | Go to post

              Leave a comment:

            • nma
              replied to How to calculate duration in a query
              in SQL Server
              Hi Delerna,

              It works...I just change the column name typing error only...it give total seconds the particular user has accesing/logging the system

              Thanks a mills :)

              I will post another problem solution as now almost drowning with my data analysis and will do part by part :)...
              See more | Go to post

                Leave a comment:

              • nma
                replied to How to calculate duration in a query
                in SQL Server
                [QUOTE=Delerna]You seem to be wanting to sum all the logged in times for a particular user on a particular date, so try this
                Code:
                SELECT convert(datetime,left(LogCombined2008,11)) as Date
                Hi Delerna,

                The code above produce error message like below:
                Msg 207, Level 16, State 1, Line 1
                Invalid column name 'LogCombined200 8'.
                See more | Go to post

                  Leave a comment:

                • nma
                  replied to How to calculate duration in a query
                  in SQL Server
                  Hi Delerna,

                  this is the query and the results generated....wh ich is works fine.

                  [HTML]select userID,date,Nex tDate,datediff( ss,date,NextDat e) as Seconds
                  from
                  ( select userID,date,(se lect min(date)
                  from LogCombined2008 b
                  where b.userID=c.user ID and b.date>c.date
                  ) as NextDate
                  from LogCombined2008 c
                  )a[/HTML]

                  ...
                  See more | Go to post

                    Leave a comment:

                  • nma
                    replied to How to calculate duration in a query
                    in SQL Server
                    thanks Delerna

                    it works, I can get duration is seconds, then I will calculate the total seconds for specific user login (say userID= 12, total seconds is (sum all the row). maybe I can do manually, export the table in excel and then filter it to get the sum of the second

                    or is there is a faster way to calculate total second in that row?
                    nma...
                    See more | Go to post

                      Leave a comment:

                    • nma
                      replied to How to set certain value into field?
                      in SQL Server
                      thanks a mills for giving me the ideas

                      it works now
                      See more | Go to post

                        Leave a comment:

                      • nma
                        started a topic How to set certain value into field?
                        in SQL Server

                        How to set certain value into field?

                        Hi

                        If I have one field name q4 and I want to calculate the likert scale value like below , I need to set the value to number first for further statistic calculation.
                        How do I set say agree ->4, mid -> 3, Totally Agree->5 etc? and create a new column of the number value side by side?

                        q4
                        agree
                        mid ...
                        See more | Go to post
                        • nma
                          replied to How to calculate duration in a query
                          in SQL Server
                          Hi

                          I'm using data from one table name LogCombined2008 only
                          and the colum name is date
                          I also have colum name userID

                          Thanks...
                          See more | Go to post

                            Leave a comment:

                          • nma
                            started a topic How to calculate duration in a query
                            in SQL Server

                            How to calculate duration in a query

                            Hi

                            How do I clculate time duration if I have a column like this

                            2008-04-19 15:00:55.000
                            2008-04-19 15:01:07.000
                            2008-04-19 16:33:55.000
                            2008-04-19 16:35:07.000
                            2008-04-19 16:37:00.000
                            2008-04-19 16:37:01.000
                            2008-04-19 16:37:13.000
                            2008-04-19 16:37:14.000
                            2008-04-19 16:39:35.000
                            2008-04-19 16:49:05.000

                            to know the session user login/logout?...
                            See more | Go to post
                            • nma
                              replied to Write a php function that logs user activities
                              in PHP
                              thanks

                              Could someone help me how should I write this line?
                              if (genre = ????) in line 4

                              Please ignore my initial post above.


                              [HTML]

                              function selectMovies()
                              {
                              document.locati on='/moviebrowser/MB2mainscreen.p hp?director='+d ocument.categor ies.director.va lue+'&genre='+d ocument.categor ies.genre.value ;
                              if (genre = ????)
                              {
                              logMainscreen(' genre...
                              See more | Go to post

                                Leave a comment:

                              • nma
                                started a topic help with function
                                in PHP

                                help with function

                                Hi
                                Could anyone help me in the writing the line of codes in the function call?
                                What should I write in if (genre = ????)
                                Thanks

                                nma

                                [HTML]

                                function selectMovies()
                                {
                                document.locati on='/moviebrowser/MB2mainscreen.p hp?director='+d ocument.categor ies.director.va lue+'&genre='+d ocument.categor ies.genre.value ;
                                if (genre = ????)
                                {
                                logMainscreen(' genre...
                                See more | Go to post
                                • nma
                                  replied to OnClick and change color
                                  in Javascript
                                  Hi acoder

                                  I don't really get you. What should I do?

                                  Nma...
                                  See more | Go to post

                                    Leave a comment:

                                  • nma
                                    started a topic OnClick and change color
                                    in Javascript

                                    OnClick and change color

                                    Hi
                                    How do I make the cell change color to 'black' after I click on it. The cell will remain black color until I click another cell which will also change to black. I can do the mouseover and mouseout correctly only to make it change color to black once I click on it.

                                    Could someone help?

                                    Thansk
                                    nma

                                    [PHP]
                                    <td width="<?php echo ($cellwidth); ?>" height="17"...
                                    See more | Go to post
                                    • nma
                                      started a topic Write a php function that logs user activities
                                      in PHP

                                      Write a php function that logs user activities

                                      Hi
                                      Can someone help me in writing this function? I want to log user action and store it in the database
                                      [PHP]
                                      <?php
                                      function log(_action) {
                                      include_once('. ./ez_sql.php');
                                      $db->query("INSER T INTO LogsTableMainsc reen (page, action, userID, type, date) VALUES ('mainscreen', '$action', " . $_SESSION['user']->userID . ", 'drop list', getDate())");
                                      }
                                      ?>
                                      [/PHP]...
                                      See more | Go to post
                                      • nma
                                        replied to onclick with anchor link
                                        in Javascript
                                        ..means the current position(anchor link) also change the color eg the background color...
                                        See more | Go to post

                                          Leave a comment:

                                        • nma
                                          replied to onclick with anchor link
                                          in Javascript
                                          Hi HSRIAT

                                          It works..I can do the anchor link now...but again how do I make it at the same time hightlighted at the current position?

                                          Many thanks :)

                                          nma...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...