<%@ page errorPage="/errors/ferret.jsp" %>

<DIV id="formDiv"STYLE="position:absolute; left:20; top:20; width:640; layer-background-color:#FFF8F2; background-color:#FFF8F2;">
<a href="chat.jsp">Post a new Chat </a> <br> <a href="/vc89/default.jsp">Back to Advanced Java</a><br>
<%

String good="1234567890&.-_abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";

String server = "jdbc:mysql://dev-1.javaprofessionals.com:3306/";
com.javaprofessionals.tools.jspForms edb = new com.javaprofessionals.tools.jspForms();
edb.reset("vc89lab","vc89","java",server);
//String strfoo[] = {"Msg ID","Email","Name","Subject","Body"};
//edb.setHeaders(strfoo);
java.util.Vector ht = edb.getNestedFormData("Select ID , Email,Name, Subject, Body from chat");
//System.out.println("Vector "+ht );
for (int i = 0;i<ht.size() ;i++) {
try {

java.util.Hashtable ht2 = (java.util.Hashtable)ht.elementAt(i);
String strEmail =(String)ht2.get("Email");
/*
int start =0;
int iLocate=0;
while ((iLocate = strEmail.indexOf("@",start))!=-1){
int ilower = iLocate-1;
int ihigher = iLocate+1;
while (good.indexOf(strEmail.charAt(ilower))!=-1) {
ilower--;
} // endwhile
while (good.indexOf(strEmail.charAt(ihigher))!=-1) {
ihigher++;
} // endwhile
strEmail = strEmail.substring(ilower+1,ihigher);
// System.out.println(email );
strEmail = "<a href='mailto:"+strEmail+"'>Email </a>";
}
*/

String strBody =(String)ht2.get("Body");
com.javaprofessionals.lang.Macro mc = new com.javaprofessionals.lang.Macro(strBody);
strBody= mc.replace("&Quote123","\"");
mc = new com.javaprofessionals.lang.Macro(strBody);
strBody= mc.replace("\n","<br>");
String strSubject =(String)ht2.get("Subject");
mc = new com.javaprofessionals.lang.Macro(strSubject);
strSubject= mc.replace("&Quote123","\"");%>

<%@ include file="chattemplate.jsp"/>
<br>
<%
} catch (Throwable tException) {
System.out.println("chat #"+i+" "+tException);
} // end try/catch

} // endfor
%>

</div>
</BODY>
</HTML>