I ran into the same problem. I assign datasource in the application.cfm and then lose the connection string in the cfc. I believe the problem is that a cfc is intended to run in a different machine as thought it were a web service. As a result Cold Fusion does not carry the application state across the boundary even if it is on the same machine. It may be in a different process or a different thread. I do not know the cf internals well enough to know exactly why.
That being said, I defined a datasource variable in the cfc and all went well. The other way to do it is to pass the application.datasource variable across as a function variable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:315810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
