BE IN THE KNOW.
Subscribe to our newsletter.
INSERT INTO Contacts (Salutation, FirstName, MiddleInitial, LastName, Address1, Address2, City, State, ZipCode, Country, DateEntered, Email1, TelephoneHome, Cellular, BusinessName, TelephoneWork, Fax, BusinessType, Title, LeadOrigination, LastUserChange , Subscriber, Subscribed) VALUES ('#form.strSalutation#', '#form.strFirstName#', '#form.strMI#', '#form.strLastName#', '#form.strAddress1#', '#form.strAddress2#', '#form.strCity#', '#form.strState#', '#form.strZip#', '#form.strCountry#', #CreateODBCDateTime(now())#, '#form.strEmail#', '#form.strPhone#', '#form.strCellPhone#', '#form.strCompany#', '#form.strBusPhone#', '#form.strfax#', '#form.strBusinessType#', '#form.strTitle#', '#form.strLeadOrigination#', #CreateODBCDateTime(now())# , 1, #CreateODBCDateTime(now())#) SELECT ContactID AS maxID FROM Contacts WHERE LastUserChange IN ( SELECT max(LastUserChange) FROM Contacts) INSERT INTO Brochure (ContactID, BrochureID, Status, DateRequested, Address1, Address2, City, State, ZipCode, Country, DateKey) VALUES (#getid.maxID#, #CurrentBrochure#, 1, #CreateODBCDateTime(now())#, '#form.strAddress1#', '#form.strAddress2#', '#form.strCity#', '#form.strState#', '#form.strZip#', '#form.strCountry#', #CreateODBCDateTime(now())#)
Another brochure will be sent shortly. INSERT INTO Brochure (ContactID, BrochureID, Status, DateRequested, Address1, Address2, City, State, ZipCode, Country, DateKey) VALUES (#form.ContactID#, #CurrentBrochure#, 1, #CreateODBCDateTime(now())#, '#form.Address1#', '#form.Address2#', '#form.City#', '#form.State#', '#form.ZipCode#', '#form.Country#', #CreateODBCDateTime(now())#) UPDATE Contacts SET LastUserChange = #CreateODBCDateTime(now())# WHERE ContactID = #form.ContactID#
SELECT * FROM contacts WHERE Email1 = '#form.strEmail#' or Email2 = '#form.strEmail#' or Email3 = '#form.strEmail#' SELECT * FROM brochure WHERE (ContactID = #checkname.ContactID# and BrochureID = #CurrentBrochure#) #form.strFirstName#, our records indicate that we've already sent you the latest brochure to and #City#, #state#

Do you want another copy of the same brochure?

 
    
    
UPDATE Contacts SET Salutation = '#form.strSalutation#', FirstName = '#form.strFirstName#', MiddleInitial = '#form.strMI#', LastName = '#form.strLastName#', Address1 = '#form.strAddress1#', Address2 = '#form.strAddress2#', City = '#form.strCity#', State = '#form.strState#', ZipCode = '#form.strZip#', Country = '#form.strCountry#', LastUserChange = #CreateODBCDateTime(now())#, Email1 = '#form.strEmail#', TelephoneHome = '#form.strPhone#', Cellular = '#form.strCellPhone#', BusinessName = '#form.strCompany#', TelephoneWork = '#form.strBusPhone#', Fax = '#form.strfax#', BusinessType = '#form.strBusinessType#', Title = '#form.strTitle#' , Subscriber = 1, Subscribed = #CreateODBCDateTime(now())# WHERE ContactID = #checkname.ContactID# INSERT INTO Brochure (ContactID, BrochureID, Status, DateRequested, Address1, Address2, City, State, ZipCode, Country, DateKey) VALUES (#checkname.ContactID#, #CurrentBrochure#, 1, #CreateODBCDateTime(now())#, '#form.strAddress1#', '#form.strAddress2#', '#form.strCity#', '#form.strState#', '#form.strZip#', '#form.strCountry#', #CreateODBCDateTime(now())#) A brochure will be sent to you shortly.
INSERT INTO Contacts (Salutation, FirstName, MiddleInitial, LastName, Address1, Address2, City, State, ZipCode, Country, DateEntered, Email1, TelephoneHome, Cellular, BusinessName, TelephoneWork, Fax, BusinessType, Title, LeadOrigination, LastUserChange , Subscriber, Subscribed) VALUES ('#form.strSalutation#', '#form.strFirstName#', '#form.strMI#', '#form.strLastName#', '#form.strAddress1#', '#form.strAddress2#', '#form.strCity#', '#form.strState#', '#form.strZip#', '#form.strCountry#', #CreateODBCDateTime(now())#, '#form.strEmail#', '#form.strPhone#', '#form.strCellPhone#', '#form.strCompany#', '#form.strBusPhone#', '#form.strfax#', '#form.strBusinessType#', '#form.strTitle#', '#form.strLeadOrigination#', #CreateODBCDateTime(now())# , 1, #CreateODBCDateTime(now())#) SELECT ContactID AS maxID FROM Contacts WHERE LastUserChange IN ( SELECT max(LastUserChange) FROM Contacts) INSERT INTO Brochure (ContactID, BrochureID, Status, DateRequested, Address1, Address2, City, State, ZipCode, Country, DateKey) VALUES (#getid.maxID#, #CurrentBrochure#, 1, #CreateODBCDateTime(now())#, '#form.strAddress1#', '#form.strAddress2#', '#form.strCity#', '#form.strState#', '#form.strZip#', '#form.strCountry#', #CreateODBCDateTime(now())#)
* DESIGNATES A REQUIRED FIELD

If the address above is of a business, please fill in the following:
*Salutation:
*First Name:
M.I.: Company Name:
*Last Name: Business Phone:
*Address: Fax:
P.O. Box: Business:
*City: Title:
*State/Province:
*Postal Code: Would you like to subscribe to the Wild West Motor Company Newsletter?
*Country:
*E-mail Address: Yes   No
Home Phone:
Cell Phone:
    
- [ Home ] - [ Motorcycles ] - [ Gear ] - [ Company ] - [ News+Events ] - [ Contact ] - [ Dealers ] -
© Copyright 2005 Fifty][One Progressive Design Development