User Profile

Collapse

Profile Sidebar

Collapse
jestin
jestin
Last Activity: Jul 24 '08, 10:19 AM
Joined: Mar 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jestin
    replied to insert time only
    in Oracle
    insert time only

    hi

    i am using oracle 8i as my db, i am getting one problem while i saving time can anybody helps me in this situation.

    the asp code is as follows.

    [HTML]sqlinsert="INSE RT INTO ACPADMIN.Tbl_Re questSched (" &_
    "Rschedid, " &_
    "RschedReqi d, " &_
    "RschedTime)val ues(" &_
    ...
    See more | Go to post

      Leave a comment:

    • jestin
      replied to insert time only
      in Oracle
      i want insert time only can u help me...
      See more | Go to post

        Leave a comment:

      • jestin
        started a topic insert time only
        in Oracle

        insert time only

        hi friends,

        I have a problem with time oracle 8i,can anybody tell me how to insert time in oracle 8i db(for example i want to insert a time like 4:45:00 PM) if u have any solution please give me the code.

        thx
        See more | Go to post
        • jestin
          started a topic date & time between
          in Oracle

          date & time between

          hi friends
          I have a table which is dealing Date and Time.

          the details is as follows

          RequstId ReqDat StartTime End Time
          1000 4/16/2008 7:30:00 AM 8:00:00 AM
          1001 4/16/2008 8:00:00 AM 8:30.00 AM
          1002 4/16/2008 8:30:00 AM 9:00:00 AM

          and i...
          See more | Go to post
          • jestin
            started a topic missing SET keyword
            in ASP Classic

            missing SET keyword

            hi friends i am trying to upadate oracle table value by using inner join method

            and the ASP code is as follows

            Code:
             
sqlupdate = "UPDATE Tbl_RequestInfo INNER JOIN Tbl_RequestSched ON Tbl_RequestInfo.ReqID = Tbl_RequestSched.RschedReqid SET " &_
	"Tbl_RequestSched.RschedStatus =" & STR_Quote2(ReplaceQuote(newstatus)) &_
	", Tbl_RequestSched.RschedUpdatedby =" &
            ...
            See more | Go to post
            Last edited by DrBunchman; Apr 17 '08, 02:24 PM. Reason: Changed code tags from html to #
            • jestin
              started a topic countfunction
              in Oracle

              countfunction

              hi friend i am trying to count a filed in oracle,

              the ASP code is as follows

              [HTML]Set rssum = server.CreateOb ject("ADODB.Rec ordset")
              sqlsum= "SELECT Count([ReqID]) AS TOTAL " &_
              "FROM Tbl_RequestInfo " &_"WHERE (((Tbl_RequestI nfo.ReqBadgeno) >0) " & _"
              AND ((Tbl_RequestIn fo.ReqServicety peid)= " & ServiceTypeID & ")))"...
              See more | Go to post
              • jestin
                started a topic recordset increment
                in ASP Classic

                recordset increment

                hi can u help me i am trying to incremnt the recordset value with 1.



                the asp code below

                [HTML]dim selautono,rsaut on, autonobr
                rsauton= server.CreateOb ject("ADODB.Rec ordset")

                selautono="SELE CT ACPADMIN.Tbl_Re questInfo.reqid FROM ACPADMIN.Tbl_Re questInfo WHERE ACPADMIN.Tbl_Re questInfo.reqid =(SELECT MAX(ACPADMIN.Tb l_RequestInfo.r eqid) FROM ACPADMIN.Tbl_Re questInfo)"...
                See more | Go to post
                • jestin
                  started a topic Missing comma
                  in ASP Classic

                  Missing comma

                  hi

                  Plz find the below code and its shows the error message as Missing Comma

                  'asp codes

                  [HTML]sqlinsert="INSE RT INTO Tbl_RequestInfo (" &_
                  "ReqJobdesc , " &_
                  "ReqRemarks , " &_
                  "ReqServicetype id, " &_
                  "ReqArea, " &_
                  "ReqCraft, " &_
                  "ReqGroup, " &_
                  "ReqRschedD ate,...
                  See more | Go to post
                  • jestin
                    started a topic not a valid month
                    in ASP Classic

                    not a valid month

                    hi friends i am trying to insert some values with date and time to Oracle db.

                    and the ASP code is as follows

                    sqlinsert="INSE RT INTO Tbl_RequestInfo (" &_
                    "ReqHouseno , " &_
                    "ReqBadgeno , " &_
                    "ReqRschedD ate, " &_
                    "ReqCompletiond ateest," &_
                    "ReqJobServices , " &_
                    "ReqStatus, " &_...
                    See more | Go to post
                    • jestin
                      started a topic Between two dates
                      in ASP Classic

                      Between two dates

                      hi friends

                      i am trying to upgrade one sql query to oracle 8i,and i am facing one problem can any one help in this situation.in that query we need a some data in between two times

                      ASP code is as follows
                      set rscheck = Server.CreateOb ject("ADODB.Rec ordset")
                      sqlcheck = "SELECT Tbl_RequestInfo .ReqServicetype id, Tbl_RequestInfo .ReqArea, Tbl_RequestInfo .ReqRschedDate, Tbl_RequestSche d.RschedTime,...
                      See more | Go to post
                      • jestin
                        started a topic Between a period of time
                        in ASP Classic

                        Between a period of time

                        hi friends
                        [code=asp]set rsschedcheck = Server.CreateOb ject("ADODB.Rec ordset")
                        sqlschedcheck = "SELECT ACPADMIN.Tbl_Re questInfo.ReqSe rvicetypeid, ACPADMIN.Tbl_Re questInfo.ReqAr ea, ACPADMIN.Tbl_Re questInfo.ReqCr aft, " &_
                        "ACPADMIN.Tbl_R equestInfo.ReqG roup, ACPADMIN.Tbl_Re questInfo.ReqRs chedDate, ACPADMIN.Tbl_Re questSched.Rsch edTime, ACPADMIN.Tbl_Re questInfo.ReqSt atus " &_
                        "FROM...
                        See more | Go to post
                        Last edited by jhardman; Apr 3 '08, 11:39 AM. Reason: put code in code tags. Please note button marked - #
                        • jestin
                          started a topic RecordSet updation
                          in ASP Classic

                          RecordSet updation

                          hi friends we have a ASP intranet system and its backend is in MSAccess now we r upgrading its back end with Oracle 8i.

                          and i have a problem regarding the record set updation

                          the code is as follows
                          [code=asp]
                          Set rscustomer = server.CreateOb ject("ADODB.Rec ordset")
                          rscustomer.Open sqlcustomer, MMToConn, 1, 3
                          '----
                          '----

                          '-----

                          if textnetworkid...
                          See more | Go to post
                          Last edited by jhardman; Mar 25 '08, 04:39 PM. Reason: put code in code tags. Please note button marked - #
                          No activity results to display
                          Show More
                          Working...