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?
