> 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.
Typically, if you set the username and password within the datasource settings in the CF Administrator, you don't have to set them in your CFQUERY tags. I'm not sure if setting them in your CFQUERY tags overrides the values within the CF Administrator, but if it does, and you set it incorrectly within the CF Administrator, that would explain why you need to set them in your CFQUERY tags. > 2. Is there a way to set a default datasource for CF? No. However, you could presumably write a custom tag to invoke CFQUERY for you, which would effectively provide the same result. I wouldn't recommend you do this, though, because it would introduce many more serious problems to solve something that's not very important. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
