	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

(revised for clarity) Survey form; help with setting an initial value for a newly created Unique ID?

Asked by EricBourland in Cold Fusion Markup Language

Tags: ColdFusion 6; unique ID, ColdFusion 8

Hi. I have a simple survey form here:

http://ebwebwork.com/cep/consumersurvey/

The form will not process data. I've been troubleshooting and tinkering with this form for a couple of days (and got some very useful help from _agx_).

It's almost finished -- but I have a problem with my action page: data_insert.cfm

In that page, I need to set an initial value for the unique ID in my database table, which is column SurveyResponseID. (This column is also PK.)

If you submit the form, you will see this error:

Element IDENT is undefined in SURVEYRESPONSEID.

The error occurred in C:\websites\ebwebwork.com\cep\consumersurvey\data_insert.cfm: line 73

71 :
72 : 
73 : <input type="hidden" name="SurveyResponseID" value="#SurveyResponseID.ident#">
74 : 
75 : <input type="hidden" name="affiliation" value="#FORM.affiliation#">

So, I thought that I defined element IDENT with this statement in the action page, in query "CEP_Survey_Responses":

SELECT scope_identity() AS ident

... but apparently ColdFusion does not accept my definition.

What am I missing here? I'm close to finishing this application, I am just stuck on this one part.

Also, I'm very grateful for any advice you have to streamline or optimize the application. If anyone has time.

Thanks as always.

Eric

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:

           
           
             index.cfm:
 
<!--- details and notes about this application --->
 
<!---
 
Task: set up a simple survey for for the Center on Education Policy (CEP).
 
Web page should validate XHTML.
 
DB: MS SQL Server 2005
 
Two tables:
CEP_Survey_Affiliation -- lists the 24 kinds of affiliation that survey respondees can select
CEP_Survey_Responses -- contains survey responses; lists variables for survey responses
 
ODBC Interpreter: ColdFusion 8
 
action page: data_insert.cfm
 
URL: http://ebwebwork.com/cep/consumersurvey/
 
--->
 
<!--- /details and notes --->
 
 
 
 
 <!--- this query, Get_CEP_Survey_Affiliation, is used to output the CEP Survey Affiliation options in form, below --->
 
<cfquery datasource="ebwebwork" dbname="ebwebwork" name="Get_CEP_Survey_Affiliation">
SELECT affiliationID, affiliation
FROM CEP_Survey_Affiliation
</cfquery>
 
  
  
  <!--- include header --->
<cfinclude template="/cep/cep_header.cfm" />
  
 
 <!--- After the user submits the Form, she sees the information that she sent --->
<cfif IsDefined('SurveyResponseID')>
 
 
  <!--- set default values for variables in table CEP_Survey_Responses --->
  <cfparam name="SurveyResponseID" default="" />
  
  <cfparam name="affiliation" default="" />
  
  <cfparam name="AwareCEPAnnualReportsStateTests" default="" />
  
  <cfparam name="informationcontainedreportsuseful" default="" />
  
  <cfparam name="howuseddatacontainedreports" default="" />
  
  <cfparam name="adviceimprovereports" default="" />
  
  <cfparam name="awareCEPotherwork" default="" />
  
  <cfparam name="whatworkawareof" default="" />
  
  <cfparam name="howimproveworkintheseareas" default="" />
  
  <cfparam name="DateCreated" default="" />
 
 
<!--- Display "success" message to user; display the information that the user submitted in the form --->
 
  <p>Thank you for taking the time to fill out the survey. We value your advice and have carefully noted your responses. Here is the information you sent:</p>
  
<cfoutput>
<p><strong>SurveyResponseID:</strong> #SurveyResponseID#</p>
 
