Service tickets: DELRAY, LTD.

Resolved tickets for DELRAY, LTD.

Outstanding tickets for DELRAY, LTD.

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
DELRAY, LTD.4BILL STEARNPBX REBOOT FAILED MediumEscalated Lincoln   
DELRAY, LTD.11BILL STEARNBACKHOE DESTROYED OUTSIDE SWITCHBOX MediumEscalated Atlanta   

More . . .