allowWordWrap = false;
celldata = "";
DataSheetIDField = "Subsite";
cellValue = "";
newCellValue = "";
qSubsite = QueryNew("temp");
// Get SubsiteID
//variables.SubsiteID = TRIM(request.DataSheetRow[DataSheetIDField][Request.DataSheetRow.CurrentRow]);
if ( LEN(TRIM(request.datasheet.currentColumnValue)) )
cellValue = request.datasheet.currentColumnValue;
if ( LEN(TRIM(cellValue)) )
qSubsite = Application.ptCalendar2.CSData.getSubsiteQueryByID(cellValue);
if ( qSubsite.RecordCount )
newCellValue = qSubsite.SubSiteURL;
else
newCellValue = cellValue; // "No Query results";
#newCellValue#