SELECT max(added) AS added FROM mapdata select stockcode, areacode, mapdata.title, retail, descriptive, cartographer, cartographerlocation, metric, medium, colour, year, added, image, filename from mapdata, mapimage, image where mapdata.publish='yes' and mapdata.deleted='no' and mapdata.stockcode=mapimage.map and image.id=mapimage.image order by added desc limit #numberoffeeditems# select id as stockcode, title, content as descriptive, imagefile as filename, lastchanged as added from globes order by lastchanged desc limit #numberoffeeditems# select stockcode, bookdata.title, descriptive, filename, image, added from bookdata, bookimage, image where bookdata.stockcode=bookimage.book and image.id=bookimage.image order by added desc limit #numberoffeeditems# tz=gettimezoneinfo(); tz=iif(tz.isDSTon, de('+0100'), de('+0000')); now=now(); now="#dateformat(now, 'ddd, dd mmm yyyy')# #timeformat(now, 'HH:mm:ss')# #tz#"; 240 http://www.jpmaps.co.uk/ http://www.jpmaps.co.uk/resources/jpmaps.icon.png http://www.jpmaps.co.uk/ Jonathan Potter Limited - Antique Maps, Charts, Plans, Atlases, Globes and Cartographic Reference Books en copyright Jonathan Potter Limited #now# itemtitle=server.entity(lcase(rereplace(title, "<[^>]*>", "", "ALL"))); summary=rereplace(descriptive, "<[^>]*>", "", "ALL"); summary=server.entity(replacenocase(summary, " ", " ", "ALL")); content=rereplacenocase(descriptive, "]*>", "", "ALL"); content=server.entity(replacenocase(content, " ", " ", "ALL")); date=dateformat(added, "ddd, dd mmm yyyy"); time=timeformat(added, "HH:mm:ss"); pubDate=date & " " & time & " " & tz; link="http://www.jpmaps.co.uk/map/id.#stockcode#"; MAP - #summary# #link# #pubDate# itemtitle=server.entity(lcase(rereplace(title, "<[^>]*>", "", "ALL"))); summary=rereplace(descriptive, "<[^>]*>", "", "ALL"); summary=server.entity(replacenocase(summary, " ", " ", "ALL")); content=rereplacenocase(descriptive, "]*>", "", "ALL"); content=server.entity(replacenocase(content, " ", " ", "ALL")); date=dateformat(added, "ddd, dd mmm yyyy"); time=timeformat(added, "HH:mm:ss"); pubDate=date & " " & time & " " & tz; link="http://www.jpmaps.co.uk/globes"; GLOBE - #summary# http://www.jpmaps.co.uk/globes #pubDate# itemtitle=server.entity(lcase(rereplace(title, "<[^>]*>", "", "ALL"))); summary=rereplace(descriptive, "<[^>]*>", "", "ALL"); summary=server.entity(replacenocase(summary, " ", " ", "ALL")); content=rereplacenocase(descriptive, "]*>", "", "ALL"); content=server.entity(replacenocase(content, " ", " ", "ALL")); date=dateformat(added, "ddd, dd mmm yyyy"); time=timeformat(added, "HH:mm:ss"); pubDate=date & " " & time & " " & tz; link="http://www.jpmaps.co.uk/book/id.#stockcode#"; BOOK - #summary# #link# #pubDate# #thexml#