Advertisement

08.21.2008 at 07:15PM PDT, ID: 23669094
[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!
9.4

Variable undefined problem in CF8 form

Asked by EricBourland in Cold Fusion Markup Language

Tags:

Hi. I'm getting a variable undefined error for variables that I submit through Checkboxes.

You can see it happening here: https://www.ascassociation.org/webinarsreg/

If I leave any checkboxes unchecked, I get a variable undefined error in webinars2008_data_insert.cfm.

The checkboxes send data to a table in an MS SQL Server 2005 database. The columns have data type "bit" and allow nulls.

I have included in webinars2008_data_insert.cfm a CFIF statement that I thought would deter any variable undefined problems, eg.:

<cfif isdefined("form.ReimbursementCycleChallengesMembers100")>
<input type="hidden" name="ReimbursementCycleChallengesMembers100" value="#FORM.ReimbursementCycleChallengesMembers100#">
<cfelse>
<input type="hidden" name="ReimbursementCycleChallengesMembers100" value="0">
</cfif>

Yet the variable undefined problems exist. Try to process that form without clicking all of the checkboxes and you'll get an error.

Grateful for any advice to solve this? Thanks as always.

Eric

I attach two files: index.cfm and webinars2008_data_insert.cfmStart Free Trial 
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:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:

index.cfm:
 
<cfif CGI.https is "Off">
<cflocation url="https://#cgi.server_name##cgi.script_name#?#cgi.query_string#" addtoken="no" />
</cfif>
 
<cfinclude template="/SiteHeaderSecure.cfm">
 
<!--- When the user submits the Form, she sees the information that she sent --->
<cfif IsDefined('RegistrationID')>
 
   <!--- Display "success" message to user --->
 
 <h2>Thank you for submitting your registration information for the ASC Association Audio Conference, Proposed Rule on ASC Medicare Rates. We will confirm your registration shortly.</h2>
 
<p>Upon receipt of registration, the ASC Association will send a confirmation via email with the toll-free dial-in number for the audio portion of the program and a web site link for you to access prior to the program. If you register for more than one webinar you will receive a separate confirmation for each conference. Your registration is valid for one telephone access line. Contact the Ambulatory Surgery Foundation at 703.836.5904 with any questions.</p>
 
 
  <p>Here is the information you sent:</p>
  
  <!--- set default values --->
  <cfparam name="RegistrationID" default="">
  <cfparam name="Greeting" default="">
  <cfparam name="FirstName" default="">
  <cfparam name="LastName" default="">
  <cfparam name="Credentials" default="">
  <cfparam name="Title" default="">
  <cfparam name="FacilityCompany" default="">
  <cfparam name="Address1" default="">
  <cfparam name="Address2" default="">
  <cfparam name="City" default="">
  <cfparam name="State" default="">
  <cfparam name="Zip" default="">
  <cfparam name="Phone" default="">
  <cfparam name="Fax" default="">
  <cfparam name="Email" default="">
  <cfparam name="TotalEnclosed" default="">
  <cfparam name="FORM.AuthorizeCharge" default="">
  <cfparam name="CreditCard" default="">
  <cfparam name="CreditCardNumber" default="">
  <cfparam name="ExpirationDate" default="">
  <cfparam name="PrintedCardHolderName" default="">
  <cfparam name="CreditCardZIPCode" default="">
  <cfparam name="CVV" default="">
  <cfparam name="DateCreated" default="">
  <cfparam name="ReimbursementCycleChallengesMembers100" default="">
  <cfparam name="ReimbursementCycleChallengesNonMembers150" default="">
  <cfparam name="NewCodes2009Members100" default="">
  <cfparam name="NewCodes2009NonMembers150" default="">
  <cfparam name="OrthopedicCodingMembers100" default="">
  <cfparam name="OrthopedicCodingNonMembers150" default="">
  <cfparam name="Members50Discount" default="">
  
  
 
 
<cfoutput>
<p><strong>RegistrationID:</strong> #RegistrationID#</p>
<p><strong>Greeting:</strong> #Greeting#</p>
<p><strong>First Name:</strong> #FirstName#</p>
<p><strong>Last Name:</strong> #LastName#</p>
<p><strong>Credentials:</strong> #Credentials#</p>
<p><strong>Title:</strong> #Title#</p>
<CFIF FacilityCompany IS NOT ""><p><strong>Facility / Company:</strong> #FacilityCompany#</p></CFIF>
<p><strong>Address Line 1:</strong> #Address1#</p>
<CFIF Address2 IS NOT ""><p><strong>Address Line 2:</strong> #Address2#</p></CFIF>
<p><strong>City:</strong> #City#</p>
<p><strong>State:</strong> #State#</p>
<p><strong>Zip:</strong> #Zip#</p>
<p><strong>Phone:</strong> #Phone#</p>
<CFIF Fax IS NOT ""><p><strong>Fax:</strong> #Fax#</p></CFIF>
<p><strong>Email:</strong> #Email#</p>
 
<CFIF TotalEnclosed IS NOT ""><p><strong>Total Enclosed:</strong> #TotalEnclosed#</p></CFIF>
<CFIF AuthorizeCharge IS NOT ""><p><strong>Authorize Charge:</strong> #FORM.AuthorizeCharge#</p></CFIF>
<CFIF CreditCard IS NOT ""><p><strong>Credit Card:</strong> #CreditCard#</p></CFIF>
<CFIF CreditCardNumber IS NOT ""><p><strong>Credit Card Number:</strong> (Obscured for security)</p></CFIF>
<CFIF ExpirationDate IS NOT ""><p><strong>Expiration Date:</strong> (Obscured for security)</p></CFIF>
<CFIF PrintedCardHolderName IS NOT ""><p><strong>Printed Card Holder Name:</strong> #PrintedCardHolderName#</p></CFIF>
<CFIF CreditCardZIPCode IS NOT ""><p><strong>Credit Card ZIP Code:</strong> #CreditCardZIPCode#</p></CFIF>
<CFIF CVV IS NOT ""><p><strong>CVV:</strong> #CVV#</p></CFIF>
<p><strong>Date Submitted:</strong> #DateCreated#</p>
 
 
<CFIF ReimbursementCycleChallengesMembers100 IS NOT ""><p><strong>I registered for <em>Reimbursement Cycle Challenges and Practical Tips to Overcome</em> as a Member ($100)</strong> #FORM.ReimbursementCycleChallengesMembers100#</p></CFIF>
<CFIF ReimbursementCycleChallengesNonMembers150 IS NOT ""><p><strong>I registered for <em>Reimbursement Cycle Challenges and Practical Tips to Overcome</em> as a Non-Member ($150)</strong> #FORM.ReimbursementCycleChallengesNonMembers150#</p></CFIF>
<CFIF NewCodes2009Members100 IS NOT ""><p><strong>I registered for <em>New Codes for 2009: Hot Off the Press</em> as a Member ($100)</strong> #FORM.NewCodes2009Members100#</p></CFIF>
<CFIF NewCodes2009NonMembers150 IS NOT ""><p><strong>I registered for <em>New Codes for 2009: Hot Off the Press</em> as a Non-Member ($150)</strong> #FORM.NewCodes2009NonMembers150#</p></CFIF>
<CFIF OrthopedicCodingMembers100 IS NOT ""><p><strong>I registered for <em>Traps and Tips for Orthopedic and Pain Management Coding</em> as a Member ($100)</strong> #FORM.OrthopedicCodingMembers100#</p></CFIF>
<CFIF OrthopedicCodingNonMembers150 IS NOT ""><p><strong>I registered for <em>Traps and Tips for Orthopedic and Pain Management Coding</em> as a Non-Member ($150)</strong> #FORM.OrthopedicCodingNonMembers150#</p></CFIF>
 
<CFIF Members50Discount IS NOT ""><p>I am a member of the Ambulatory Surgery Foundation; I have registered for all three conferences by September 9th, 2008, and  will receive a $50 discount off of my total.</strong> #FORM.Members50Discount#</p></CFIF>
 
  
</cfoutput>
  
  <!--- Otherwise, display the form to user... ---> 
<cfelse>
 
 
 <!--- A form to populate conference registration information in table ProposedRuleEntries --->
 
<cfform action="webinars2008_data_insert.cfm" enctype="multipart/form-data">
  
  <h1>Get in Gear for 2009: Fall 2008 Business Office Tune Up Webinars</h1>
  
 
  <h2>Special Audio - Web Conference Series</strong></h2>
  
  
<h3>Reimbursement Cycle Challenges and Practical Tips to Overcome
   
<div class="black"><strong>October 14, 2008</strong></div>
</h3>
<hr class="webform" />
 
 
<h3>New Codes for 2009: Hot Off the Press
   
<div class="black"><strong>November 18, 2008</strong></div></h3>
 
 
<hr class="webform" />
 
 
 
  <h3>Traps and Tips for Orthopedic and Pain Management Coding
    
<div class="black">    <strong>December 16, 2008</strong> </div> </h3>
 
<hr class="webform" />
 
<h1>REGISTRATION INFORMATION</h1>
 
	<table class="uvatable">
		<tr><td class="uvatable-left"><strong>Greeting:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Greeting" /></td></tr>
	<tr><td class="uvatable-left"><strong>First Name:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="FirstName" /></td></tr>
	<tr><td class="uvatable-left"><strong>Last Name:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="LastName" /></td></tr>
		<tr><td class="uvatable-left"><strong>Credentials:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Degree" /></td></tr>
		<tr><td class="uvatable-left"><strong>Title:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Title" /></td></tr>
	<tr><td class="uvatable-left"><strong>Facility / Company:</strong></td> 	<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="FacilityCompany" /></td></tr>
	<tr><td class="uvatable-left"><strong>Address Line 1:</strong></td> 		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Address1" /></td></tr>
		
        
        <tr><td class="uvatable-left"><strong>Address Line 2:</strong></td> 		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Address2" /></td></tr>
	<tr><td class="uvatable-left"><strong>City:</strong></td> 		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="City" /></td></tr>
	<tr><td class="uvatable-left"><strong>State:</strong></td> 		<td class="uvatable-right"><cfinput TYPE="text" SIZE="5" NAME="State" /></td></tr>	
	<tr><td class="uvatable-left"><strong>ZIP:</strong></td> 		<td class="uvatable-right"><cfinput TYPE="text" SIZE="5" NAME="Zip" /></td></tr>
	<tr><td class="uvatable-left"><strong>Phone:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="20" NAME="Phone" /></td></tr>
	<tr><td class="uvatable-left"><strong>Fax:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="20" NAME="Fax" /></td></tr>
	<tr><td class="uvatable-left"><strong>Email:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="Email" /></td></tr>
	</table>
	
<h1>REGISTRATION FEES</h1>
 
 
 
 
<table class="fasatableborder" width="100%">
  <tr>
    <td><h3>Fall 2008 Business Office Tune Up Webinars</h3></td>
    <td valign="bottom"><strong>Members 100</strong></td>
    <td valign="bottom"><strong>Non-Members 150</strong></td>
  </tr>
  <tr>
    <td><strong>Reimbursement Cycle Challenges and Practical Tips to Overcome</strong>
      <div class="red"><em>October 14, 2008</em></div>    </td>
    <td><cfinput type="Checkbox" name="ReimbursementCycleChallengesMembers100" class="noborder" /></td>
    <td><cfinput type="Checkbox" name="ReimbursementCycleChallengesNonMembers150" class="noborder" /></td>
  </tr>
  <tr>
    <td><strong>New Codes for 2009: Hot Off the Press</strong>
      <div class="red"><em>November 18, 2008</em></div>    </td>
    <td><cfinput type="Checkbox" name="NewCodes2009Members100" class="noborder" /></td>
    <td><cfinput type="Checkbox" name="NewCodes2009NonMembers150" class="noborder" /></td>
  </tr>
  <tr>
    <td><strong>Traps and Tips for Orthopedic and Pain Management Coding</strong>
      <div class="red"><em>December 16, 2008</em></div>    </td>
    <td><cfinput type="Checkbox" name="OrthopedicCodingMembers100" class="noborder" /></td>
    <td><cfinput type="Checkbox" name="OrthopedicCodingNonMembers150" class="noborder" /></td>
  </tr>
</table>
 
 
<p><cfinput type="Checkbox" name="Members50Discount" class="noborder" /> <strong>Members:</strong> Check here to register for all three conferences by September 9th, 2008, and receive a $50 discount off your total.</p>
 
 
<h1>PAYMENT INFORMATION</h1>
 
<p>To remit payment, you may print this registration form and fax or mail it to Ambulatory Surgery Foundation with a check. Or, submit your credit card information below. Credit card information is submitted through a secure connection, certified by SecureTrust.</p>
 
 
 
 
<div class="clear-both"></div>
 
<p class="float-left"><cfinput type="Checkbox" name="AuthorizeCharge" class="noborder" /> I authorize Ambulatory Surgery Foundation to charge my:</p>
 
<p class="float-right">
<select name="CreditCard" class="ChicagoSelect">
<option value="SelectCard">Select a Credit Card</option>
<option value="Visa">Visa</option>
<option value="MasterCard">MasterCard</option>
<option value="AmericanExpress">American Express</option></select></p>
 
 
<div class="clear-both"></div>
 
 
<table class="uvatable">
<tr>
	<td>Credit Card Number:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="CreditCardNumber" /></td>
	<td>Expiration Date:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ExpirationDate" /></td>
</tr>
<tr>
	<td>Printed Cardholder Name:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="PrintedCardHolderName" /></td>
	<td>Zip Code:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="CreditCardZIPCode" /></td>
</tr>
<tr>
	<td></td>
	<td></td>
	<td>CVV#/3-digit #:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="CVV" /></td>
</tr>
 
<tr>
	<td></td>
	<td></td>
	<td>Total Enclosed:</td>
	<td> <cfinput TYPE="text" SIZE="30" NAME="TotalEnclosed" />
</td>
</tr>
 
</table>
 
 
<p><strong>Or:</strong> Call 703.836.5904 to register by phone</p>
 
<p><strong>Or:</strong> Print and fax this registration form with credit card information to 703.836.2090.</p>
 
<p>Upon receipt of registration, the ASC Association will send a confirmation via email with the toll-free dial-in number for the audio portion of the program and a web site link for you to access prior to the program. If you register for more than one webinar you will receive a separate confirmation for each conference. Your registration is valid for one telephone access line. Contact the Ambulatory Surgery Foundation at 703.836.5904 with any questions.</p>
	
<p class="align-center"><cfinput type="submit" name="submit" value="Submit Registration" /></p>
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
 
<h1>CONTINUING EDUCATION INFORMATION</h1>
 
<p><strong>AEUs</strong><br />
This program is approved for 4.5 hours of AEU credit by BASC Provider #3272.</p>
	
<p>This information will be used only in conjunction with Ambulatory Surgery Foundation and ASC Association business. We will not share your information with any other organizations.</p>
 
 
<hr />
 
<p class="float-left-img"><script type='text/javascript' src='https://sealserver.trustwave.com/seal.js?style=normal'></script></p>
 
 
 <p>Transactions on this web page are secured by Trustwave. Click the Trustwave logo to the left to verify the security of this page.</p>
 
 
 
<cfinclude template="/SiteFooterSecure.cfm">
 
 
 
 
 
webinars2008_data_insert.cfm
 
<cfif isDefined('FORM.CheckEnclosed')>
<!--- checkbox has been checked and is present in post data --->
<cfset CheckEnclosed = 1>
<cfelse>
<cfset CheckEnclosed = 0>
<!--- checkbox not checked and not present --->
</cfif>
 
 
<cfif isDefined('FORM.AuthorizeCharge')>
<!--- checkbox has been checked and is present in post data --->
<cfset AuthorizeCharge = 1>
<cfelse>
<cfset AuthorizeCharge = 0>
<!--- checkbox not checked and not present --->
</cfif>
 <strong></strong>
<!--- Insert values into database columns --->
<cfquery datasource="ebwebwork" dbname="ascassociation" name="createRegistration">
	INSERT INTO Webinar2008Entries (
		Greeting,
		FirstName,
		LastName,
		Credentials,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		TotalEnclosed,
		AuthorizeCharge,
		CreditCard,
		CreditCardNumber,
		ExpirationDate,
		PrintedCardHolderName,
		CreditCardZIPCode,
		CVV,
        DateCreated,
        ReimbursementCycleChallengesMembers100,
        ReimbursementCycleChallengesNonMembers150,
        NewCodes2009Members100,
        NewCodes2009NonMembers150,
        OrthopedicCodingMembers100,
        OrthopedicCodingNonMembers150,
        Members50Discount)
	VALUES(
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Greeting#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#FirstName#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#LastName#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Degree#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Title#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#FacilityCompany#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Address1#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Address2#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#City#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#State#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Zip#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Phone#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Fax#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Email#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#TotalEnclosed#">,
		<cfqueryparam cfsqltype="cf_sql_bit" value="#AuthorizeCharge#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CreditCard#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CreditCardNumber#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#ExpirationDate#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#PrintedCardHolderName#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CreditCardZIPCode#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CVV#">,
   		<cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#">,
        <cfqueryparam cfsqltype="cf_sql_varchar" value="#ReimbursementCycleChallengesMembers100#">,
   		<cfqueryparam cfsqltype="cf_sql_varchar" value="#ReimbursementCycleChallengesNonMembers150#">,
  		<cfqueryparam cfsqltype="cf_sql_varchar" value="#NewCodes2009Members100#">,
  		<cfqueryparam cfsqltype="cf_sql_varchar" value="#NewCodes2009NonMembers150#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#OrthopedicCodingMembers100#">,
 		<cfqueryparam cfsqltype="cf_sql_varchar" value="#OrthopedicCodingNonMembers150#">,
   		<cfqueryparam cfsqltype="cf_sql_varchar" value="#Members50Discount#">);
	SELECT scope_identity() AS ident
</cfquery>
		  
<!--- pass info back to previous page --->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
<html>
<head>
	<title>Registration Submitted</title>
</head>
 
<body onLoad="document.form.submit();">
 
 <cfoutput>
 
<form name="form" method="post" action="/webinarsreg/index.cfm">
 
<!--- set value from newly created RegistrationID --->
<input type="hidden" name="RegistrationID" value="#createRegistration.ident#">
<!--- set rest of values from submitted form --->
<input type="hidden" name="Name" value="#FORM.Greeting#">
<input type="hidden" name="Name" value="#FORM.FirstName#">
<input type="hidden" name="Name" value="#FORM.LastName#">
<input type="hidden" name="Degree" value="#FORM.Degree#">
<input type="hidden" name="Title" value="#FORM.Title#">
<input type="hidden" name="FacilityCompany" value="#FORM.FacilityCompany#">
<input type="hidden" name="Address1" value="#FORM.Address1#">
<input type="hidden" name="Address2" value="#FORM.Address2#">
<input type="hidden" name="City" value="#FORM.City#">
<input type="hidden" name="State" value="#FORM.State#">
<input type="hidden" name="Zip" value="#FORM.Zip#">
<input type="hidden" name="Phone" value="#FORM.Phone#">
<input type="hidden" name="Fax" value="#FORM.Fax#">
<input type="hidden" name="Email" value="#FORM.Email#">
<input type="hidden" name="TotalEnclosed" value="#FORM.TotalEnclosed#">
 
 
 
<cfif isdefined("form.AuthorizeCharge")>
<input type="hidden" name="AuthorizeCharge" value="#FORM.AuthorizeCharge#">
<cfelse>
<input type="hidden" name="AuthorizeCharge" value="0">
</cfif>
 
<input type="hidden" name="CreditCard" value="#FORM.CreditCard#">
<input type="hidden" name="CreditCardNumber" value="#FORM.CreditCardNumber#">
<input type="hidden" name="ExpirationDate" value="#FORM.ExpirationDate#">
<input type="hidden" name="PrintedCardHolderName" value="#FORM.PrintedCardHolderName#">
<input type="hidden" name="CreditCardZIPCode" value="#FORM.CreditCardZIPCode#">
<input type="hidden" name="CVV" value="#FORM.CVV#">
 
 
<cfif isdefined("form.ReimbursementCycleChallengesMembers100")>
<input type="hidden" name="ReimbursementCycleChallengesMembers100" value="#FORM.ReimbursementCycleChallengesMembers100#">
<cfelse>
<input type="hidden" name="ReimbursementCycleChallengesMembers100" value="0">
</cfif>
 
<cfif isdefined("form.ReimbursementCycleChallengesNonMembers150")>
<input type="hidden" name="ReimbursementCycleChallengesNonMembers150" value="#FORM.ReimbursementCycleChallengesNonMembers150#">
<cfelse>
<input type="hidden" name="ReimbursementCycleChallengesNonMembers150" value="0">
</cfif>
 
<cfif isdefined("form.NewCodes2009Members100")>
<input type="hidden" name="NewCodes2009Members100" value="#FORM.NewCodes2009Members100#">
<cfelse>
<input type="hidden" name="NewCodes2009Members100" value="0">
</cfif>
 
<cfif isdefined("form.NewCodes2009NonMembers150")>
<input type="hidden" name="NewCodes2009NonMembers150" value="#FORM.NewCodes2009NonMembers150#">
<cfelse>
<input type="hidden" name="NewCodes2009NonMembers150" value="0">
</cfif>
 
<cfif isdefined("form.OrthopedicCodingMembers100")>
<input type="hidden" name="OrthopedicCodingMembers100" value="#FORM.OrthopedicCodingMembers100#">
<cfelse>
<input type="hidden" name="OrthopedicCodingMembers100" value="0">
</cfif>
 
<cfif isdefined("form.OrthopedicCodingNonMembers150")>
<input type="hidden" name="OrthopedicCodingNonMembers150" value="#FORM.OrthopedicCodingNonMembers150#">
<cfelse>
<input type="hidden" name="OrthopedicCodingNonMembers150" value="0">
</cfif>
 
<cfif isdefined("form.Members50Discount")>
<input type="hidden" name="Members50Discount" value="#FORM.Members50Discount#">
<cfelse>
<input type="hidden" name="Members50Discount" value="0">
</cfif>
 
 
<input type="hidden" name="DateCreated" value="#DateFormat(now(), "mm/dd/yyyy")#">
 
</form>
 </cfoutput>
</body>
</html>
 
Keywords: Variable undefined problem in CF8 form
Title
1 Not IsDefined
2 Undefined Values / Null Pointers error?
3 IsDefined problem
4 Cfif isdefined??????
5 CFSELECT and CFIF
6 CF8 CFLAYOUT causing "Error proc…
 
Loading Advertisement...
 
[+][-]08.21.2008 at 07:40PM PDT, ID: 22285889

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Cold Fusion Markup Language
Tags: ColdFusion 8, MS SQL Server 2005
Sign Up Now!
Solution Provided By: Plucka
Participating Experts: 3
Solution Grade: A
 
 
[+][-]08.21.2008 at 09:17PM PDT, ID: 22286600

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]08.21.2008 at 10:09PM PDT, ID: 22286949

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628