<cfif not isdefined("caller.bpostApproved")>

<cfquery name="qgetpage" datasource="#request.site.datasource#">
select sitepages.filename, subsites.subsiteurl
from sitepages, subsites
where sitepages.subsiteid = subsites.id
and sitepages.id = #attributes.pageid#
</cfquery>


<cfmail from="sdrucker@figleaf.com" to="sdrucker@figleaf.com" subject="page changed">
The url that changed was #qgetpage.subsiteurl##qgetpage.filename#
</cfmail>

<cfset caller.bpostApproved = 1>

</cfif>