//I think the reason this doesnt work as well as the <!-- type of comment
//is that the <! type is defined on the partition scanner where this is
//only here... javascript has the same problem
rules.add(new MultiLineRule("/*", "*/", sqlcomment));
SQLSyntaxDictionary dic = (SQLSyntaxDictionary)DictionaryManager.getDictionary(DictionaryManager.SQLDIC);
//get any SQL specific keywords (select, from, where, et cetra)
Set set = dic.getSQLKeywords();
String allkeys[] = new String[set.size()];
int i=0;
Iterator it = set.iterator();
while(it.hasNext())
{
String keywd = (String)it.next();
allkeys[i++] = keywd;
}
//build the word highlighter
SQLKeywordDetector cfqkd = new SQLKeywordDetector();
PredicateWordRule words = new PredicateWordRule(
cfqkd,
cfquerytext,
allkeys,
sqlkeyword
);
words.setCaseSensitive(false);
//now do the cffunctions so they look pretty too :)
set = dic.getFunctions();
it = set.iterator();
while(it.hasNext())
{
String fun = (String)it.next();
words.addWord(fun, cffunction);