Service tickets: BEA WEBXPRESS, INC.

Outstanding tickets for BEA WEBXPRESS, INC.

Outstanding and resolved tickets for BEA WEBXPRESS, INC.

The essential code to do this operation relies on parameters (for example, custid and status) passed in from an HTML form in a servlet:

   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... 
CUSTIDPROBLEMIDCONTACTIDSUMMARYRESOLUTIONPRIORITYSTATUSOWNERCITYOPENEDUPDATEDCLOSED
BEA WEBXPRESS, INC.2LARRY HALLEXTENSION 658 INOPERATIVEREPLACED LINE ADAPTERCriticalClosed St. Paul   

More . . .