The CF documentation is a good place to start: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSd160b5fdf5100e8f790124b112a3b8b2adb-8000.html
<this.datasource={name='cfartgallery', username="user", password="passwd"}> -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 22 September 2010 12:29, Mary Jo Sminkey <mary...@cfwebstore.com> wrote: > > I posted this over on the CF-ORM list on google, but not much luck, so > thought I'd see if any of you smart HOF folks know. ;-) > > According to the CF 9.01 release notes, you can now use a structure > for setting the application.datasource setting. I really would like to > do this for an ORM application I'm doing, as we use a single Oracle > database for our servers, and each application has its own > schema....so typically we just have one db and each application > has a specific username/password to connect to its own schema. But there > doesn't seem to be any documentation or example anywhere on how to do this, > and I'm not having much luck trying to figure it out. I tried this: > > this.datasource = {datasource = 'oracle_db', username='schema', > password='password' } ; > > And all I got was an error from ColdFusion that it couldn't cast a > struct to a string. So clearly that's not the way to do it. > > So any idea how to do this? > > > --- Mary Jo > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm