International Dealers
SELECT custID, custName, custCity FROM customer WHERE custState = '#url.zone#' ORDER BY custName
SELECT * FROM customer WHERE custID = #url.custID#
Company Name: #variables.custName# 
Type: #variables.custType# 
Address: #variables.custAddress# 
City: #variables.custCity#  Prov/State: #variables.custState# 
Postal/Zip Code: #variables.custPostal#  Country: #variables.custCountry# 
Phone: #variables.custPhone#  Fax: #variables.custFax# 
Email: #variables.custEmail#  Web Site: #variables.custWeb# 
Notes: #variables.custDesc#