Solved

submitting a form, then viewing the information one just submitted

Posted on 2008-06-18
11
198 Views
Last Modified: 2012-08-14
ColdFusion 8, MS SQL Server 2005

Hi. With help from SidFishes I developed a ColdFusion application that uses a web site form to populate a table in a database. That works fine.

My next step is to modify the application so that, after filling out and submitting the form, the viewer sees a page with the information that she or he just submitted. Regarding that task I would like some advice.

<ul><li>The form is contained in a file called chicagoOct2008.cfm. It works fine.</li>
<li>The action of the form is contained in a file called conference_data_insert.cfm. It works fine.</li>
<li>I attach below a modified version of chicagoOct2008.cfm that does NOT work</li></ul>

I would think that, using a CFIF / CFELSE statement, that I could use the same file chicagoOct2008.cfm to achieve my goal. Something like the code I set up below.

Questions:

<ul>
<li>Will this work?</li>
<li>If so, in what Scope should I define my FORM in the cfif isDefined statement below?</li>
</ul>

If someone would evaluate my plan, I'd be very grateful.

Thanks very much.

Eric


<!--- When the user submits the Form, she sees the information that she sent --->
<cfif isDefined("FORM")>
 
   <!--- Display "success" message to user --->
 
 <h2>Thank you. Your information has been sent to the ASC Association.</h2>
 
  <p>If you have questions or concerns, please contact the ASC Association at <a href="mailto:ASC@ascassociation.org">ASC@ascassociation.org</a>.</p>
 
  <p>Here is the information you sent:</p>
  <cfquery name="getRegistrationData" dbtype="query">
  
SELECT Name,Degree,Title,FacilityCompany,Address1,Address2,City,State,Zip,Phone,Fax,Email,WebSite,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
 
FROM RegistrationEntries
 
WHERE RegistrationID=#FORM.RegistrationID#
</cfquery>
 
