<% String title = ds.utils.gv(request, "title"); if (title.equals("")) title = "Introduction"; String view_id = ds.utils.gv(request, "view_id"); ds.db.pool p = new ds.db.pool("pb_content"); ds.db.table careers = p.newTable("careers"); String[][] careersContent = new String[0][0]; if (view_id.equals("")) careersContent = careers.findByValues(new String[] {"title", "body"}, "WHERE title LIKE '" + ds.utils.ca(title) + "'"); else careersContent = careers.findByValues(new String[] {"title", "body"}, "WHERE career_id ='" + view_id + "'"); %> Doctor Dental - Harnessing the Internet For Your Dental Health

Careers in Dentistry<% if (careersContent.length > 0) { %> - <%= careersContent[0][0] %><% } %>

<% if (careersContent.length > 0) { %> <%= ds.utils.replace(careersContent[0][1], "

", "

") %> <% } %>

<% String[][] menuVals = careers.findByValues(new String[] {"title"}, "WHERE class = 'intro' ORDER BY class"); %> <% for (int i = 0; i < menuVals.length; i++) { %> <% } %> <% menuVals = careers.findByValues(new String[] {"class", "career_id"}, "WHERE suborder = '0' AND class != 'intro' ORDER BY class"); %> <% for (int i = 0; i < menuVals.length; i++) { %> <% } %> <% String list = ds.utils.gv(request, "list"); if (!list.equals("")) { menuVals = careers.findByValues(new String[] {"class", "career_id", "subsection"}, "WHERE class = '" + ds.utils.ca(list) + "' AND subsection != 'none' ORDER BY suborder"); %> <% for (int i = 0; i < menuVals.length; i++) { %> <% } %> <% } %>

Topics

<%= menuVals[i][0] %>

Career Factfiles

<%= menuVals[i][0] %>

Factfile Topics

<%= menuVals[i][2] %>