Re: survey code not working

•

•

•

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 373,100 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 3,765 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.

Join our community!

Please support our ColdFusion advertiser:

survey code not working

•

•

Join Date: Feb 2008

Posts: 68

Reputation: cmhampton is an unknown quantity at this point

cmhampton is an unknown quantity at this point

Rep Power: 1

Solved Threads: 9

cmhampton is offline

Offline

Junior Poster in Training

Re: survey code not working

#2

Apr 10th, 2008

The group attribute of cfquery is one of the most unknown and under-appreciated pieces of the entire language. It's so incredibly simple to use it's a wonder more people aren't told about it.

I modified your output to use grouping and it should make your life a little easier (programming life at least, I'm not a messiah

)...

Take a look at lines 67-83

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<!--- 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>
 
		<!--- Updated grouping here --->
		<cfoutput query="RatingsQ" group="QuestionID">
			<tr>
				<td>
				<br>
					<br>
					#Question#
					</td>
					<td>
						<cfoutput>
							<select name="RatingID">
								<option value="#RatingID#">#Rating#</option>
							</select>
						</cfoutput>
 
				</td>
			</tr>
		</cfoutput>
 
		<!--- Changed this cfoutput --->
		<cfoutput query="Questions2">
			<tr>
				<td>#Q#:</td>
				<td>
					Answer:
					<textarea></textarea>
				</td>
			</tr>
		</cfoutput>
		<tr>
			<td colspan="2" align="center"><input type="submit" value="Insert"></td>
		</tr>
	</table>
</cfform>
</body>
</html>
<!--- 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>
		
		<!--- Updated grouping here --->
		<cfoutput query="RatingsQ" group="QuestionID">
			<tr>
				<td>
				<br>
					<br>
					#Question#
					</td>
					<td>
						<cfoutput>
							<select name="RatingID">
								<option value="#RatingID#">#Rating#</option>
							</select>
						</cfoutput>
				
				</td>
			</tr>
		</cfoutput>
		
		<!--- Changed this cfoutput --->
		<cfoutput query="Questions2">
			<tr>
				<td>#Q#:</td>
				<td>
					Answer:
					<textarea></textarea>
				</td>
			</tr>
		</cfoutput>
		<tr>
			<td colspan="2" align="center"><input type="submit" value="Insert"></td>
		</tr>
	</table>
</cfform>
</body>
</html>

I also changed lines 85-94 a little to make the output of the Question2 section a little cleaner.

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 373,100

Users Online Now: 3,765

Active IRC Users: 19

Forum Threads: 123,356

Forum Posts: 638,491

Code Snippets: 849

Blogs: 139

Blog Entries: 1,948

Directory Links: 563