<cfif affiliation IS NOT ""><p><strong>Affiliation:</strong> #affiliation#</p></cfif>
 
 
<cfif AwareCEPAnnualReportsStateTests IS NOT ""><p><strong>Are you aware of CEP's annual reports on state tests?</strong> #AwareCEPAnnualReportsStateTests#</p></cfif>
 
 
<cfif informationcontainedreportsuseful IS NOT ""><p><strong>Have you found the information contained in the reports useful?</strong> #informationcontainedreportsuseful#</p></cfif>
 
 
<cfif howuseddatacontainedreports IS NOT ""><p><strong>How have you used the information or data contained in the reports?</strong> #howuseddatacontainedreports#</p></cfif>
 
 
<cfif adviceimprovereports IS NOT ""><p><strong>Do you have any advice to improve the reports to make them more useful to you or your organization?</strong> #adviceimprovereports#</p></cfif>
 
 
<cfif awareCEPotherwork IS NOT ""><p><strong>Are you aware of CEP's other work?</strong> #awareCEPotherwork#</p></cfif>
 
 
<cfif whatworkawareof IS NOT ""><p><strong>What work are you aware of?</strong> #whatworkawareof#</p></cfif>
 
 
<cfif howimproveworkintheseareas IS NOT ""><p><strong>What can we do to improve our work in these other areas?</strong> #howimproveworkintheseareas#</p></cfif>
 
 
<p><strong>Date Submitted:</strong> #DateCreated#</p>
  
</cfoutput>
 
 
  
  <!--- If user has not submitted the form, then SurveyResponseID is not defined, and we should display the form to user... ---> 
 
<cfelse>
 
 
 
 <!--- This is a form to populate the CEP Consumer Survey, November 2009, table CEP_Survey_Responses --->
 
 
<cfform action="data_insert.cfm" enctype="multipart/form-data">
 
 
 
 <!--- title and introductory text --->
<h1>CEP Consumer Survey, 2009</h1>
 
<p>Since 2007, the Center on Education Policy has collected and analyzed student test data from all 50 states and has published our findings in a series of reports showing overall trends in test scores and trends in achievement gaps between different groups of students. All of these reports, along with test score data from all the states, appear on CEP's Web site. Thank you for taking the time to fill out the survey. We value your advice.</p>
 
 
<h2 class="align-center">Affiliation (indicate all that apply):</h2>
 
 
 <!--- output the CEP Survey Affiliation options, from table CEP_Survey_Affiliation --->
 
<cfoutput query="Get_CEP_Survey_Affiliation">
 
<div class="left_checkbox">
<cfinput type="checkbox" name="affiliation" id="affiliation#currentRow#" value="#affiliationID#" tabindex="#affiliationID#" />
</div> 
                
<div class="right_checkbox">
#affiliation#
</div> 
 
 
<div class="clear-both"></div>
 
</cfoutput>
 
 
 
<p>Other affiliation? (Enter here) <cfinput type="text" size="30" name="affiliation" value="" tabindex="25"  /></p>
	
    
    
    <div class="clear-both">&nbsp;</div>
    
    
    
    <h2 class="align-center">Are you aware of CEP's annual reports on state tests?</h2>
    
    
    
    <p>Since 2007, CEP has issued annual reports on analyzing state testing data.  These reports include <em>Answering the Question that Matters Most: Has Student Achievement Increased Since No Child Left Behind?</em>; <em>Has Student Achievement Increased Since 2002? State Test Scores Trends Through 2006-07</em>; and the <em>State Test Score Trends Through 2007-08</em> series. <strong>Are you aware of CEP's annual reports on state tests?</strong></p>
    
			
<p><cfinput type="radio" name="AwareCEPAnnualReportsStateTests" id="AwareCEPAnnualReportsStateTests1" value="Yes" tabindex="25" /> Yes</p>
 
			
<p><cfinput type="radio" name="AwareCEPAnnualReportsStateTests" id="AwareCEPAnnualReportsStateTests2" value="No" tabindex="26" /> No</p>
			
		
		
		
 
<h2 class="align-center">If you answered yes:</h2>
		
		 
         <h3>a. Have you found the information contained in the reports useful?</h3>
			