<cfoutput query="getRegistrationData">
<p><strong>RegistrationID:</strong> #FORM.RegistrationID#</p>
<p><strong>Name:</strong> #FORM.Name#</p>
<p><strong>Degree:</strong> #FORM.Degree#</p>
<p><strong>Title:</strong> #FORM.Title#</p>
<CFIF FacilityCompany IS NOT ""><p><strong>Facility / Company:</strong> #FORM.FacilityCompany#</p></CFIF>
<p><strong>Address Line 1:</strong> #FORM.Address1#</p>
<CFIF Address2 IS NOT ""><p><strong>Address Line 2:</strong> #FORM.Address2#</p></CFIF>
<p><strong>City:</strong> #FORM.City#</p>
<p><strong>State:</strong> #FORM.State#</p>
<p><strong>Zip:</strong> #FORM.Zip#</p>
<p><strong>Phone:</strong> #FORM.Phone#</p>
<CFIF Fax IS NOT ""><p><strong>Fax:</strong> #FORM.Fax#</p></CFIF>
<p><strong>Email:</strong> #FORM.Email#</p>
<CFIF WebSite IS NOT ""><p><strong>Web Site:</strong> #FORM.WebSite#</p></CFIF>
<CFIF MainConference1stAttendeeAmountBefore8Sep625 IS NOT ""><p><strong>Main Conference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainConference1stAttendeeAmountBefore8Sep625#</p></CFIF>
<CFIF MainConference2ndAttendeeAmountBefore8Sep575 IS NOT ""><p><strong>Main Conference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainConference2ndAttendeeAmountBefore8Sep575#</p></CFIF>
<CFIF MainConference3rdAttendeeAmountBefore8Sep525 IS NOT ""><p><strong>Main Conference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainConference3rdAttendeeAmountBefore8Sep525#</p></CFIF>
<CFIF MainConference4thAttendeeAmountBefore8Sep500 IS NOT ""><p><strong>Main Conference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainConference4thAttendeeAmountBefore8Sep500#</p></CFIF>
<CFIF MainConference1stAttendeeAmountAfter8Sep725 IS NOT ""><p><strong>Main Conference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainConference1stAttendeeAmountAfter8Sep725#</p></CFIF>
<CFIF MainConference2ndAttendeeAmountAfter8Sep675 IS NOT ""><p><strong>Main Conference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainConference2ndAttendeeAmountAfter8Sep675#</p></CFIF>
<CFIF MainConference3rdAttendeeAmountAfter8Sep625 IS NOT ""><p><strong>Main Conference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainConference3rdAttendeeAmountAfter8Sep625#</p></CFIF>
<CFIF MainConference4thAttendeeAmountAfter8Sep600 IS NOT ""><p><strong>Main Conference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainConference4thAttendeeAmountAfter8Sep600#</p></CFIF>
<CFIF MainandPreConference1stAttendeeAmountBefore8Sep825 IS NOT ""><p><strong>Mainand PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainandPreConference1stAttendeeAmountBefore8Sep825#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainandPreConference2ndAttendeeAmountBefore8Sep775#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainandPreConference3rdAttendeeAmountBefore8Sep725#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #FORM.MainandPreConference4thAttendeeAmountBefore8Sep700#</p></CFIF>
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><p><strong>Mainand PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainandPreConference1stAttendeeAmountAfter8Sep975#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainandPreConference2ndAttendeeAmountAfter8Sep875#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainandPreConference3rdAttendeeAmountAfter8Sep825#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #FORM.MainandPreConference4thAttendeeAmountAfter8Sep800#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Beckers ASC Review Special Discount:</strong> #FORM.BeckersASCReviewSpecialDiscount#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>ASC Review Subscriber Discount ($50):</strong> #FORM.ASCReviewSubscriberDiscountFifty#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Total Enclosed:</strong> #FORM.TotalEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Enclosed:</strong> #FORM.CheckEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Number:</strong> #FORM.CheckNumber#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Authorize Charge:</strong> #FORM.AuthorizeCharge#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Credit Card:</strong> #FORM.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> #FORM.PrintedCardHolderName#</p></CFIF>
<CFIF CreditCardZIPCode IS NOT ""><p><strong>Credit Card ZIP Code:</strong> #FORM.CreditCardZIPCode#</p></CFIF>
<CFIF CVV IS NOT ""><p><strong>CVV:</strong> #FORM.CVV#</p></CFIF>
<p><strong>Date Submitted:</strong> #FORM.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>REGISTRATION INFORMATION</h1>
 
	<table class="uvatable">
	<tr><td><strong>Name:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Name" /></td></tr>
		<tr><td><strong>Degree: As you wish it to appear on your badge:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Degree" /></td></tr>
		<tr><td><strong>Title:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Title" /></td></tr>
	<tr><td><strong>Facility / Company:</strong></td> 	<td><cfinput TYPE="text" SIZE="30" NAME="FacilityCompany" /></td></tr>
	<tr><td><strong>Address Line 1:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address1" /></td></tr>
		<tr><td><strong>Address Line 2:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address2" /></td></tr>
	<tr><td><strong>City:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="City" /></td></tr>
	<tr><td><strong>State:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="State" /></td></tr>	
	<tr><td><strong>ZIP:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="Zip" /></td></tr>
	<tr><td><strong>Phone:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Phone" /></td></tr>
	<tr><td><strong>Fax:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Fax" /></td></tr>
	<tr><td><strong>Email:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Email" /></td></tr>
		<tr><td><strong>Web Site:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="WebSite" /></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 the meal functions.</p>
 
 
<h2>MAIN CONFERENCE ONLY</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>1st Attendee</td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountBefore8Sep625" /></td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountAfter8Sep725" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$575</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountBefore8Sep575" /></td>
	<td>$675</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountAfter8Sep675" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$525</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountBefore8Sep525" /></td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountAfter8Sep625" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$500</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountBefore8Sep500" /></td>
	<td>$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>1st Attendee</td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountBefore8Sep825" /></td>
	<td>$975</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountAfter8Sep975" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$775</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountBefore8Sep775" /></td>
	<td>$875</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountAfter8Sep875" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountBefore8Sep725" /></td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountAfter8Sep825" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$700</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountBefore8Sep700" /></td>
	<td>$800</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountAfter8Sep800" /></td>
 
</tr>
</table>
 
 
 
<h2>OPTIONAL</h2>
 
<table class="uvatable">
<tr>
	<td>Becker's ASC Review Special Discount Offer</td>
	<td>$100 (per year) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="BeckersASCReviewSpecialDiscount" /></td>
</tr>
<tr>
	<td>50 Discount per attendee if paid ASC Association Member
or Becker's ASC Review Subscriber </td>
	<td>(- 50) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ASCReviewSubscriberDiscountFifty" /></td>
</tr>
<tr>
	<td></td>
	<td><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 ASC Association 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 ASC Association 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 ASC Association to charge my:</p>
 
<p class="float-right">
<select name="CreditCard">
<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>TO REGISTER</h1>
 
 
<h2>COMPLETE REGISTRATION FORM AND MAIL OR FAX AS FOLLOWS:</h2>
 
<p><strong>Mail:</strong> Make checks payable to ASC Association Fall Conference and mail to:
ASC Association, 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>Web site:</strong> <a href="http://www.BeckersASC.com">www.BeckersASC.com</a></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 made after this date.</p>
 
<p>Fax registration form with credit card information to (703) 836-2090.</p>
	
	
<cfinput type="submit" name="submit" value="Send to ASC Association" />
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
<p>If you have trouble sending the form, please print and fax to 703-549-0976.</p>
 
	
<p>This information will only be used in conjunction with ASC Association business. We will not share your information with any other organizations.</p>
 
 
 
<cfinclude template="/SiteFooter.cfm">

Open in new window

0
Comment
Question by:Eric Bourland
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 4

Expert Comment

by:msfletch
ID: 21824569
A couple thoughts:

It seems like you are trying to reference the submitted values from both the FORM scope and the database. You should do one or the other.

So if you are getting the data from the query "getRegistrationData" and outputting it with CFOUTPUT with the QUERY parameter, then you shouldn't reference the FORM scope in your variables.

If you want to use the FORM scope and save yourself a trip to the database, then you need to add a hidden form to your "conference_data_insert.cfm" page like attached code.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
<html>
<head>
	<title>Success</title>
</head>
 
<body onLoad="document.form.submit();>
 
<form name="form" action="chicagoOct2008.cfm">
    <intput type=hidden name="someName" value="someValue">
    ... repeate for all fields ...
</form>
 
</body>
</html>

Open in new window

0
 
LVL 4

Expert Comment

by:msfletch
ID: 21824823
Also ... I am not sure where you're getting "FORM.RegistrationID" in your query WHERE clause. Is this value being returned from "conference_data_insert.cfm"? If so, then you would need to verify that it actually is in the FORM scope.

For instance, if "conference_data_insert.cfm" is returning to "chicagoOct2008.cfm" with code like this:

<cflocation url="chicagoOct2008.cfm?RegistrationID=#someRegIDVar#">

... then you would simply use "WHERE RegistrationID=#RegistrationID#" OR "WHERE RegistrationID=#URL.RegistrationID#".

If however, you were using a method like the FORM from my first comment, then what you have (WHERE RegistrationID=#FORM.RegistrationID#) would be appropriate, so long as you were returning the value RegistrationID in a hidden form field.

I have attached some code that should work if you are using the <CFLOCATION> tag to return to the "chicagoOct2008.cfm" page after submission:
<!--- When the user submits the Form, she sees the information that she sent --->
<cfif isDefined("FORM")>
 
   <!--- Display "success" message to user --->
 
 <h2>Thank you. Your information has been sent to the ASC Association.</h2>
 
  <p>If you have questions or concerns, please contact the ASC Association at <a href="mailto:ASC@ascassociation.org">ASC@ascassociation.org</a>.</p>
 
  <p>Here is the information you sent:</p>
  <cfquery name="getRegistrationData" dbtype="query">
   SELECT Name,
		Degree,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		WebSite,
		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
	FROM RegistrationEntries
 	WHERE RegistrationID=#RegistrationID#
</cfquery>
 
<cfoutput query="getRegistrationData">
<p><strong>RegistrationID:</strong> #RegistrationID#</p>
<p><strong>Name:</strong> #Name#</p>
<p><strong>Degree:</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 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>Mainand PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountBefore8Sep825#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountBefore8Sep775#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountBefore8Sep725#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountBefore8Sep700#</p></CFIF>
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><p><strong>Mainand PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountAfter8Sep975#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountAfter8Sep875#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountAfter8Sep825#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountAfter8Sep800#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Beckers ASC Review Special Discount:</strong> #BeckersASCReviewSpecialDiscount#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>ASC Review Subscriber Discount ($50):</strong> #ASCReviewSubscriberDiscountFifty#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Total Enclosed:</strong> #TotalEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Enclosed:</strong> #CheckEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Number:</strong> #CheckNumber#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Authorize Charge:</strong> #AuthorizeCharge#</p></CFIF>
<CFIF FacilityCompany 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>REGISTRATION INFORMATION</h1>
 
	<table class="uvatable">
	<tr><td><strong>Name:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Name" /></td></tr>
		<tr><td><strong>Degree: As you wish it to appear on your badge:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Degree" /></td></tr>
		<tr><td><strong>Title:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Title" /></td></tr>
	<tr><td><strong>Facility / Company:</strong></td> 	<td><cfinput TYPE="text" SIZE="30" NAME="FacilityCompany" /></td></tr>
	<tr><td><strong>Address Line 1:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address1" /></td></tr>
		<tr><td><strong>Address Line 2:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address2" /></td></tr>
	<tr><td><strong>City:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="City" /></td></tr>
	<tr><td><strong>State:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="State" /></td></tr>	
	<tr><td><strong>ZIP:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="Zip" /></td></tr>
	<tr><td><strong>Phone:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Phone" /></td></tr>
	<tr><td><strong>Fax:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Fax" /></td></tr>
	<tr><td><strong>Email:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Email" /></td></tr>
		<tr><td><strong>Web Site:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="WebSite" /></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 the meal functions.</p>
 
 
<h2>MAIN CONFERENCE ONLY</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>1st Attendee</td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountBefore8Sep625" /></td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountAfter8Sep725" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$575</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountBefore8Sep575" /></td>
	<td>$675</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountAfter8Sep675" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$525</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountBefore8Sep525" /></td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountAfter8Sep625" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$500</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountBefore8Sep500" /></td>
	<td>$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>1st Attendee</td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountBefore8Sep825" /></td>
	<td>$975</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountAfter8Sep975" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$775</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountBefore8Sep775" /></td>
	<td>$875</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountAfter8Sep875" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountBefore8Sep725" /></td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountAfter8Sep825" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$700</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountBefore8Sep700" /></td>
	<td>$800</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountAfter8Sep800" /></td>
 
</tr>
</table>
 
 
 
<h2>OPTIONAL</h2>
 
<table class="uvatable">
<tr>
	<td>Becker's ASC Review Special Discount Offer</td>
	<td>$100 (per year) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="BeckersASCReviewSpecialDiscount" /></td>
</tr>
<tr>
	<td>50 Discount per attendee if paid ASC Association Member
or Becker's ASC Review Subscriber </td>
	<td>(- 50) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ASCReviewSubscriberDiscountFifty" /></td>
</tr>
<tr>
	<td></td>
	<td><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 ASC Association 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 ASC Association 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 ASC Association to charge my:</p>
 
<p class="float-right">
<select name="CreditCard">
<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>TO REGISTER</h1>
 
 
<h2>COMPLETE REGISTRATION FORM AND MAIL OR FAX AS FOLLOWS:</h2>
 
<p><strong>Mail:</strong> Make checks payable to ASC Association Fall Conference and mail to:
ASC Association, 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>Web site:</strong> <a href="http://www.BeckersASC.com">www.BeckersASC.com</a></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 made after this date.</p>
 
<p>Fax registration form with credit card information to (703) 836-2090.</p>
	
	
<cfinput type="submit" name="submit" value="Send to ASC Association" />
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
<p>If you have trouble sending the form, please print and fax to 703-549-0976.</p>
 
	
<p>This information will only be used in conjunction with ASC Association business. We will not share your information with any other organizations.</p>
 
 
 
<cfinclude template="/SiteFooter.cfm">

Open in new window

0
 
LVL 4

Expert Comment

by:msfletch
ID: 21824925
Finally,

You can't use <cfif isDefined("FORM")> to tell whether or not the form has been submitted because the FORM scope always exists regardless of whether a form has been submitted or not.

For instance, try just adding this code to any page:

<cfdump var="#FORM#">

You will get an empty structure, but not an error. The same goes for the SESSION scope, etc.

So what you should do is check for a variable you know you will be returning. I would suggest something like:

<cfif IsDefined('RegistrationID')>

Since you know you will need that to run the query, and you will not have that if the form has not been submitted.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 4

Expert Comment

by:msfletch
ID: 21824940
So to clarify, the change descibed above would need to be updated in the code I included in my second post. Sorry.
0
 
LVL 3

Author Comment

by:Eric Bourland
ID: 21825036
msfletch,

Thanks very much for these thoughtful replies. I'm going to work on them later, and will get back to you after I make some progress. Hope your day is going well.

Peace.

Eric
0
 
LVL 3

Author Comment

by:Eric Bourland
ID: 21827950
Hi, msfletch,

I've been staring at this for a couple of hours and trying different ideas. Your ideas, above, make a lot of sense in theory, but I am having trouble putting them together correctly in code.

I've been studying the code that you presented above. When I use it, I get an error when I try to view the chicagoOct2008.cfm page:

 Variable REGISTRATIONID is undefined.
 
The error occurred in D:\websites\ascassociation.org\chicagoOct2008.cfm: line 57
Called from D:\websites\ascassociation.org\chicagoOct2008.cfm: line 4
Called from D:\websites\ascassociation.org\chicagoOct2008.cfm: line 1

55 :             DateCreated
56 :       FROM RegistrationEntries
57 :        WHERE RegistrationID=#RegistrationID#
58 : </cfquery>
59 :  

You can see it here:

http://ascassociation.org/chicagoOct2008.cfm

Actually, yes, I would like to use the FORM scope to return the output of the FORM to the browser screen where the user can view what she just sent. I would like to save a trip to the database.

To do so, I'm not sure exactly what to take out of chicagoOct2008.cfm, and what to add to conference_data_insert.cfm.

Sorry for my obtuseness. =) I really appreciate your help. Hope you are having a good evening.

Eric
chicagoOct2008.cfm:
 
<cfinclude template="/SiteHeader.cfm">
 
<!--- When the user submits the Form, she sees the information that she sent --->
<cfif isDefined("FORM")>
 
   <!--- Display "success" message to user --->
 
 <h2>Thank you. Your information has been sent to the ASC Association.</h2>
 
  <p>If you have questions or concerns, please contact the ASC Association at <a href="mailto:ASC@ascassociation.org">ASC@ascassociation.org</a>.</p>
 
  <p>Here is the information you sent:</p>
  <cfquery name="getRegistrationData" dbtype="query">
   SELECT RegistrationID, Name,
		Degree,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		WebSite,
		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
	FROM RegistrationEntries
 	WHERE RegistrationID=#RegistrationID#
</cfquery>
 
<cfoutput query="getRegistrationData">
<p><strong>RegistrationID:</strong> #RegistrationID#</p>
<p><strong>Name:</strong> #Name#</p>
<p><strong>Degree:</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 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>Mainand PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountBefore8Sep825#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountBefore8Sep775#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountBefore8Sep725#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountBefore8Sep700#</p></CFIF>
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><p><strong>Mainand PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountAfter8Sep975#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountAfter8Sep875#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountAfter8Sep825#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountAfter8Sep800#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Beckers ASC Review Special Discount:</strong> #BeckersASCReviewSpecialDiscount#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>ASC Review Subscriber Discount ($50):</strong> #ASCReviewSubscriberDiscountFifty#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Total Enclosed:</strong> #TotalEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Enclosed:</strong> #CheckEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Number:</strong> #CheckNumber#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Authorize Charge:</strong> #AuthorizeCharge#</p></CFIF>
<CFIF FacilityCompany 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>REGISTRATION INFORMATION</h1>
 
	<table class="uvatable">
	<tr><td><strong>Name:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Name" /></td></tr>
		<tr><td><strong>Degree: As you wish it to appear on your badge:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Degree" /></td></tr>
		<tr><td><strong>Title:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Title" /></td></tr>
	<tr><td><strong>Facility / Company:</strong></td> 	<td><cfinput TYPE="text" SIZE="30" NAME="FacilityCompany" /></td></tr>
	<tr><td><strong>Address Line 1:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address1" /></td></tr>
		<tr><td><strong>Address Line 2:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address2" /></td></tr>
	<tr><td><strong>City:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="City" /></td></tr>
	<tr><td><strong>State:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="State" /></td></tr>	
	<tr><td><strong>ZIP:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="Zip" /></td></tr>
	<tr><td><strong>Phone:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Phone" /></td></tr>
	<tr><td><strong>Fax:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Fax" /></td></tr>
	<tr><td><strong>Email:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Email" /></td></tr>
		<tr><td><strong>Web Site:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="WebSite" /></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 the meal functions.</p>
 
 
<h2>MAIN CONFERENCE ONLY</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>1st Attendee</td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountBefore8Sep625" /></td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountAfter8Sep725" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$575</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountBefore8Sep575" /></td>
	<td>$675</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountAfter8Sep675" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$525</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountBefore8Sep525" /></td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountAfter8Sep625" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$500</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountBefore8Sep500" /></td>
	<td>$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>1st Attendee</td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountBefore8Sep825" /></td>
	<td>$975</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountAfter8Sep975" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$775</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountBefore8Sep775" /></td>
	<td>$875</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountAfter8Sep875" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountBefore8Sep725" /></td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountAfter8Sep825" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$700</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountBefore8Sep700" /></td>
	<td>$800</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountAfter8Sep800" /></td>
 
</tr>
</table>
 
 
 
<h2>OPTIONAL</h2>
 
<table class="uvatable">
<tr>
	<td>Becker's ASC Review Special Discount Offer</td>
	<td>$100 (per year) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="BeckersASCReviewSpecialDiscount" /></td>
</tr>
<tr>
	<td>50 Discount per attendee if paid ASC Association Member
or Becker's ASC Review Subscriber </td>
	<td>(- 50) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ASCReviewSubscriberDiscountFifty" /></td>
</tr>
<tr>
	<td></td>
	<td><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 ASC Association 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 ASC Association 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 ASC Association to charge my:</p>
 
<p class="float-right">
<select name="CreditCard">
<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>TO REGISTER</h1>
 
 
<h2>COMPLETE REGISTRATION FORM AND MAIL OR FAX AS FOLLOWS:</h2>
 
<p><strong>Mail:</strong> Make checks payable to ASC Association Fall Conference and mail to:
ASC Association, 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>Web site:</strong> <a href="http://www.BeckersASC.com">www.BeckersASC.com</a></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 made after this date.</p>
 
<p>Fax registration form with credit card information to (703) 836-2090.</p>
	
	
<cfinput type="submit" name="submit" value="Send to ASC Association" />
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
<p>If you have trouble sending the form, please print and fax to 703-549-0976.</p>
 
	
<p>This information will only be used in conjunction with ASC Association business. We will not share your information with any other organizations.</p>
 
<cfinclude template="/SiteFooter.cfm">
 
 
 
 
conference_data_insert.cfm:
 
 
<cfif isDefined('form.checkenclosed')><!--- box has been checked and is present in post data --->
<cfset vCheckEnclosed =1>
<cfelse>
<cfset  vCheckEnclosed = 0><!--- not checked and not present --->
</cfif>
 
 
<cfif isDefined('form.checkenclosed')><!--- box has been checked and is present in post data --->
<cfset vAuthorizeCharge = 1>
<cfelse>
<cfset vAuthorizeCharge = 0><!--- not checked and not present --->
</cfif>
 
  <!--- Insert values into database columns --->
	
	<cfquery datasource="ebwebwork" dbname="ascassociation" name="createRegistration">
		  
INSERT INTO RegistrationEntries (Name,
Degree,
Title,
FacilityCompany,
Address1,
Address2,
City,
State,
Zip,
Phone,
Fax,
Email,
WebSite,
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="#Name#">,
                <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="#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="#vCheckEnclosed#">,
                <cfqueryparam cfsqltype="cf_sql_varchar" value="#CheckNumber#">,
                <cfqueryparam cfsqltype="cf_sql_bit" value="#vAuthorizeCharge#">,
                <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()#">
        )
</cfquery>
		  
 
 
<!--- When done go back to ChicagoOct2008.cfm --->
<cflocation url="ChicagoOct2008.cfm">

Open in new window

0
 
LVL 4

Accepted Solution

by:
msfletch earned 500 total points
ID: 21828550
Eric,

Try the following attached code.
<!--- ================================================ --->
chicagoOct2008.cfm:
<!--- ================================================ --->
 
<cfinclude template="/SiteHeader.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. Your information has been sent to the ASC Association.</h2>
 
  <p>If you have questions or concerns, please contact the ASC Association at <a href="mailto:ASC@ascassociation.org">ASC@ascassociation.org</a>.</p>
 
  <p>Here is the information you sent:</p>
  
  <!--- set default values --->
  <cfparam name="RegistrationID" default="">
  <cfparam name="Name" 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="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="CheckEnclosed" default="">
  <cfparam name="CheckNumber" default="">
  <cfparam name="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>
<p><strong>Name:</strong> #Name#</p>
<p><strong>Degree:</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 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>Mainand PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountBefore8Sep825#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountBefore8Sep775#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountBefore8Sep725#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountBefore8Sep700#</p></CFIF>
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><p><strong>Mainand PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountAfter8Sep975#</p></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><p><strong>Mainand PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountAfter8Sep875#</p></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><p><strong>Mainand PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountAfter8Sep825#</p></CFIF>
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><p><strong>Mainand PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountAfter8Sep800#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Beckers ASC Review Special Discount:</strong> #BeckersASCReviewSpecialDiscount#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>ASC Review Subscriber Discount ($50):</strong> #ASCReviewSubscriberDiscountFifty#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Total Enclosed:</strong> #TotalEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Enclosed:</strong> #CheckEnclosed#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Check Number:</strong> #CheckNumber#</p></CFIF>
<CFIF FacilityCompany IS NOT ""><p><strong>Authorize Charge:</strong> #AuthorizeCharge#</p></CFIF>
<CFIF FacilityCompany 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>REGISTRATION INFORMATION</h1>
 
	<table class="uvatable">
	<tr><td><strong>Name:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Name" /></td></tr>
		<tr><td><strong>Degree: As you wish it to appear on your badge:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Degree" /></td></tr>
		<tr><td><strong>Title:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Title" /></td></tr>
	<tr><td><strong>Facility / Company:</strong></td> 	<td><cfinput TYPE="text" SIZE="30" NAME="FacilityCompany" /></td></tr>
	<tr><td><strong>Address Line 1:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address1" /></td></tr>
		<tr><td><strong>Address Line 2:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="Address2" /></td></tr>
	<tr><td><strong>City:</strong></td> 		<td><cfinput TYPE="text" SIZE="30" NAME="City" /></td></tr>
	<tr><td><strong>State:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="State" /></td></tr>	
	<tr><td><strong>ZIP:</strong></td> 		<td><cfinput TYPE="text" SIZE="5" NAME="Zip" /></td></tr>
	<tr><td><strong>Phone:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Phone" /></td></tr>
	<tr><td><strong>Fax:</strong></td>		<td><cfinput TYPE="text" SIZE="20" NAME="Fax" /></td></tr>
	<tr><td><strong>Email:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="Email" /></td></tr>
		<tr><td><strong>Web Site:</strong></td>		<td><cfinput TYPE="text" SIZE="30" NAME="WebSite" /></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 the meal functions.</p>
 
 
<h2>MAIN CONFERENCE ONLY</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>1st Attendee</td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountBefore8Sep625" /></td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference1stAttendeeAmountAfter8Sep725" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$575</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountBefore8Sep575" /></td>
	<td>$675</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference2ndAttendeeAmountAfter8Sep675" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$525</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountBefore8Sep525" /></td>
	<td>$625</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference3rdAttendeeAmountAfter8Sep625" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$500</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainConference4thAttendeeAmountBefore8Sep500" /></td>
	<td>$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>1st Attendee</td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountBefore8Sep825" /></td>
	<td>$975</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference1stAttendeeAmountAfter8Sep975" /></td>
 
</tr>
<tr>
	<td>2nd Attendee</td>
	<td>$775</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountBefore8Sep775" /></td>
	<td>$875</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference2ndAttendeeAmountAfter8Sep875" /></td>
</tr>
<tr>
	<td>3rd Attendee</td>
	<td>$725</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountBefore8Sep725" /></td>
	<td>$825</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference3rdAttendeeAmountAfter8Sep825" /></td>
 
</tr>
<tr>
	<td>4th Attendee or more</td>
	<td>$700</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountBefore8Sep700" /></td>
	<td>$800</td>
	<td><cfinput TYPE="text" SIZE="30" NAME="MainandPreConference4thAttendeeAmountAfter8Sep800" /></td>
 
</tr>
</table>
 
 
 
<h2>OPTIONAL</h2>
 
<table class="uvatable">
<tr>
	<td>Becker's ASC Review Special Discount Offer</td>
	<td>$100 (per year) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="BeckersASCReviewSpecialDiscount" /></td>
</tr>
<tr>
	<td>50 Discount per attendee if paid ASC Association Member
or Becker's ASC Review Subscriber </td>
	<td>(- 50) </td>
	<td><cfinput TYPE="text" SIZE="30" NAME="ASCReviewSubscriberDiscountFifty" /></td>
</tr>
<tr>
	<td></td>
	<td><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 ASC Association 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 ASC Association 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 ASC Association to charge my:</p>
 
<p class="float-right">
<select name="CreditCard">
<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>TO REGISTER</h1>
 
 
<h2>COMPLETE REGISTRATION FORM AND MAIL OR FAX AS FOLLOWS:</h2>
 
<p><strong>Mail:</strong> Make checks payable to ASC Association Fall Conference and mail to:
ASC Association, 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>Web site:</strong> <a href="http://www.BeckersASC.com">www.BeckersASC.com</a></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 made after this date.</p>
 
<p>Fax registration form with credit card information to (703) 836-2090.</p>
	
	
<cfinput type="submit" name="submit" value="Send to ASC Association" />
 
 
</cfform>
 
<!--- close CFIF --->
</cfif> 
 
<p>If you have trouble sending the form, please print and fax to 703-549-0976.</p>
 
	
<p>This information will only be used in conjunction with ASC Association business. We will not share your information with any other organizations.</p>
 
<cfinclude template="/SiteFooter.cfm">
 
 
 
<!--- ================================================ ---> 
conference_data_insert.cfm:
<!--- ================================================ --->
 
<cfif isDefined('form.checkenclosed')><!--- box has been checked and is present in post data --->
<cfset vCheckEnclosed =1>
<cfelse>
<cfset  vCheckEnclosed = 0><!--- not checked and not present --->
</cfif>
 
 
<cfif isDefined('form.checkenclosed')><!--- box has been checked and is present in post data --->
<cfset vAuthorizeCharge = 1>
<cfelse>
<cfset vAuthorizeCharge = 0><!--- not checked and not present --->
</cfif>
 
<!--- Insert values into database columns --->
<cfquery datasource="ebwebwork" dbname="ascassociation" name="createRegistration">
	INSERT INTO RegistrationEntries (Name,
		Degree,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		WebSite,
		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="#Name#">,
		<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="#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="#vCheckEnclosed#">,
		<cfqueryparam cfsqltype="cf_sql_varchar" value="#CheckNumber#">,
		<cfqueryparam cfsqltype="cf_sql_bit" value="#vAuthorizeCharge#">,
		<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>Info Updated</title>
</head>
 
<body onLoad="document.form.submit();">
 
<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.Name#">
<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="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#">
<input type="hidden" name="CheckEnclosed" value="#FORM.CheckEnclosed#">
<input type="hidden" name="CheckNumber" value="#FORM.CheckNumber#">
<input type="hidden" name="AuthorizeCharge" value="#FORM.AuthorizeCharge#">
<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="#FORM.DateCreated#">
 
</form>
 
</body>
</html>

Open in new window

0
 
LVL 3

Author Comment

by:Eric Bourland
ID: 21828654
Hi, msfletch,

I reviewed this code and now I see exactly what you meant. That makes sense. Very cool!

I needed to add <cfoutput></cfoutput> around the FORM in conference_data_insert.cfm.

This is gorgeous.

I see you added cfparam default values in chicagoOct2008.cfm. I did not mean to make you do all of that work. =)

One last small thing. The Date Submitted is not showing up in the results page.

I get output that looks like this:

Date Submitted: <!--

I'll keep looking at it to see if I can see the problem. Do you have any ideas regarding this?

I really appreciate your time. If you're near the Chicago area please let me get dinner or beers for you or something.

Eric
0
 
LVL 4

Expert Comment

by:msfletch
ID: 21832897
Thanks for all the kind words Eric. I was meaning to add those <cfoutput> tags but it was kind of late and I spaced it. Good catch.

I didn't see that the date was not being pased by the form but entered straight into the DB using the "now()" function. So in the hidden form field that returns to the "chicagoOct2008.cfm" page, change it from:

<input type="hidden" name="DateCreated" value="#FORM.DateCreated#">

... to:

<input type="hidden" name="DateCreated" value="#DateFormat(now(), "mm/dd/yyyy")#">


0
 
LVL 3

Author Closing Comment

by:Eric Bourland
ID: 31468658
msfletch FTW. Thanks very much for this clear explanation. I understand the methods that you used. I like it when things make sense. =)

Have a great weekend. Peace.

Eric
0
 
LVL 4

Expert Comment

by:msfletch
ID: 21833125
Thanks Eric. Have a great weekend and happy coding.
0

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question