Coldfusion/HTML question

Hi Everyone,

I am not able to understand how do the following.

I am populating a drop down box from a database. The drop down has around 4 values. Is it possible not to show a value in the drop down based on a user's privileges.

Suppose, I have three users admin, advisors, and students . The admin only should be able to see all the four values, butadvisors or students should be able to see only three. I have a variable which captures the role of a user, if he is an admin, or a advisor or a student. But not able to think of a solution as the drop down is getting populated from database

Thanks