Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2006
    Posts
    140

    Angry Unanswered: ASP and Oracle Date

    hello,

    Could someone please either complete the query string or simply tell me how I can insert the timestamp or currenttime into and oracle database. It is not working for me

    Code:
    CurDate = sysdate
    ssqlCheckBox = "INSERT INTO Survey_User_Answer(Survey_Id,Question_Id,Answer_Id,Date_Answer,User_ID) VALUES (" & SurveyID & ",'" &  objRS("Question_Id") & "' , '" & answerChoices(answerChoice) & "' , '" & CurDate  & "', 'user')"

  2. #2
    Join Date
    Apr 2006
    Posts
    140
    Sorry experts me again. In addition to the posted question could someone also direct me or provide me a script that will display one survey question at a time from an oracle database.

    I need to show the question and it's associated checkbox answers and then show a next and previous button, capture the chosen answers and then at the end of the last question add the submit button and insert the values chosen into a database. What is the level of difficulty on this. I am using ASP and oracle backend and if anyone needs to see the current code please let me know. Thanks.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Can't help much but

    In msaccess Your have to put # at the begin and end

    Code:
    CurDate = sysdate
    ssqlCheckBox = "INSERT INTO Survey_User_Answer(Survey_Id,Question_Id,Answer_Id,Date_Answer,User_ID) VALUES (" & SurveyID & ",'" &  objRS("Question_Id") & "' , '" & answerChoices(answerChoice) & "' , #" & CurDate  & "#, 'user')"
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Apr 2006
    Posts
    140
    Well thanks for the reply but that's no good for Oracle Myle.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    just a question What is the Data type for the 'Date_Answer' in the data base
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  6. #6
    Join Date
    Apr 2006
    Posts
    140
    The datatype is date but remember this is oracle so Date in oracle means date time.

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  8. #8
    Join Date
    Apr 2010
    Posts
    6
    plz could u tell the syntax if we r using oracle database instead of MSAccess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •