<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Service tickets: BEA WEBXPRESS, INC.</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: BEA WEBXPRESS, INC.</FONT></H2>
<P>
<A href="cust2svccustid=18021&status=3">
<B>Resolved tickets for BEA WEBXPRESS, INC.</B></A>
<P><A href="cust2svccustid=18021&status=2">
<B>Outstanding tickets for BEA WEBXPRESS, INC.</B></A>
<P>The essential code to do this operation relies on  parameters
(e.g, <i>custid</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>BEA WEBXPRESS, INC.</TD>
<TD>2</TD>
<TD><A HREF=mailto:tengahtour@weblogic.com>LARRY                HALL</A></TD>
<TD>EXTENSION 658 INOPERATIVE</TD>
<TD>REPLACED LINE ADAPTER</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>BEA WEBXPRESS, INC.</TD>
<TD>3</TD>
<TD><A HREF=mailto:tengahtour@weblogic.com>DAN                  BROWN</A></TD>
<TD>NOISE ON TOLL FREE LINES</TD>
<TD>&nbsp;</TD>
<TD>Critical</TD>
<TD>Escalated</TD>
<TD>&nbsp;</TD>
<TD>Boise</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>

<TR><TD>BEA WEBXPRESS, INC.</TD>
<TD>9</TD>
<TD><A HREF=mailto:tengahtour@weblogic.com>DAN                  BROWN</A></TD>
<TD>NOISY LINES</TD>
<TD>&nbsp;</TD>
<TD>Critical</TD>
<TD>Escalated</TD>
<TD>&nbsp;</TD>
<TD>Boise</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>
