Hey, thanks for responding. Creating a shared data source like you mention would work, however this this data I'm wanting to share is probably going accessed on every page request, so hitting the database on every request is something I would like to try to avoid, if possible.
*Ryan J. Heldt*, Senior Web Developer Global Reach Internet Productions http://www.globalreach.com Phone: 515-296-0792, Fax: 515-296-3748 Jason Fisher wrote: > To clarify a bit on Adrian's suggestion, allow the other applications to > access the database of the core management application. One suggestion is to > create a read-only datasource to that database and use that new DSN when > accessing from the 'other' applications. > > Example: > adminSource: datasource with full INSERT, UPDATE, DELETE access, used by core > app > adminReader: datasource with SELECT / proc access ONLY, used by other apps > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
