<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Service tickets: DELRAY, LTD.</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: DELRAY, LTD.</FONT></H2>
<P><A href="cust2svccustid=13662&status=2"><B>Outstanding tickets for DELRAY, LTD.</B></A>
<P><A href="cust2svccustid=13662"><B>Outstanding and resolved tickets for DELRAY, LTD.</B></A>
<P><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>
</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>
