|
| |
Need help design, asp to oracle database..recommendations
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
MrHelpMe
Posts: 1
Joined: 5/25/2006
Status: offline
 |
Need help design, asp to oracle database..recommendations - 5/25/2006 10:14:22
Hello experts,
Creating a web based survey(not poll) using asp and backend is oracle. I have designed the database, now working on the front end and am running into some issues. I am better at the backend then the frontend and need your help/recommendations. Some sort of coding help would be appreciated to get me on my way.
Firstly.... 2 of the tables in my survey database are as follows.
Questions - holds all survey questions
SurveySubChoices - holds all sub choices for the question.
i.e. How are you
good
excellent
Other[ ]
I need to know firstly how in asp I query all the questions and then have the subchoices(i.e. good, excellent other) show up underneath the question and then loop this for all questions. Here is my code that I am stuck on
<TD ALIGN="Left">
<%while not objRS.EOF
if Trim(objRS("Question_ID")) <> 0 then
%>
<option value=<%=Trim(objRS("Question_ID"))%>><b><%=Trim(objRS("Question_ID")& ".")%> </b><%=Trim(objRS("Descr"))%><BR><%=Trim(objTxt("B"))%></option><p>
<%end if
objRS.MoveNext()
wend %>
</TD>
Secondly how do I account for the other field. I need asp to say if the question is other(or something like this) then show me a text boxed choice and not a radio button. I will have lots of questions that have radio plus text box(memo) choices. I need to make this flexible for new surveys that get introduced but same type of structure(question with sub questions choices with mix of radio and text boxes)
I do know how to write stored procedures in oracle if that is a suggestion but do not know how to pass vales to the asp page if someone is recommending this root.
Also thinking of the best way to get my survey questions into the database once all the rest of the code is completed. Should I create an admin site or does oracle have a DTS option like SQL server.
Finally my next part will be to insert the answers(choices selected) back to the database in another table called SurveyAnswers. I will research this part after.
Your brains are appreciated.
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
