Sure it's possible -- that's how the CF Administrator does it :) In CF5 and below, there are a set of "undocumented" tags for doing admin tasks, though there are many references online. I figured out how to use them by looking at the cfm code in the cfide/administrator directory (after *cough* unencrypting *cough* it) when I first did this quite a while ago.
If you're using CF5 (only) you could also think about using dynamic DSN in the CFQUERY tags you're using. Sort of like ASP's dynamic DSN code -- but was only added in CF5 and removed in CFMX. There's also a CFX tag in the mm exchange if memory serves. And you can always look at the registry for the cfadmin settings and write a tag w/ cfregistry to do it yourself. And if you're using CFMX, those values are stored in XML config files somewhere (aren't they? I've been deep in CF5 projects lately and may be misremembering) Regards, John Paul Ashenfelter CTO/TransitionPoint ----- Original Message ----- From: "James Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 10:58 PM Subject: Creating a CF Data Source with CF Code - Possible? > Hello, > > I'm creating an application where trusted users can upload MDB files for > processing. I plan on verifying the uploaded MDB file with a simple > <cfquery> then if it passes, continue on with the processing. Part of the > app is a way to Add/Modify/Delete these users. > > My plan is to have a DSN for each user based on their assigned name. The MDB > file assigned to this DSN will be a "dummy" file, just so I can create the > DSN. The process will copy the uploaded MDB file to the appropriate > directory, thus allowing me to do the cfquery. This DSN will be held in a > variable when they log on, so I can do the cfquery on the MDB they just > uploaded. > > My question is this. Is it possible to create a CF Data Source without > having to use CF Administrator? All users of the Add/Modify/Delete portion > of the app will be trusted employees. However, I'd like to make the process > as automated as possible. > > Thanks, > > James > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
