%
ds.db.pool p = new ds.db.pool("pb_content");
ds.db.table dictionary = p.newTable("dictionary");
String ID = ds.utils.gv(request, "ID");
String letter = ds.utils.gv(request, "letter");
String[][] dVals = new String[0][0];
String title = "Dental A-Z";
if (!ID.equals(""))
{
dVals = dictionary.findByValues(new String[] {"term", "body"}, "WHERE dict_id=" + ID);
title = "Dental A-Z - " + dVals[0][0];
}
else if (!letter.equals(""))
{
dVals = dictionary.findByValues(new String[] {"dict_id", "term"}, "WHERE INSTR(LCASE(term), '" + letter + "')=1");
title = "Dental A-Z - Letter " + letter.toUpperCase();
}
%>
Doctor Dental - <%= title %>
<%
p.close();
%>