CF_eConstruct ALERT!
Message: Value invalid for attribute, #param#.
Possible Values are: Yes No
Consult your documentation for help.

CF_eConstruct ALERT!
Message: File eConstruct_appGlobals.cfm is missing. Process aborted.
Consult your documentation for help.

SELECT * FROM MEMBERS WHERE (USERID = '#FORM.Username#' AND PASSWORD= '#FORM.Password#') or (NICKNAME = '#FORM.Username#' AND PASSWORD= '#FORM.Password#') AND STATUS = 1 SELECT * FROM MEMBERS WHERE Userid = 0 insert into Members(memberid, signupDate, cfid, nickname, userid, password, bill_fname, bill_lname, bill_phone, bill_fax, bill_email, bill_company, bill_address, bill_city, bill_state, bill_zip, bill_country, shippingSameAsBilling, emailOffers, HTMLCapableEmail, status, discountType, discountAmount, military_unit) values (#Max_ID#, '#todayDate#', #Client.CFID#, '#ucase(form.nickname)#', '#ucase(randomUsername)#', '#pRandomValue#', '#capfname#', '#caplname#', '#form.Phone#', '#form.Fax#', '#form.Email#', '#capCompany#', '#capAddress#', '#capCity#', '#capState#', '#form.Zip#', '#capCountry#', '#form.ShippingSameAsBilling#', '#form.EmailOffers#', '#form.HTMLCapableEmail#', '#form.status#', '#defaultDiscountType#', #defaultDiscountAmount#, '#military_unit#') SELECT * FROM MEMBERS WHERE (USERID = '#randomUsername#' AND PASSWORD= '#pRandomValue#') or (NICKNAME = '#form.nickname#' AND PASSWORD= '#pRandomValue#') AND STATUS = 1

#title# Operation failed! #msgString# Please try again. #msg# Note: Fields in BOLD are required. Please provide us with the following info. Nickname: First Name: Last Name: Company Name: Military Unit: Telephone: Fax: E-Mail: Are you able to receive HTML formatted E-Mail?: Yes No Yes No Contact Address Address: City: US State (If country is USA): *Required if Country is USA* Province (If country is not USA): *Required if Country is not USA* Zip/Postal Code: *Required if Country is USA* Country: Shipping address is the same? Yes No Yes No Email Offers Get exclusive time and money-saving offers from #companyName#? Yes No Yes No CF_eConstruct ALERT! Message: File includes/members/Signon_failed_msg.cfm is missing. Process aborted. Consult your documentation for help. CF_eConstruct ALERT! Message: File includes/members/Signon_welcome_msg.cfm is missing. Process aborted. Consult your documentation for help. CF_eConstruct ALERT! Message: File includes/members/Signup_newmember_msg.cfm is missing. Process aborted. Consult your documentation for help. CF_eConstruct ALERT! Message: File includes/members/application_logout.cfm is missing. Process aborted. Consult your documentation for help.