<cfif listfind(ArrayToList(session.moduleaccess), 3>TRUE<cfelse>FALSE</cfif>
That should only return true if a list item is 3 and only 3 -----Original Message----- From: Michael C.Grove [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 12:54 PM To: CF-Talk Subject: Array issue I have an array that I am using in a security table. The system does a query for a UserID in a table and returns all of the modules that the user has access to. The ModuleID is simply the Autonumber in an access table. The array builds fine. Using the following code below this is what I get and where the error is... CODE <cfoutput>Contents: #ArrayToList(session.moduleaccess)#</cfoutput> RETURNED Contents: 1,7,10,14,13 CODE <cfif ArrayToList(session.moduleaccess) CONTAINS 3>TRUE<cfelse>FALSE</cfif> RETURNED TRUE The error in this is that I need to see of the user has access to module 3. He/She does not, but since they have access to module 13 the system sees it has having a 3. How do I check to see if an array contains a "3"? -----Original Message----- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 6:01 AM To: CF-Talk Subject: CF-Talk: Digest every 8 hours CF-Talk 31-Dec-04 Issue:1443 In this issue: CF+XPath cfapplication/clientvariable Error after Upgrade to MX 6.1 cfapplication/clientvariable Error after Upgrade to MX 6.1 CFC encapsulation CFC encapsulation CFC encapsulation My Init() in my CFC...am I on the right track? OT: query optimization OT: query optimization OT: query optimization OT: query optimization OT: query optimization OT: query optimization QofQ: SELECT DISTINCT QofQ: SELECT DISTINCT QofQ: SELECT DISTINCT query optimization shopping cart, session variables - best practices shopping cart, session variables - best practices Upgraded CF5 to CFMX - applications not working Upgraded CF5 to CFMX - applications not working Webservice output in browser Webservice output in browser Well - I feel like an idiot. Well - I feel like an idiot. Well - I feel like an idiot. Well - I feel like an idiot. Well - I feel like an idiot. Well - I feel like an idiot. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189099 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54