<p><cfinput type="radio" name="informationcontainedreportsuseful" id="informationcontainedreportsuseful1" value="Yes" tabindex="27" /> Yes</p>
			
<p><cfinput type="radio" name="informationcontainedreportsuseful" id="informationcontainedreportsuseful2" value="No" tabindex="28" /> No</p>
 
		
	
<h3>b. How have you used the information or data contained in the reports?</h3>
 
<textarea rows="5" cols="40" name="howuseddatacontainedreports" tabindex="29"></textarea>
		
 
<h3>c. Do you have any advice to improve the reports to make them more useful to you or your organization?</h3>
 
			
<textarea  rows="5" cols="40" name="adviceimprovereports" tabindex="30"></textarea>
		
		
			  
		
		
<h2 class="align-center">Are you aware of CEP's other work?</h2>
		
	
		
	<h3>Are you aware of CEP's other work, such as our studies of high school exit exams, studies of the No Child Left Behind Act, research on school restructuring, or other work?</h3>
    
 
			
<p><cfinput type="radio" name="awareCEPotherwork" id="awareCEPotherwork1" value="Yes" tabindex="31"> Yes</p>
		
<p><cfinput type="radio" name="awareCEPotherwork" id="awareCEPotherwork2" value="No" tabindex="32"> No</p>
			
		
		
		
	<h2 class="align-center">If you answered yes:</h2>
		
	
<h3>a. What work are you aware of?</h3>
 
			
<textarea rows="5" cols="40" name="whatworkawareof" tabindex="33"></textarea>
 
		
		
        <h3>b. What can we do to improve our work in these other areas?</h3>
			
<textarea rows="5" cols="40" name="howimproveworkintheseareas" tabindex="34"></textarea>
		
			
	   
			<p class="align-center"><cfinput type="submit" name="submit" value="Send Survey" tabindex="35" /></p>
 
 
 
      <!--- close CFFORM --->
</cfform>
 
 
 <!--- close cfif IsDefined('SurveyResponseID') --->
 
</cfif> 
 
 
<!--- include footer --->
<cfinclude template="/cep/cep_footer.cfm" />
 
 
 
action page (data_insert.cfm):
 
<cfif isDefined('FORM.AwareCEPAnnualReportsStateTests')>
<!--- radio input has been checked and is present in post data --->
<cfset AwareCEPAnnualReportsStateTests = 1>
<cfelse>
<cfset AwareCEPAnnualReportsStateTests = 0>
<!--- radio input not checked and not present --->
</cfif>
 
