•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 397,790 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,400 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 7324 | Replies: 15
 |
•
•
Join Date: Jun 2004
Posts: 11
Reputation: 
Rep Power: 5
Solved Threads: 0
Newbie Poster
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 back the user would have to fill out the entire survey again since all form fields are going to be blank. I can't use the column name and I need to user the row to call that answer. Any ideas?
•
•
Join Date: Apr 2004
Posts: 321
Reputation:
Rep Power: 5
Solved Threads: 8
Posting Whiz
You should just have to present the survey similar to a user taking it for the first time, and execute a select sql statement similar to the one I wrote in my last response for each question, to retrieve that respondents answer to each question.
•
•
Join Date: Jun 2004
Posts: 11
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
Any ideas why this is not working?
SQL = "UPDATE Answers SET Answer = '" & Replace(FieldValue, "'", "''") & "', UserName = '" & UserName & "', SurveyDate = '" & SurveyDate & "', Respondent = '" & Respondent & "', CompanyName = '" & CompanyName & "' WHERE QuestionID = " & QuestionID & " AND IntervieweeID = " & ID & " "
This is what it prints:
UPDATE Answers SET Answer = 'Answer Test', UserName = 'John Doe', SurveyDate = '08/03/2004', Respondent = 'Respondent Name', CompanyName = 'Company Name' WHERE QuestionID = 1705 AND IntervieweeID = 5
I still haven't been able to get the answer to show up. This works if I leave only the Aswer field to be updated.
SQL = "UPDATE Answers SET Answer = '" & Replace(FieldValue, "'", "''") & "', UserName = '" & UserName & "', SurveyDate = '" & SurveyDate & "', Respondent = '" & Respondent & "', CompanyName = '" & CompanyName & "' WHERE QuestionID = " & QuestionID & " AND IntervieweeID = " & ID & " "
This is what it prints:
UPDATE Answers SET Answer = 'Answer Test', UserName = 'John Doe', SurveyDate = '08/03/2004', Respondent = 'Respondent Name', CompanyName = 'Company Name' WHERE QuestionID = 1705 AND IntervieweeID = 5
I still haven't been able to get the answer to show up. This works if I leave only the Aswer field to be updated.
•
•
Join Date: Apr 2004
Posts: 321
Reputation:
Rep Power: 5
Solved Threads: 8
Posting Whiz
Regretably I cannot help with the script syntax you are using, because I am not familiar with it. I would still add the survey ID to the where clause in case this respondent should take more than one survey.
•
•
Join Date: Jun 2004
Posts: 11
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by bentkey
Regretably I cannot help with the script syntax you are using, because I am not familiar with it. I would still add the survey ID to the where clause in case this respondent should take more than one survey.
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 splitting them up becuase access will not support al the info from all surveys. SurveyID was the identifier for the 3 different surveys.
•
•
Join Date: Jan 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Save yourself the trouble. Try out http://www.survsoft.com
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
avatar backup bcsd bcsm breach ccie certification cisco cissp community comptia creative crime daniweb data protection database design desktop google government hacker home howto ibm illustrator linux magazine medicine microsoft navigation networks news normalization photoshop print red hat research rhce security server social sql survey teleworking theft toread tutorials virtual web work
- Previous Thread: Database versus a Directory?
- Next Thread: Records to HTML pages ?
