CF not returning values to drop down list

[ndeeley]

Hello,

I've written a script which returns the admin rights of users in a table - their access level, and their priviledges.

The priviledge are returned to a check box and the admin rights to a drop down list. I want this list to have more than one value so that it can be altered.

I've created a loop to run through the drop down options and select the one that matches in the database. However it doesn't appear to be working - its not returning the value in the ViewLevel field. It works on other scripts where I return a single row ID, but not when I return all the rows in the database.

Any ideas what I am doing wrong?

Here's the (stripped down) script:

<cfquery datasource="repairmdb" name="GetViewLevel">
    select        ViewLevel, ViewText
    from        tblViewLevel
    order by    ViewLevel
    </cfquery>
 
 
    <cfquery name="GetUsers" datasource="repairmdb">
     select distinct    LoginName, 
            FirstName, 
            Surname,
            ViewLevelFK, 
            CreateReports, 
            CreateUncompReport,
            DeleteRecords,
            AdminRights
    from        tblWebsiteUsers
    order by    Surname
 
 
    </cfquery>
 
<div>
            <form action="Devaction_userchange.cfm" method="post">
            <table style="width: 650px;">
 
            <tr>
            <th class="thl" style="width: 150px">User Name</th>
            <th class="thl" style="width: 100px">Access Level</th>
            <th class="thc" style="width: 100px">Create Report</th>
            <th class="thc" style="width: 140px">Create Uncomp. Jobs Report</th>
            <th class="thc" style="width: 100px">Delete Records</th>
            <th class="thc" style="width: 100px">Admin Rights</th>
            </tr>
 
            <cfoutput query="GetUsers">
 
            <tr>
            <td class="thl" style="width: 150px">#FirstName# #Surname#</td>
            <td class="thl" style="width: 100px">
 
            <select name="ViewLevelFK" size="1" class="droplist">
            <cfloop query = "GetViewLevel">
            <option value="#ViewLevel#"<cfif GetUsers.ViewLevelFK EQ ViewLevel> selected</cfif>>#ViewText#
            </cfloop>
            </select>
            </td>
 
 
            <td class="thc" style="width: 100px"><input type="checkbox" name="CreateReports" value="1"<cfif val(CreateReports) NEQ             
 
0>checked</cfif>></td>
            <td class="thc" style="width: 140px"><input type="checkbox" name="CreateUncompReports" value="1"<cfif val(CreateUncompReport) NEQ     
 
        0>checked</cfif>></td>
            <td class="thc" style="width: 100px"><input type="checkbox" name="DeleteRecs" <cfif val(DeleteRecords) NEQ             
 
0>checked</cfif>></td>
            <td class="thc" style="width: 100px"><input type="checkbox" name="AdminRights" <cfif val(AdminRights) NEQ             
 
0>checked</cfif>></td>
 
            <td><input type="submit" value="Update" class="buttons" name="updateUsers" /></td>
            </tr>
 
            </cfoutput>
 
 
 
 
            </form>
 

thanks
Neil

[acoder]

Use a join query instead of two separate queries.

[ndeeley]

Hi acoder,

Thanks - I`ll give it a go!