withing apermissioning group.
Example:
For example a person with customer access may have permission to articles
a,b,c but not d,e,f. Another person with customer access may have permssion
to articles a,c,e but not b,d,f.
The reason that each article category isn't it's own permissioning category
is that the site owner needs to be able to add and remove article categories
via an admin screen (insert and delete items from a table)
application.cfm pseudo-code (basic)
if (person has customer access){
get customerID
show all article categories for this customer
}else{
send to "I'm sorry you don't have access to this article page."
}
Most people will have more than one article category.
There are 2000 plus individuals with customer access.
There are 9 current categories.
I'm concerned that the following queries are not very efficient.
application.cfm pseudo-code (simplified queries)
if (person has customer access){
1. get customerId/login query
2. get customer's article categories (5000+ rows and counting)
SELECT articleCategories
FROM customersCategories
WHERE customerID = #customerID#
3. display articles
SELECT *
FROM articles
WHERE
<cfloop from="1" to="#getArticleCategories.recordCount#" index="myIndex">
articleCategory = "#myIndex#" AND
articleCategory = "#myIndex#" AND
...
</cfloop>
articleDisplayDate <= now()
}else{
send to you don't have access page.
}
This doesn't seem to be very efficient. I have other questions. But this
post is already long enough.
Gil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
