Hi guys, im hoping you can help.
Im currently working on a page that contains a single drop down list that is
dynamically populated from the database. The list contains all the names of
the managers in my application. The query that generates this list is as
<cfquery datasource="Project" name="Manager">
SELECT ReportsTo, EmployeeID, LastName & ', ' & FirstName As ManagerName
WHERE IsManager = Yes
ORDER BY LastName, FirstName
And that list is displayed in the following form:
<form action="managerProcessing.cfm?action=no" method="post"
name="demoteManager" onsubmit="return demote()">
<table width="445px" cellspacing="5">
<td class="p" colspan="3">Select the manager you wish to ...