<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Service tickets: TANGERINE SOFTWARE </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: TANGERINE SOFTWARE
</FONT></H2> <P><A href="cust2svccustid=14573&status=3"><B>Resolved
tickets for TANGERINE SOFTWARE </B></A><P><A
href="cust2svccustid=14573&status=2"><B>Outstanding tickets for
TANGERINE SOFTWARE </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>TANGERINE SOFTWARE </TD><TD>5</TD><TD><A HREF=mailto:weblogictour@weblogic.com>KELLY                REDDING</A></TD><TD>16 DESKTOP UNITS NEED REPAIR</TD><TD>&nbsp;</TD><TD>Medium</TD><TD>Escalated</TD><TD>&nbsp;</TD><TD>Jacksonville</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR><TD>TANGERINE SOFTWARE </TD><TD>8</TD><TD><A HREF=mailto:weblogictour@weblogic.com>BOB                  CLARKE</A></TD><TD>BACKUP POWER GENERATOR FAILED</TD><TD>REPLACED GENERATOR BRUSHES</TD><TD>Critical</TD><TD>Closed</TD><TD>&nbsp;</TD><TD>St. Paul</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR><TD>TANGERINE SOFTWARE </TD><TD>12</TD><TD><A HREF=mailto:weblogictour@weblogic.com>KYLE                 JANSEN</A></TD><TD>CALLER ID INOPERATIVE</TD><TD>&nbsp;</TD><TD>Medium</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>
