formEncoding = getEncoding("FORM");
urlEncoding = getEncoding("URL");
setEncoding("FORM", formEncoding);
setEncoding("URL", urlEncoding);
SELECT *, (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'SqlQuery'
SELECT *, (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'StoredProcedure'
SELECT *, (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'Trace'
SELECT *
FROM qEvents
WHERE type = 'Exception'
SELECT (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'ExecutionTime'
//UDF - Handle Kojak output of complex data types.
function CFDebugCheckType(variable)
{
var ret = "";
if(IsSimpleValue(variable))
{
ret = variable;
}
else
{
if (IsStruct(variable))
{
ret = ("Struct (" & StructCount(variable) & ")");
}
else if(IsArray(variable))
{
ret = ("Array (" & ArrayLen(variable) & ")");
}
else if(IsQuery(variable))
{
ret = ("Query (" & variable.RecordCount & ")");
}
else
{
ret = ("Complex type");
}
}
return ret;
}
// UDF - tree writing
function dwDrawNode(nTree, indent, id) {
var templateOuput = "";
var thisTemplate = nTree[id].template;
var uri = thisTemplate;
var startToken = "CFC[ ";
var endToken = " | ";
var startTokenIndex = FindNoCase(startToken, thisTemplate, 1);
if( startTokenIndex NEQ 0 ) {
endTokenIndex = FindNoCase(endToken, thisTemplate, startTokenIndex);
uri = Trim(Mid(thisTemplate,Len(startToken),endTokenIndex-Len(startToken)));
}
templateOuput = "#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#";
writeOutput(templateOuput);
return "";
}
function dwDrawTree(tree, indent, id) {
var alength = 1;
var i = 1;
var templateOuput = "";
var thisTemplate = Tree[id].template;
var uri = thisTemplate;
var startToken = "CFC[ ";
var endToken = " | ";
var startTokenIndex = FindNoCase(startToken, thisTemplate, 1);
if( startTokenIndex NEQ 0 ) {
endTokenIndex = FindNoCase(endToken, thisTemplate, startTokenIndex);
uri = Trim(Mid(thisTemplate,Len(startToken),endTokenIndex-Len(startToken)));
}
templateOuput = "#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#" &
"#Chr(13)#";
writeOutput(templateOuput);
if( isArray( tree[id].children ) and arrayLen( tree[id].children ) ) {
alength = arrayLen( tree[id].children );
for( i = 1; i lte alength; i = i + 1 ) {
if( isArray(tree[id].children[i].children) and arrayLen( tree[id].children[i].children ) gt 0 ) {
dwDrawTree(tree, indent + 1, tree[id].children[i].templateid);
} else {
dwDrawNode(tree, indent + 1, tree[id].children[i].templateid);
}
}
} else {
// single template, no includes?
//dwDrawNode(tree, indent + 1, tree[id].template);
}
return "";
}
' & Chr(13) & Chr(10)>
' & Chr(13) & Chr(10)>