<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Service tickets: PERSIPHONE CO.</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic htmlKona 3.0.0">
</HEAD>
<BODY bgcolor="#ffdf67" link="#fd2504" vlink="#487d70">
<FONT FACE=Helvetica><P><CENTER><IMG BORDER=0 USEMAP="#MyMap" SRC="../classdocs/images/tourtop.jpg" ISMAP></CENTER>

<MAP NAME="MyMap">
<AREA coords="126, 54, 224, 77"  href="customer.html" shape="RECT">
<AREA coords="254, 13, 316, 56"  href="jdbc.html" shape="RECT">
<AREA coords="323, 41, 391, 68"  href="cluster.html" shape="RECT">
<AREA coords="257, 74, 325, 111" href="rmi.html" shape="RECT">
<AREA coords="359, 93, 426, 122" href="events1.html" shape="RECT">
<AREA coords="434, 92, 477, 130" href="ejb1.html" shape="RECT">
<AREA coords="392, 9,  470, 60"  href="console.html" shape="RECT">
<AREA coords="480, 29, 554, 107" href="final.html" shape="RECT">
<AREA coords="555, 50, 670, 77"  href="open.html" shape="RECT">
<AREA coords="555, 89, 597, 121" href="customer.html" shape="RECT">
<AREA coords="598, 89, 629, 121" href="tour.html" shape="RECT">
<AREA coords="630, 89, 670, 121" href="problem.html" shape="RECT">
</MAP>

<H2><FONT COLOR="#750088">Service tickets: PERSIPHONE CO.</FONT></H2>
<P><A href="cust2svccustid=10755&status=3"><B>Resolved tickets for PERSIPHONE CO.</B></A><P><A href="cust2svccustid=10755&status=2"><B>Outstanding tickets for PERSIPHONE CO.</B></A><P>The essential code to do this operation relies on  parameters (for example, <i>custid</i> and <i>status</i>) passed in from an HTML form in a servlet:

<PRE><font face="Courier New">   String custid = request.getParameter("custid");
   String status = request.getParameter("status");
   String sql = "select * from problem where custid='" + custid + "' and status='" + status + "';"
   // next, just fill the table... </font></PRE>

<TABLE width=90% cellpadding=5 border=1><TR><TH>CUSTID</TH><TH>PROBLEMID</TH><TH>CONTACTID</TH><TH>SUMMARY</TH><TH>RESOLUTION</TH><TH>PRIORITY</TH><TH>STATUS</TH><TH>OWNER</TH><TH>CITY</TH><TH>OPENED</TH><TH>UPDATED</TH><TH>CLOSED</TH></TR>
<TR><TD>PERSIPHONE CO.</TD><TD>6</TD><TD><A HREF=mailto:weblogictour@weblogic.com>MARVIN               MCCARTHY</A></TD><TD>AUTO ROLLOVER INTERMITTENT</TD><TD>&nbsp;</TD><TD>Medium</TD><TD>Escalated</TD><TD>&nbsp;</TD><TD>Montpellier</TD><TD>&nbsp;</TD><TD>&nbsp;</TD>&nbsp;<TD>&nbsp;</TD></TR>
<TR><TD>PERSIPHONE CO.</TD><TD>13</TD><TD><A HREF=mailto:weblogictour@weblogic.com>LILLY                WONG</A></TD><TD>TWO EXTENSIONS SEEM TO BE CROSS-CONNECTED</TD><TD>&nbsp;</TD><TD>High</TD><TD>Escalated</TD><TD>&nbsp;</TD><TD>Atlanta</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
</TABLE>
</FONT><P ALIGN=right><A href="problem.html"><FONT SIZE="+2" FACE="Courier New"><b>More . . .</b></FONT></A></P>
<CENTER><IMG HEIGHT=19 WIDTH=680 SRC="../classdocs/images/bar.jpg"></CENTER>

</BODY>
</HTML>
