Service tickets: TANGERINE SOFTWARE

Outstanding tickets for TANGERINE SOFTWARE

Outstanding and resolved tickets for TANGERINE SOFTWARE

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
TANGERINE SOFTWARE 8BOB CLARKEBACKUP POWER GENERATOR FAILEDREPLACED GENERATOR BRUSHESCriticalClosed St. Paul   

More . . .