Some developers just don't believe in "standards." I should know, I used to work with some of them. They had their own way of doing things, from reinventing the database to changing the web paradigm. I always found it ironic that these folks have a pretty good knowledge of the tools, but could never seem to figure out how to use 'em. Like Chris' predecessor, who seems to have done the equivalent of tightening screws with a voltammeter.
Ok, so I had to port over an ASP app to Coldfusion MX. It was a simple set of search pages so I didn't think it would take too long. Problem was, I couldn't find anywhere in the code where the HTML for one of the select boxes was. Silly me, I should have checked inside the SQL Server stored procedure first! And of course, this is just the tip of iceberg on this site. There were stored procedures that were used to build the actual HTML for the dynamic navigation as well.CREATE PROCEDURE GetDepartmentDropDown AS IF ((SELECT COUNT(*) FROM Staff_DepartmentLink) > 0) BEGIN CREATE TABLE #HTML (src varchar(1000)) INSERT #HTML (src) Select '<SELECT name="DepartmentID">' INSERT #HTML (src) SELECT '<option value="-1" SELECTED>(None Selected)</option>' INSERT #HTML (src) SELECT DISTINCT '<option value="' + CONVERT(varchar(6), DeptID) + '">' + DepartmentName + '</option>' As src FROM StaffDepartments INNER JOIN Staff_DepartmentLink ON StaffDepartments.DepartmentID = Staff_DepartmentLink.DeptID ORDER BY src INSERT #HTML (src) SELECT '</SELECT>' SELECT src As 'rowsrc' FROM #HTML DROP TABLE #HTML END ELSE Select '<i>No Departments Defined</i>' As rowsrc