Olympus - Integrated Technologies America

SELECT id,country_name FROM Olympus.countries ORDER BY country_name

		INSERT INTO Olympus.olympus_ita(first_name,last_name,email,phone,fax,company,address1,address2,city,state,postal_code,Country,comments,best_contact,created) VALUES('#form.fname#','#form.lname#','#form.email#','#form.tele#','#form.fax#','#form.company#','#form.add_1#','#form.add_2#','#form.city#','#form.state#','#form.postcode#','#form.country#','#form.comment#','#form.contact#','#time_stamp#') SELECT id,country_name FROM Olympus.countries WHERE id=#form.country# An inquiry has been submitted at from the Olympus-ITA web site: #chr(13)# #trim(form.fname)# #trim(form.lname)# #chr(13)# #trim(form.company)# #chr(13)# #trim(form.add_1)# #chr(13)# #trim(form.add_2)##chr(13)# #trim(form.city)#, #trim(form.state)# #trim(form.postcode)# #chr(13)# #trim(get_country_name.country_name)# #chr(13)##chr(13)# Email: #trim(form.email)# #chr(13)# Tele: #trim(form.tele)# #chr(13)# Fax: #trim(form.fax)##chr(13)# #chr(13)# #chr(13)# #trim(form.comment)# #chr(13)##chr(13)# Prefered method of contact: #trim(form.contact)# #chr(13)# Submitted: #DateFormat(time_stamp, "mmm-dd-yyyy")# at #TimeFormat(time_stamp, "hh:mm TT")#. Thank you for your inquiry and providing your contact information.
	Copyright 2006-2008 Olympus Integrated Technologies America, Inc. Olympus Integrated Technologies America (ITA) is a division of the Global Olympus Group

Please make sure you've filled out all the required fields.
Email addresses require an '@'.
Email addresses require an extension (i.e. .com, .net, .org).
Email addresses require an '.'.

For general communications of all types. We welcome your comments and inquiries.

Contact Information
		• Required fields
	First Name •
	Last Name •
	E-Mail •
	Telephone •
	Fax •
	Company •
	Address •
	Address (2)
	City •
	State/Province •
	Zip/Postal Code •
	Country / Region•
Please type your comments or questions here.
	#TRIM(form.comment)#
Prefered Method of Contact Prefered Method of Contact •
	Email Email Telephone Telephone Fax Fax Mail Mail