Forum: Database Design  Aug 6th, 2004 |
| Replies: 15 Views: 11,573 When you inherit a project you're sometimes stuck with what you got. The last guys used the IntervieweeID as the identifier for the a specific survey. There was 3 surveys in the same db so now I'm... |
| Forum: Database Design Aug 5th, 2004 |
| Replies: 15 Views: 11,573 Any ideas why this is not working?
SQL = "UPDATE Answers SET Answer = '" & Replace(FieldValue, "'", "''") & "', UserName = '" & UserName & "', SurveyDate = '" & SurveyDate & "', Respondent = '" &... |
| Forum: Database Design Aug 3rd, 2004 |
| Replies: 15 Views: 11,573 Sorry, I don't think I explained it right. The update isn't the problem here, what is getting in the way is putting the infomation that's in the database in an update form. If I don't bring it all... |
| Forum: Database Design Jul 29th, 2004 |
| Replies: 15 Views: 11,573 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... |
| Forum: Database Design Jul 27th, 2004 |
| Replies: 15 Views: 11,573 Oops, I guess you've already answered my question. I'm adding the respondent to the answers table. Thanks again! |
| Forum: Database Design Jul 27th, 2004 |
| Replies: 15 Views: 11,573 The deal is, this surveys are filled out by field reps, they talk to people that use our products and fill out a survey off line and once they are in the network all they have to do is submit the... |
| Forum: Database Design Jul 26th, 2004 |
| Replies: 15 Views: 11,573 Ok, now suppose I want to update one of the answers, how would I do that? Right now I can select all answers and questions and put them on a table but let's say I would like to update an answer that... |
| Forum: Database Design Jul 23rd, 2004 |
| Replies: 15 Views: 11,573 Thanks for the reply.
I am keeping information about the person keeping the survey because they are our customers. Also, half of the questions in the survey are open ended question, and the... |
| Forum: Database Design Jul 22nd, 2004 |
| Replies: 15 Views: 11,573 what is the best way to develop a database for a survey? How should I name the columns in the database? I have an survey to develop and some of the questions have up to 80 answer options + quantity... |
| Forum: MySQL Jun 19th, 2004 |
| Replies: 3 Views: 68,980 I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming... |
| Forum: ASP.NET Jun 17th, 2004 |
| Replies: 4 Views: 12,327 How to fix this error?
I'm trying to use forms authentication to allow users to access different parts of a site and I have the following code in the web.config file:
<authentication... |
