SELECT l.label_id, l.label_name, l.label_text, l.sort_order, l.inactive_flag, l.page_id , s.class_name
FROM labels l, style_classes s
WHERE l.page_id = 8
AND l.inactive_flag = 0
AND l.class_id = s.class_id
ORDER BY l.sort_order
SELECT g.info_id, g.store_phone1, g.store_phone2, g.store_street, g.store_city, g.store_state, g.store_zip, g.store_fax,
g.store_website, g.store_email, g.store_directions, g.store_addl_directions, g.store_hours
FROM gen_info g
Contact Us
You can contact us by telephone or email:
Phone: #getInfo.store_phone1#
Fax: #getInfo.store_fax#
Email: #getInfo.store_email#
We're located at:
#getInfo.store_street#
#getInfo.store_city#, #getInfo.store_state# #getInfo.store_zip#
Directions: #getInfo.store_directions#
#ReplaceNoCase(getContactLabels.label_text, chr(13) & chr(10), "
", "all")#
Store Hours:
#getInfo.store_hours#