RSS Forums RSS
Please support our Database Design advertiser: Programming Forums

Best way to develop db for survey?

Join Date: Jun 2004
Posts: 11
Reputation: maxtrixx is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 0
maxtrixx maxtrixx is offline Offline
Newbie Poster

Re: Best way to develop db for survey?

  #9  
Jul 29th, 2004
Another problem. How do I update the survey now? The items in the original form are named in the following format QID_## where ## = QuestioID in the database. So I insert the ## frin QID_## with the record in the QuestionID column. There's an autonumber for AnswerID. When I select a survey, multiple records show up and I don't know if I can use <%response.write(rs("AnswerID"))%> it's not only one for the selected survey. I

Example:
Answers table(it has more items but these two are the ones I need for the update)
QuestionID Answer AnswerID SurveyID
113 TruckA 2356 3
114 Bucket 2357 3
115 .... 2358 3
.... .... 2359 3

Basically what I need to know is how to put "Bucket" in the textbox QID_114.
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 5:53 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC