Solved

submitting a form, then viewing the information one just submitted

Posted on 2008-06-18
11
191 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
  • 7
  • 4
11 Comments
 
LVL 4

Expert Comment

by:msfletch
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 4

Expert Comment

by:msfletch
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 3

Author Comment

by:Eric Bourland
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks Eric. Have a great weekend and happy coding.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now