Advertisement

08.08.2008 at 12:26PM PDT, ID: 23633806
[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.2

Form processes, but refuses to display two variables: FirstName, LastName

Asked by EricBourland in Cold Fusion Markup Language

Tags: ,

Hi friends. May I ask your help? I'm getting a weird error in a ColdFusion application. I have stared at the code for a long time and cannot figure out what's going on.

The application is located here:

https://www.ascassociation.org/chicagoOct2008.cfm

It is a simple registration form, submitted with SSL encryption. The user inputs her information, which is submitted to an MS SQL 2005 database.

However, when the form displays results, the variables FirstName and LastName are omitted. FirstName and LastName do not appear in the form results.

ColdFusion does <strong>not</strong> throw an error, and the form <strong>does</strong> process correctly. Furthermore, the variables FirstName and LastName are transmitted correctly to the database.

In the database, the columns FirstName and LastName have datatype: nvarchar(255), with nulls permitted.

I append two files: chicagoOct2008.cfm and conference_data_insert.cfm.

I have looked at this code for a couple of days, and tried different ideas, but I am unable to get the two missing variables to appear. What am I missing?

Thanks for any ideas.

Best from Eric


Start 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:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:

chicagoOct2008.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 information to register for ASC Communications and the Ambulatory Surgery Foundation's Business and Legal Issues Conference, October 23&#8211;25, 2008 at the Sheraton Hotel and Towers in Chicago, IL.</h2>
 
  <p>Your form is being processed.  Within two weeks, you will receive official confirmation and your receipt of payment by email from the Ambulatory Surgery Foundation with meeting details.  Please don't hesitate to call the registration office with questions at 703.836.5904 or email <a href="mailto:arichey@ascassociation.org">arichey@ascassociation.org</a>.</p>
 
  <p>Here is the information you sent:</p>
  
  <!--- set default values --->
  <cfparam name="RegistrationID" default="">
  <cfparam name="FirstName" default="">
  <cfparam name="LastName" default="">
  <cfparam name="Degree" 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="WebSite" default="">
  <cfparam name="RNLicenseNumber" default="">
  <cfparam name="MainConference1stAttendeeAmountBefore8Sep625" default="">
  <cfparam name="MainConference2ndAttendeeAmountBefore8Sep575" default="">
  <cfparam name="MainConference3rdAttendeeAmountBefore8Sep525" default="">
  <cfparam name="MainConference4thAttendeeAmountBefore8Sep500" default="">
  <cfparam name="MainConference1stAttendeeAmountAfter8Sep725" default="">
  <cfparam name="MainConference2ndAttendeeAmountAfter8Sep675" default="">
  <cfparam name="MainConference3rdAttendeeAmountAfter8Sep625" default="">
  <cfparam name="MainConference4thAttendeeAmountAfter8Sep600" default="">
  <cfparam name="MainandPreConference1stAttendeeAmountBefore8Sep825" default="">
  <cfparam name="MainandPreConference2ndAttendeeAmountBefore8Sep775" default="">
  <cfparam name="MainandPreConference3rdAttendeeAmountBefore8Sep725" default="">
  <cfparam name="MainandPreConference4thAttendeeAmountBefore8Sep700" default="">
  <cfparam name="MainandPreConference1stAttendeeAmountAfter8Sep975" default="">
  <cfparam name="MainandPreConference2ndAttendeeAmountAfter8Sep875" default="">
  <cfparam name="MainandPreConference3rdAttendeeAmountAfter8Sep825" default="">
  <cfparam name="MainandPreConference4thAttendeeAmountAfter8Sep800" default="">
  <cfparam name="BeckersASCReviewSpecialDiscount" default="">
  <cfparam name="ASCReviewSubscriberDiscountFifty" default="">
  <cfparam name="TotalEnclosed" default="">
  <cfparam name="FORM.CheckEnclosed" default="">
  <cfparam name="CheckNumber" 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="">
 
 
<cfoutput>
<p><strong>RegistrationID:</strong> #RegistrationID#</p>
<CFIF FirstName IS NOT ""><p><strong>First Name:</strong> #FirstName#</p></CFIF>
<CFIF LastName IS NOT ""><p><strong>Last Name:</strong> #LastName#</p></CFIF>
<p><strong>Credential:</strong> #Degree#</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 WebSite IS NOT ""><p><strong>Web Site:</strong> #WebSite#</p></CFIF>
 
<CFIF RNLicenseNumber IS NOT ""><p><strong>RN License Number:</strong>  #RNLicenseNumber#</p></CFIF>
 
<CFIF MainConference1stAttendeeAmountBefore8Sep625 IS NOT ""><p><strong>Main Conference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference1stAttendeeAmountBefore8Sep625#</p></CFIF>
 
<CFIF MainConference2ndAttendeeAmountBefore8Sep575 IS NOT ""><p><strong>Main Conference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference2ndAttendeeAmountBefore8Sep575#</p></CFIF>
 
<CFIF MainConference3rdAttendeeAmountBefore8Sep525 IS NOT ""><p><strong>Main Conference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference3rdAttendeeAmountBefore8Sep525#</p></CFIF>
 
<CFIF MainConference4thAttendeeAmountBefore8Sep500 IS NOT ""><p><strong>Main Conference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference4thAttendeeAmountBefore8Sep500#</p></CFIF>
 
<CFIF MainConference1stAttendeeAmountAfter8Sep725 IS NOT ""><p><strong>Main Conference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference1stAttendeeAmountAfter8Sep725#</p></CFIF>
 
<CFIF MainConference2ndAttendeeAmountAfter8Sep675 IS NOT ""><p><strong>Main Conference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference2ndAttendeeAmountAfter8Sep675#</p></CFIF>
 
<CFIF MainConference3rdAttendeeAmountAfter8Sep625 IS NOT ""><p><strong>Main Conference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference3rdAttendeeAmountAfter8Sep625#</p></CFIF>
 
<CFIF MainConference4thAttendeeAmountAfter8Sep600 IS NOT ""><p><strong>Main Conference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference4thAttendeeAmountAfter8Sep600#</p></CFIF>
 
<CFIF MainandPreConference1stAttendeeAmountBefore8Sep825 IS NOT ""><p><strong>Main and PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountBefore8Sep825#</p></CFIF>
 
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><p><strong>Main and PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountBefore8Sep775#</p></CFIF>
 
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><p><strong>Main and PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountBefore8Sep725#</p></CFIF>
 
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><p><strong>Main and PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountBefore8Sep700#</p></CFIF>
 
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><p><strong>Main and PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountAfter8Sep975#</p></CFIF>
 
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><p><strong>Main and PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountAfter8Sep875#</p></CFIF>
 
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><p><strong>Main and PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountAfter8Sep825#</p></CFIF>
 
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><p><strong>Main and PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountAfter8Sep800#</p></CFIF>
 
<CFIF BeckersASCReviewSpecialDiscount IS NOT ""><p><strong>Beckers ASC Review Special Discount:</strong> #BeckersASCReviewSpecialDiscount#</p></CFIF>
<CFIF ASCReviewSubscriberDiscountFifty IS NOT ""><p><strong>ASC Review Subscriber Discount ($50):</strong> #ASCReviewSubscriberDiscountFifty#</p></CFIF>
<CFIF TotalEnclosed IS NOT ""><p><strong>Total Enclosed:</strong> #TotalEnclosed#</p></CFIF>
<CFIF CheckEnclosed IS NOT ""><p><strong>Check Enclosed:</strong> #FORM.CheckEnclosed#</p></CFIF>
<CFIF CheckNumber IS NOT ""><p><strong>Check Number:</strong> #CheckNumber#</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>
  
</cfoutput>
  
  <!--- Otherwise, display the form to user... ---> 
<cfelse>
 
 
 <!--- A form to populate conference registration information in table RegistrationEntries --->
 
<cfform action="/conference_data_insert.cfm" enctype="multipart/form-data">
  
  <h1>Business and Legal Issues Conference</h1>
 
 <h3>October 23 &#8211; 25, 2008</h3>
 
<h3>Chicago, Illinois</h3>
 
  
<h2>REGISTRATION INFORMATION</h2>
 
	<table class="uvatable">
	<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>Credential:</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>
		<tr><td class="uvatable-left"><strong>Web Site:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="WebSite" /></td></tr>
 
<tr><td class="uvatable-left"><strong>RN License Number:</strong></td>		<td class="uvatable-right"><cfinput TYPE="text" SIZE="30" NAME="RNLicenseNumber" /></td></tr>
 
	</table>
	
<h1>REGISTRATION FEES</h1>
 
 
<h2>ANNUAL CONFERENCE &#38; EXHIBITS</h2>
<p>Receive multiple registrant discount(s). The more people you send the greater discount you receive. The prices listed
below are per person. Your registration includes all conference sessions, materials and meal functions.</p>
 
 
<h2>MAIN CONFERENCE ONLY</h2>
 
	<table class="uvatable">
<tr>
	<td></td>
	<td class="uvatable-left"><strong>FEES<br />(Before 9/10/08)</strong></td>
	<td class="uvatable-left"><strong>ENTER AMOUNT</strong></td>
	<td class="uvatable-left"><strong>FEES<br />(After 9/10/08)</strong></td>
	<td class="uvatable-left"><strong>ENTER AMOUNT</strong></td>
 
</tr>
<tr>
	<td class="uvatable-left">1st Attendee</td>
	<td class="uvatable-left">$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountBefore8Sep625" /></td>
	<td class="uvatable-left">$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountAfter8Sep725" /></td>
 
</tr>
<tr>
	<td class="uvatable-left">2nd Attendee</td>
	<td class="uvatable-left">$575</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountBefore8Sep575" /></td>
	<td class="uvatable-left">$675</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountAfter8Sep675" /></td>
</tr>
<tr>
	<td class="uvatable-left">3rd Attendee</td>
	<td class="uvatable-left">$525</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountBefore8Sep525" /></td>
	<td class="uvatable-left">$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountAfter8Sep625" /></td>
 
</tr>
<tr>
	<td class="uvatable-left">4th Attendee or more</td>
	<td class="uvatable-left">$500</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountBefore8Sep500" /></td>
	<td class="uvatable-left">$600</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountAfter8Sep600" /></td>
 
</tr>
</table>
 
<p><em>Ask about larger group discounts.</em></p>
 
 
<h2>MAIN CONFERENCE + PRE-CONFERENCE</h2>
 
	<table class="uvatable">
<tr>
	<td></td>
	<td><strong>FEES<br />(Before 9/10/08)</strong></td>
	<td><strong>ENTER AMOUNT</strong></td>
	<td><strong>FEES<br />(After 9/10/08)</strong></td>
	<td><strong>ENTER AMOUNT</strong></td>
 
</tr>
<tr>
	<td class="uvatable-left">1st Attendee</td>
	<td class="uvatable-left">$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountBefore8Sep825" /></td>
	<td class="uvatable-left">$975</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountAfter8Sep975" /></td>
 
</tr>
<tr>
	<td class="uvatable-left">2nd Attendee</td>
	<td class="uvatable-left">$775</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountBefore8Sep775" /></td>
	<td class="uvatable-left">$875</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountAfter8Sep875" /></td>
</tr>
<tr>
	<td class="uvatable-left">3rd Attendee</td>
	<td class="uvatable-left">$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountBefore8Sep725" /></td>
	<td class="uvatable-left">$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountAfter8Sep825" /></td>
 
</tr>
<tr>
	<td class="uvatable-left">4th Attendee or more</td>
	<td class="uvatable-left">$700</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountBefore8Sep700" /></td>
	<td class="uvatable-left">$800</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountAfter8Sep800" /></td>
 
</tr>
</table>
 
 
 
<h2>OPTIONAL</h2>
 
<table class="uvatable">
<tr>
	<td class="uvatable-left">Becker's ASC Review Special Discount Offer</td>
	<td class="uvatable-left">$100 (per year) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="BeckersASCReviewSpecialDiscount" /></td>
</tr>
<tr>
	<td class="uvatable-left">$50 Discount per attendee if paid ASC Association Member
or Becker's ASC Review Subscriber </td>
	<td class="uvatable-left">(- $50) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ASCReviewSubscriberDiscountFifty" /></td>
</tr>
<tr>
	<td></td>
	<td class="uvatable-left"><strong>TOTAL ENCLOSED</strong></td>
	<td><cfinput TYPE="text" SIZE="30" NAME="TotalEnclosed" /></td>
</tr>
</table>
 
 
 
 
<h1>PAYMENT INFORMATION</h1>
 
<p>To remit payment, you may print this form and mail it to Ambulatory Surgery Foundation with a check (see information below). Or, submit your credit card information, below. Credit card information is submitted through a secure connection, certified by SecureTrust.</p>
 
<p class="float-left"><cfinput type="Checkbox" name="CheckEnclosed" /> Enclosed is a check, payable to Ambulatory Surgery Foundation Fall Conference</p> 
 
<p class="float-right">Check # <cfinput TYPE="text" SIZE="30" NAME="CheckNumber" /></p>
 
<div class="clear-both"></div>
 
<p class="float-left"><cfinput type="Checkbox" name="AuthorizeCharge" /> 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>Signature (if printing and mailing):</td>
	<td></td>
	<td>CVV#/3-digit #:</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="CVV" /></td>
</tr>
</table>
 
 
<h1>OTHER WAYS TO REGISTER</h1>
 
 
<h2>PRINT THIS FORM AND MAIL OR FAX AS FOLLOWS:</h2>
 
 
 
<p><strong>Mail:</strong> Make checks payable to Ambulatory Surgery Foundation Fall Conference and mail to:
Ambulatory Surgery Foundation, 1012 Cameron St, Alexandria, VA 22314</p>
 
<p><strong>Fax:</strong> Fax registration form with credit card information to 703.836.2090</p>
 
<p><strong>Call:</strong> Call 703.836.5904 to register by phone</p>
 
<p><strong>Cancellation policy:</strong> Written cancellation requests must be received by September 18, 2008. Refunds are subject to a $100 processing fee.
Refunds will not be issued after this date.</p>
 
<p>Fax registration form with credit card information to 703.836.2090.</p>
 
	
<p class="align-center"><cfinput type="submit" name="submit" value="Submit Registration" /></p>
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
<p>If you have trouble sending the form, please print and fax to 703.836.2090.</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">
 
 
 
 
 
 
 
 
 
 
conference_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>
 
<!--- Insert values into database columns --->
<cfquery datasource="ebwebwork" dbname="ascassociation" name="createRegistration">
	INSERT INTO RegistrationEntries (
		FirstName,
		LastName,
		Degree,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		WebSite,
		RNLicenseNumber,
		MainConference1stAttendeeAmountBefore8Sep625,
		MainConference2ndAttendeeAmountBefore8Sep575,
		MainConference3rdAttendeeAmountBefore8Sep525,
		MainConference4thAttendeeAmountBefore8Sep500,
		MainConference1stAttendeeAmountAfter8Sep725,
		MainConference2ndAttendeeAmountAfter8Sep675,
		MainConference3rdAttendeeAmountAfter8Sep625,
		MainConference4thAttendeeAmountAfter8Sep600,
		MainandPreConference1stAttendeeAmountBefore8Sep825,
		MainandPreConference2ndAttendeeAmountBefore8Sep775,
		MainandPreConference3rdAttendeeAmountBefore8Sep725,
		MainandPreConference4thAttendeeAmountBefore8Sep700,
		MainandPreConference1stAttendeeAmountAfter8Sep975,
		MainandPreConference2ndAttendeeAmountAfter8Sep875,
		MainandPreConference3rdAttendeeAmountAfter8Sep825,
		MainandPreConference4thAttendeeAmountAfter8Sep800,
		BeckersASCReviewSpecialDiscount,
		ASCReviewSubscriberDiscountFifty,
		TotalEnclosed,
		CheckEnclosed,
		CheckNumber,
		AuthorizeCharge,
		CreditCard,
		CreditCardNumber,
		ExpirationDate,
		PrintedCardHolderName,
		CreditCardZIPCode,
		CVV,
		DateCreated)
	VALUES(
		<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="#WebSite#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#RNLicenseNumber#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference1stAttendeeAmountBefore8Sep625#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference2ndAttendeeAmountBefore8Sep575#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference3rdAttendeeAmountBefore8Sep525#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference4thAttendeeAmountBefore8Sep500#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference1stAttendeeAmountAfter8Sep725#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference2ndAttendeeAmountAfter8Sep675#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference3rdAttendeeAmountAfter8Sep625#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainConference4thAttendeeAmountAfter8Sep600#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference1stAttendeeAmountBefore8Sep825#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference2ndAttendeeAmountBefore8Sep775#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference3rdAttendeeAmountBefore8Sep725#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference4thAttendeeAmountBefore8Sep700#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference1stAttendeeAmountAfter8Sep975#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference2ndAttendeeAmountAfter8Sep875#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference3rdAttendeeAmountAfter8Sep825#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#MainandPreConference4thAttendeeAmountAfter8Sep800#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#BeckersASCReviewSpecialDiscount#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#ASCReviewSubscriberDiscountFifty#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#TotalEnclosed#">,
		<cfqueryparam cfsqltype="cf_sql_bit" value="#CheckEnclosed#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CheckNumber#">,
		<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()#">);
	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="chicagoOct2008.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.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="WebSite" value="#FORM.WebSite#">
<input type="hidden" name="RNLicenseNumber" value="#FORM.RNLicenseNumber#">
<input type="hidden" name="MainConference1stAttendeeAmountBefore8Sep625" value="#FORM.MainConference1stAttendeeAmountBefore8Sep625#">
<input type="hidden" name="MainConference2ndAttendeeAmountBefore8Sep575" value="#FORM.MainConference2ndAttendeeAmountBefore8Sep575#">
<input type="hidden" name="MainConference3rdAttendeeAmountBefore8Sep525" value="#FORM.MainConference3rdAttendeeAmountBefore8Sep525#">
<input type="hidden" name="MainConference4thAttendeeAmountBefore8Sep500" value="#FORM.MainConference4thAttendeeAmountBefore8Sep500#">
<input type="hidden" name="MainConference1stAttendeeAmountAfter8Sep725" value="#FORM.MainConference1stAttendeeAmountAfter8Sep725#">
<input type="hidden" name="MainConference2ndAttendeeAmountAfter8Sep675" value="#FORM.MainConference2ndAttendeeAmountAfter8Sep675#">
<input type="hidden" name="MainConference3rdAttendeeAmountAfter8Sep625" value="#FORM.MainConference3rdAttendeeAmountAfter8Sep625#">
<input type="hidden" name="MainConference4thAttendeeAmountAfter8Sep600" value="#FORM.MainConference4thAttendeeAmountAfter8Sep600#">
<input type="hidden" name="MainandPreConference1stAttendeeAmountBefore8Sep825" value="#FORM.MainandPreConference1stAttendeeAmountBefore8Sep825#">
<input type="hidden" name="MainandPreConference2ndAttendeeAmountBefore8Sep775" value="#FORM.MainandPreConference2ndAttendeeAmountBefore8Sep775#">
<input type="hidden" name="MainandPreConference3rdAttendeeAmountBefore8Sep725" value="#FORM.MainandPreConference3rdAttendeeAmountBefore8Sep725#">
<input type="hidden" name="MainandPreConference4thAttendeeAmountBefore8Sep700" value="#FORM.MainandPreConference4thAttendeeAmountBefore8Sep700#">
<input type="hidden" name="MainandPreConference1stAttendeeAmountAfter8Sep975" value="#FORM.MainandPreConference1stAttendeeAmountAfter8Sep975#">
<input type="hidden" name="MainandPreConference2ndAttendeeAmountAfter8Sep875" value="#FORM.MainandPreConference2ndAttendeeAmountAfter8Sep875#">
<input type="hidden" name="MainandPreConference3rdAttendeeAmountAfter8Sep825" value="#FORM.MainandPreConference3rdAttendeeAmountAfter8Sep825#">
<input type="hidden" name="MainandPreConference4thAttendeeAmountAfter8Sep800" value="#FORM.MainandPreConference4thAttendeeAmountAfter8Sep800#">
<input type="hidden" name="BeckersASCReviewSpecialDiscount" value="#FORM.BeckersASCReviewSpecialDiscount#">
<input type="hidden" name="ASCReviewSubscriberDiscountFifty" value="#FORM.ASCReviewSubscriberDiscountFifty#">
<input type="hidden" name="TotalEnclosed" value="#FORM.TotalEnclosed#">
 
 
<cfif isdefined("form.CheckEnclosed")>
<input type="hidden" name="CheckEnclosed" value="#FORM.CheckEnclosed#">
<cfelse>
<input type="hidden" name="CheckEnclosed" value="0">
</cfif>
 
 
<input type="hidden" name="CheckNumber" value="#FORM.CheckNumber#">
 
<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#">
<input type="hidden" name="DateCreated" value="#DateFormat(now(), "mm/dd/yyyy")#">
 
</form>
 </cfoutput>
</body>
</html>
 
Keywords: Form processes, but refuses to displ…
Title
1 nvarchar and text.
2 One column has (lastname, firstnam…
3 SSL
4 what is SSH?
5 UCC vs. Wildcard SSL for IIS6 Web S…
6 Convert nvarchar to datetime?
 
Loading Advertisement...
 
[+][-]08.08.2008 at 12:41PM PDT, ID: 22193017

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, ColdFusion 8, MS SQL Server 2005
Sign Up Now!
Solution Provided By: Yamagami
Participating Experts: 1
Solution Grade: A
 
 
[+][-]08.08.2008 at 12:48PM PDT, ID: 22193084

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

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