ASP and Oracle Date

MrhelpMe · #1 (**permalink**) 06-12-06, 14:13

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')"

MrhelpMe · #2 (**permalink**) 06-12-06, 14:21

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.

myle · #3 (**permalink**) 06-12-06, 14:55

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')"