select max(memberid + 1) as thisId from members insert into members (memberid, first_name, last_name, job_title, company, address, city, state, zip, phone, fax, email, url, username, password) values (#getmax.thisId#, '#form.firstname#', '#form.lastname#', '#form.title#', '#form.company#', '#form.address#', '#form.city#', '#form.state#', '#form.zip#', '#form.phone#', '#form.fax#', '#form.email#', '#form.url#', '#form.username#', '#form.password#') Hello, You have recently registered on HansenGuns.com site! Here is your login information. Username: #form.username# Password: #form.password# If you have any problems with logging in or you did not recently register please contact me immediately. Thank You, HansenGuns.com
#DateFormat("#Now()#", "dddd mmmm dd, yyyy")#  


Member Information *denotes required field.
Username: *   (use this to log in)
Password:*
   Confirm:*
First Name:*
   Last Name:*
Title:
   Company:
Address:
   City:
State:
   Zip:
Email:*
   URL:
Phone:
   Fax:
Remember my Profile: