Ok so I'm making a survey for a website and I have a series of questions where the user can rate it from a list of choices and I have these questions in a table in access and the rating options in a table. I want to have the questions display with the options in a dropdown box next to each question, I can't seem to get this to work. Here is my code:
<!--- Get ratings --->
<cfquery datasource="PFB" name="RatingsQ">
SELECT *
FROM Ratings, Questions
ORDER BY RatingID, QuestionID
</cfquery>
<!--- Get genders --->
<cfquery datasource="PFB" name="Gender">
SELECT *
FROM Gender
ORDER BY ID
</cfquery>
<!--- Get states --->
<cfquery datasource="PFB" name="State">
SELECT *
FROM State
ORDER BY StateID
</cfquery>
<!--- Get questions2 --->
<cfquery datasource="PFB" name="Questions2">
SELECT *
FROM Questions2
ORDER BY Question_ID
</cfquery>
<!----get ages----->
<cfquery datasource="PFB" name="Age">
SELECT ID, Age
FROM Age
ORDER BY ID
</cfquery>
<html>
<body>
<cfform action="insertnewreview.cfm">
<table>
<tr>
<td>Age:</td>
<td> <select name="AgeID">
<cfoutput query="Age">
<option value="#ID#">#Age#</option></cfoutput>
</select>
</td>
</tr>
<tr>
<td>
Gender:
</td>
<td>
<select name="Gender">
<cfoutput query="Gender">
<option value="#Gender#">#Gender#</option></cfoutput>
</select>
</td>
</tr>
<tr>
<td>
State:
</td>
<td>
<select name="State">
<cfoutput query="State">
<option value="#State#">#State#</option></cfoutput>
</select>
</td>
</tr>
<tr>
<td><cfoutput query="RatingsQ"><br><br>#Question#</td><td><select name="RatingID"><option value="#RatingID#">#Rating#</option>
</select></cfoutput></td></tr>
<tr>
<td><cfoutput query="Questions2">#Q#:</cfoutput></td>
<td>Answer: <textarea></textarea></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="Insert"></td>
</tr>
</table>
</cfform>
</body>
</html>
Last edited by peter_budo : Apr 7th, 2008 at 7:02 pm. Reason: Keep It Organized - please use [code] tags
