« History is Made: MBS Meets CBORD!! | Main | Processing Multiple Row Check Boxes - Part I »
August 30, 2005
More SWAMP Fun - Closing Work Requests
Who doesn't like a good challenge? This week Tom Neal requested a modest modification to the campus-wide Work Request system. He wanted an easy way to track open vs. closed work requests. The goal was to spend a minimal amount of time to keep track of the status of work requests to make sure none of them fall between the cracks.
So, I slapped a new column on the main table - "status", and marked all but a few work requests as 'C' (for closed). In no time, I had a nice view of work requests that were still '' (null = open). Nice.
My idea was to display a list of all open work requests, one record per line, on a form. Each record would have a check box at the end of the record. To close one or more work requests you could check the appropriate box(es) and press a button. Easily said, but boy did I have a time with making it happen. But now it works, and maintaining the "status" should be a breeze. Thanks Will for your advice on handling the array!
Here's a screen shot.
One button click will close the 5 selected work requests.
If you would like to see the code that makes it happen, look for my forthcoming entry under the DHTML and PL/SQL Coding category. I will place some code snippets out there for your review. By adding new code on a regular basis I'll eventually get a nice list of useful code, plus some feedback on improvements or alternative coding ideas from others. Sounds good - look for it!
By the way - did you know that Troy got PHP up and running on our test instance of Oracle 10g? Sweet!
Posted by rossm at August 30, 2005 4:23 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)