User Profile

Collapse

Profile Sidebar

Collapse
sharmanic2002
sharmanic2002
Last Activity: Oct 6 '06, 11:17 AM
Joined: Oct 6 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sharmanic2002
    replied to Session in ASP
    in ASP Classic
    You can track the entire session details like,
    page accessed,sessio n time,port used,ip address etc., using the Request.Serverv ariables("Param eter").You can use around 16(I guess) parametres
    See more | Go to post

      Leave a comment:

    • sharmanic2002
      replied to Error in ASP page
      in ASP Classic
      Make sure that the database is not open or any other uncommited updates on that row.
      See more | Go to post

        Leave a comment:

      • sharmanic2002
        replied to starting user and password!
        in Oracle
        Default password will be manager/oracle for administrative rights
        SQL>Conn system/manager as sysdba
        or
        SQL>Conn sys/oracle as sysdba

        after creating a new tablespace you can create a user using the command

        SQL>Create User XYZ(Username) identified by ABC(Password) default tablespace <Your New tablespace name>
        commit;
        after that grant user rights for that particular user....
        See more | Go to post

          Leave a comment:

        • sharmanic2002
          replied to Change Date Color to Red in ASP
          in ASP Classic
          <%if RS("requested_s hip_date")<>"" then%>
          Project or store opening equipment due date<br>
          <input type="text" name="shipDate" size="20"
          value="<%=RS("r equested_ship_d ate")%>" class="inputRea d" readonly>
          <%
          elseif
          (DateDiff("d",D ate,RS("request ed_ship_date") < 10 then...
          See more | Go to post

            Leave a comment:

          • sharmanic2002
            replied to Performance Related Clarification.
            in Oracle
            Increase the number of check points and check the PMON.
            Please take a statspack report in regular intervals which you find will be approriate and comapre the reports.You will find the solution urself.

            Sharma J A
            See more | Go to post

              Leave a comment:

            • sharmanic2002
              started a topic Sum Comma Seperated string
              in SQL Server

              Sum Comma Seperated string

              I have a table a which has a column x
              x has values 12,34,56,78 .I need an sql query which can sum the CS values in that row like 12+34+56+78 and need to display the sum.Please advise me as I am desperate in searching it...
              Thanks in Anticipation...
              See more | Go to post
              No activity results to display
              Show More
              Working...