Sign-up for: #pagetitle# #description# = required, all other fields are voluntary.         Go to secure signup page (optional). Contribution Amount: $#trim(numberformat(cost,'9999.99'))#  X  Enter quantity desired. Payment Information Enter quantity desired

SELECT * FROM customers WHERE email = '#form.email#' SELECT * FROM customers WHERE 0 = 1

That e-mail address is in use Thank you for your interest in our website. The e-mail you entered (#form.email#) is already in use on our system. We verified your e-mail address as (blank)#session.reference_email# and can establish a brand new record using that e-mail address. If the address #form.email# is yours, you can Sign-In to get access to your information and add or change your memberships as you desire. You can also go Back and resubmit the form with your original verified e-mail address.

That e-mail address is in use Thank you for your interest in our website. The e-mail you entered (#form.email#) is already in use on our system. We verified your e-mail address as (blank)#session.reference_email# and can establish a brand new record using that e-mail address. #getuserdata.recordcount# If the address #form.email# is yours, you can Sign-In to get access to your information and add or change your memberships as you desire. You can also go Back and resubmit the form with your original verified e-mail address.

INSERT INTO Customers( FName, LName, Address1, Address2, City, State, Zip, DPhone, EPhone, Email, Username, Password, DateEntered, BlockMail, title, company, position, website, salutation, notes, member_join, member_paid, member_payment, member_due, member_type, member_status, member_discount, ccustom#nn#, classid ) VALUES( '#Form.FName#', '#Form.LName#', '#Form.Address1#', '#Form.Address2#', '#Form.City#', '#Form.State#', '#Form.Zip#', '#Form.dPhone#', '#Form.ephone#', '#Form.Email#', '#Form.Email#', '#gen_pass#', #Now()#, #Form.blockmail#, '#form.title#', '#form.company#', '#form.position#', '#form.website#', '#form.salutation#', '#form.notes#', #Now()#, #now()#, #form.signupfee#, #dateadd('d',form.term,now())#, #form.profid#, 'pending', 'paid', #discount_conv#, '#Evaluate("form.ccustom" & nn)#', #form.classid# ) UPDATE Customers SET FName='#Form.FName#', LName='#Form.LName#', Address1='#Form.Address1#', Address2='#Form.Address2#', City='#Form.City#', State='#Form.State#', Zip='#Form.Zip#', DPhone='#Form.DPhone#', EPhone='#Form.EPhone#', Email='#Form.Email#', Username='#Form.Email#', salutation='#Form.salutation#', notes='#Form.notes#', member_join=#Now()#, member_paid=#now()#, member_payment=#form.signupfee#, member_due=#dateadd('d',form.term,now())#, member_type=#form.profid#, member_status='pending', member_status='paid', member_discount=#discount_conv#, last_mod=#now()#, ccustom#nn# = '#Evaluate("form.ccustom" & nn)#', title='#form.title#' WHERE ID = #getuserdata.ID# SELECT * FROM customers WHERE ID = #record_id# We welcome you on becoming a new member of Fraunces Tavern Museum! We have you recorded at the following one year membership level: #getsignup.profile# We will be mailing you a new member kit this week. If you have any immediate or additional questions before we get back to you, please reply to this email with how we can further help you. Below is some of the information we received from you: Profile: #getsignup.profile# Date/Time: #trim(dateformat(now(),'mm/dd/yyyy'))# #trim(timeformat(now(),'hh:mm:ss t'))# Total: $#trim(numberformat(form.signupfee,'999999.99'))# Card Type: #form.cardtype# Last 4: #Right(Form.ccnum,4)# Exp Date: #ccexp# Contact Information: Company: #form.company# Position: #form.position# Title: #form.title# Salutation: #form.salutation# Name: #form.fname# #form.mi# #form.lname# #form.suffix# Address: #form.address1# #form.address2# #form.city# #form.state# #form.zip# Office Phone: #form.dphone# #form.dphone_ext# Home Phone: #form.ephone# Fax: #form.fax# E-mail: #form.email# Website: #form.website# #Evaluate('getopts.ccustom' & nn & 'name')#: #Evaluate('form.ccustom'& nn)# Notes: #form.notes# Your e-mail address is your sign-in username. We automatically generated a password for you. Your password is: #gen_pass#. You may sign-in and change your password to anything you want. Whenever you make a purchase from our giftshop (at #getad.sitepath#), enter this code: 4december1783 in the "Coupon Code" area before you check out. You will receive 10% discount on your purchase. Your membership is considered "pending" until we receive your payment by check or money order. Please send payment to: #getad.Company# #getad.Address1# #getad.City#, #getad.State# #getad.zip# Include your order id (#orderid#) on your check. If you want to edit your record, click here: #getad.contactpath#userlog.cfm If this link does not work in your e-mail client, you can copy-and-paste it into your browser. Thank you for becoming a Fraunces Tavern Museum Member! A signup or renewal has been processed. (Note: Depending on how the profile is set up, some fields may not contain data): View the member record here (you need to log in first): #getad.contactpath#customer.cfm?action=editcust&cust=#record_id# Profile: #getsignup.profile# Date/Time: #trim(dateformat(now(),'mm/dd/yyyy'))# #trim(timeformat(now(),'hh:mm:ss t'))# Quantity: #form.quantity# @ $#trim(numberformat(getsignup.cost,'999999.99'))# Total: $#trim(numberformat(form.signupfee,'999999.99'))# Card Type: #form.cardtype# Last 4: #Right(Form.ccnum,4)# Exp Date: #ccexp# Contact Information: Company: #form.company# Position: #form.position# Title: #form.title# Salutation: #form.salutation# Name: #form.fname# #form.mi# #form.lname# #form.suffix# Address: #form.address1# #form.address2# #form.city# #form.state# #form.zip# Office Phone: #form.dphone# #form.dphone_ext# Home Phone: #form.ephone# Fax: #form.fax# E-mail: #form.email# Website: #form.website# Custom fields: #Evaluate('getopts.ccustom' & nn & 'name')#: #Evaluate('form.ccustom'& nn)# Notes: #form.notes#

Thank You You have signed up for #getsignup.profile#. A confirmation e-mail has been sent to your e-mail address. You were assigned a password which is included in the e-mail you will receive. You can also go to the sign-in page and click the "Forgot your password?" link to receive an e-mail password reminder. You can print this page for your records, a tax deductible receipt will be mailed to you within two weeks: #getsignup.profile# Your card, last 4 digits #Right(Form.ccnum,4)#, has been approved. Amount charged to your credit card: $#trim(numberformat(form.signupfee,'999999.99'))# Quantity: #trim(numberformat(form.quantity,'9999'))# @ $#trim(numberformat(getsignup.cost,'999999.99'))# Date/Time: #trim(dateformat(now(),'mm/dd/yyyy'))#   #trim(timeformat(now(),'hh:mm:ss t'))# This charge will appear on your statement as #getad.charge_company# Return to homepage View/Edit your contact information and preferences

#url.action#