SELECT tblNews.newsID, tblNews.dateFrom, tblNews.newstitle, tblNews.newsBody, qryImages.directory, qryImages.filename, qryImages.width, qryImages.height, qryImages2.directory AS directory2, qryImages2.filename AS filename2, qryImages2.width AS width2, qryImages2.height AS height2, tblNews.archived, tblContacts.contactName, tblContacts.company, tblContacts.telephone, tblContacts.email, tblContacts2.contactName AS contactName2, tblContacts2.company AS company2, tblContacts2.telephone AS telephone2, tblContacts2.email AS email2, tblNews.contact1ID, tblNews.contact2ID FROM tblNews LEFT JOIN qryImages ON tblNews.imageID = qryImages.imageID LEFT JOIN qryImages AS qryImages2 ON tblNews.image2ID = qryImages2.imageID LEFT JOIN tblContacts ON tblNews.contact1ID = tblContacts.contactID LEFT JOIN tblContacts tblContacts2 ON tblNews.contact2ID = tblContacts2.contactID WHERE tblNews.newsIsActive = 1 AND tblNews.dateFrom < getdate() AND tblNews.dateTo > getdate() AND tblNews.newsID =

News

Sorry, the news item you are trying to access is no longer available.

#newsTitle# - #dateformat(dateFrom, "dd/mm/yyyy")#

#newsBody#

CONTACTS:

Contact 1
Name: #contactName#
Company: #company#
Telephone: #telephone#
Email: #email#
Contact 2
Name: #contactName2#
Company: #company2#
Telephone: #telephone2#
Email: #email2#

« Return to News Archive