see my reply below see my reply below
see my reply below This is all set in the datasource settings in the CFAdmin tool. DK On 8/1/06, vcc person <[EMAIL PROTECTED]> wrote: > > Hi there, > > I created some datasource (SuseLinux + Oracle) and in some datasource > instances, I don't need to specify the username and passwords in the cfquery > tag while in some I do (even though they are on a separate server from my CF > box). > > For example: > > in CF administrator (CFMX 6.1) : > > Datasource A = server1, Datasource B = server1, Datasource C = server2 > > <cfquery name="xxxx" datasource="A"> ..... </cfquery> > > <cfquery name="xxxx" datasource="B" username="xxx" password="xxxx"> ..... > </cfquery> > > <cfquery name="xxxx" datasource="C"> ..... </cfquery> > > > > Questions: > > 1. Do you know why on some I had to add and some I don't have to specify > the username and password? Ideally, I don't want to have them displayed. > > 2. Is there a way to set a default datasource for CF? > > thanks everyone > > Steve > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
