<!--- $HeaderUTC: sketchmatchai.cfm, 13, 2006-09-11 21:01:10Z, Raz Yalov$ --->
<!--- $NoKeywords$ --->
<cfinclude template="../incval.cfm">
<cfinclude template="../inchtm.cfm">
<cfscript>
// generate html to show text that is too long with a tool tip and trimmed version
// of the text.
// @param text the text to show
// @param maxLen the maximum length to show w/o a tool tip.
function displayTrimmed(text, maxLen) { result = text;
// if the text is too long, show it inside a span with a TITLE tag that will cause a
// tool tip to show on top of it when hovered.
if (len(text) GT maxLen) { result = "<span title='" & text & "'>" & left(text, maxLen) & "...</span>";
}
else { result = text;
}
return result;
}
</cfscript>
<!--- build the query we should use --->
<!--- since we are going to use a union, we first build the common part of the query and then "join" it twice
with different table names --->
<!--- compute the cor
