>1) Does anyone know where I can find some *good* documentation, or maybe even a good book, that covers CFC concepts?
You should subscribe to the http://cfczone.org/ mailing list. Great stuff there. Also, check the history for some recommendations on books. >2) First, you need to "var" your local variables in the CFC's functions. For example, you have a query named "usersLockedRecords". Right after the <cfargument> tag, you need to specify: <cfset var usersLockedRecords = ""> There are tons of posts about this issue. You can check the history of this mailing list or the http://cfczone.org/ mailing list. Second, you should use <cfqueryparam> to avoid a lot of issues with dynamic queries. Again, there are lots of posts about this issue, so I won't go into detail here. Finally, Since your UPDATE statement doesn't appear to be very complicated, I would just have the "UnlockUserRecords" method call its own CFQUERY statement rather than looping over the second method's results. Remember, each time you loop, that is an extra DB interaction that could cause site performance issues. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193922 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