<cfif isDefined('FORM.informationcontainedreportsuseful')>
<!--- radio input has been checked and is present in post data --->
<cfset informationcontainedreportsuseful = 1>
<cfelse>
<cfset informationcontainedreportsuseful = 0>
<!--- radio input not checked and not present --->
</cfif>
 
 
<cfif isDefined('FORM.awareCEPotherwork')>
<!--- radio input has been checked and is present in post data --->
<cfset awareCEPotherwork = 1>
<cfelse>
<cfset awareCEPotherwork = 0>
<!--- radio input not checked and not present --->
</cfif>
 
 
<!--- Insert values into table CEP_Survey_Responses columns --->
<cfquery datasource="ebwebwork" dbname="ebwebwork" name="CEP_Survey_Responses">
	INSERT INTO CEP_Survey_Responses (
		affiliation,
		AwareCEPAnnualReportsStateTests,
		informationcontainedreportsuseful,
		howuseddatacontainedreports,
		adviceimprovereports,
		awareCEPotherwork,
		whatworkawareof,
		howimproveworkintheseareas,
		DateCreated)
	VALUES(
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#affiliation#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#AwareCEPAnnualReportsStateTests#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#informationcontainedreportsuseful#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#howuseddatacontainedreports#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#adviceimprovereports#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#awareCEPotherwork#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#whatworkawareof#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#howimproveworkintheseareas#">,
		<cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#">);
	SELECT scope_identity() AS ident
</cfquery>
 
 
		  
<!--- pass the survey responses back to the previous page --->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
<html>
<head>
	<title>CEP Consumer Survey Responses Sent</title>
</head>
 
<body>
 
 
 
<!--- post inputs from FORM --->
  
 <cfoutput>
 
<form name="form" method="post" action="index.cfm">
 
<!--- set value from newly created SurveyResponseID --->
<input type="hidden" name="SurveyResponseID" value="#SurveyResponseID.ident#">
<!--- set rest of values from submitted form --->
<input type="hidden" name="affiliation" value="#FORM.affiliation#">
 
 
<cfif isdefined("form.AwareCEPAnnualReportsStateTests")>
<input type="hidden" name="AwareCEPAnnualReportsStateTests" value="#FORM.AwareCEPAnnualReportsStateTests#">
<cfelse>
<input type="hidden" name="AwareCEPAnnualReportsStateTests" value="0">
</cfif>
 
 
 
<cfif isdefined("form.informationcontainedreportsuseful")>
<input type="hidden" name="informationcontainedreportsuseful" value="#FORM.informationcontainedreportsuseful#">
<cfelse>
<input type="hidden" name="informationcontainedreportsuseful" value="0">
</cfif>
 
 
<input type="hidden" name="howuseddatacontainedreports" value="#FORM.howuseddatacontainedreports#">
 
<input type="hidden" name="adviceimprovereports" value="#FORM.adviceimprovereports#">
 
 
 
<cfif isdefined("form.awareCEPotherwork")>
<input type="hidden" name="awareCEPotherwork" value="#FORM.awareCEPotherwork#">
<cfelse>
<input type="hidden" name="awareCEPotherwork" value="0">
</cfif>
 
 
 
 
<input type="hidden" name="whatworkawareof" value="#FORM.whatworkawareof#">
 
<input type="hidden" name="howimproveworkintheseareas" value="#FORM.howimproveworkintheseareas#">
 
<input type="hidden" name="DateCreated" value="#DateFormat(now(), "mm/dd/yyyy")#">
 
</form>
 </cfoutput>
 
 
 
 
 
 
</body>
</html>
           
         

20100308-EE-VQP-141 - Hierarchy / EE_QW_3_20080625

Your technology problems solved.

Close See Plans and Pricing. Try it FREE for 30 days.

Hall of Fame

1. _agx_119,734
2. azadisaryev50,932
3. dgrafx50,257
4. gdemaria35,500
5. SidFishes23,832
6. duncancu...20,800
7. erikTsomik19,000
8. Plucka17,752
9. plusone3...9,000
10. MarcLight8,200
11. mwvisa18,000
12. parikaa7,900
13. srikanthm...6,800
13. xoundboy6,800
15. leakim9716,600
16. myselfran...6,400
17. trailblazzy...6,000
17. zadoc6,000
17. pradyahuja6,000
20. matthews...4,000
20. TerryAtO...4,000
20. Gudmundius4,000
23. asafadis3,500
24. mplungjan3,000
24. DrDamnit3,000
24. RickEpnet3,000

1. _agx_992,283
2. gdemaria913,581
3. azadisaryev774,022
4. SidFishes612,073
5. Zvonko413,862
6. duncancu...267,113
7. SBennett218,923
8. erikTsomik181,097
9. Plucka173,133
10. zadoc148,564
11. Jones911147,584
12. dgrafx111,507
13. hielo95,782
14. pmascari77,529
15. srikanthm...74,252
16. js_vaughan70,620
17. Jester_4867,845
18. Mr_Nil64,433
19. angelIII45,818
20. myselfran...44,528
21. pigmentarts42,698
22. eszaq42,639
23. Mause39,900
24. digicidal37,950
25. mwvisa137,450

(revised for clarity) Survey form; help with setting an initial value for a newly created Unique ID?

Asked by EricBourland in Cold Fusion Markup Language

Tags: ColdFusion 6; unique ID, ColdFusion 8

About this solution