Solved

Coldfusion SELECT Options

Posted on 2007-03-28
3
224 Views
Last Modified: 2013-12-24
Coldfusion Question SELECT option
I have the following code:
<TD>Fruits</TD>
<cfinclude template="/market/diff_fruits.cfm">
<TD colspan="4">
      <SELECT name="available_fruits">
              <option value="">
         <cfoutput query="diff_fruits.cfm">
             <option value="#code#" >#description#
         </cfoutput>
      </SELECT>
The Query pulls the following records:
Code             Description
B                   Banana
A                   Apple
O                   Orange

I want to base the selections on certain users.  Like User A can only pick Banana and Apple while user B can only pick Orange.  Or User A can see all options but Orange is grayed out.


Any help is appreciated.  Thanks!
0
Comment
Question by:jramos74
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
bwasyliuk earned 500 total points
ID: 18817229
Hi,

From the code included so far - it is hard to tell whether your database or user security structure even supports this functionality.  What criteria about a user should restrict or define their access to the given options?

Example: UserA is a member of Group1, UserB is a member of Group2 (groups would likely be another table).
Your Fruits table would need to have a bridge to the Groups table to restrict access by group to the different options.

If you want to explain a little more about your structure, I am happy to assist.

Ben
www.ScheduleForce.net
0
 

Author Comment

by:jramos74
ID: 18817577
Thanks, Ben.  I know my explanation was not clear.  But I did figure it out.  
0
 

Author Comment

by:jramos74
ID: 18817588
Thanks again for your time looking at it.  
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
.htacess file 301 redirects that are strange 4 63
SPLUNK REST  API call to Splunk to create and index? 2 143
Configure IIS to process JSON 10 88
use of cookies and regulations 1 100
Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question