I believe you can get all the available datasource info through the admin
api.
Something like this should spit it all out for you.
<cfset adminObj = createObject("component","cfide.adminapi.administrator")
/>
<cfset isLoggedIn = adminObj.login(yourCFAdminPassword) />
<cfif not isLoggedIn>
LOGIN FAILED
<cfelse>
<cfset dbObj = createObject("component","cfide.adminapi.datasource")
/>
<cfdump var="#dbObj.getDatasources()#" />
</cfscript>
That would dump all datasources and their settings. I'd assume the access
path would be in there since it is one of the settings when creating access
datasources.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-----Original Message-----
From: Bryan Stevenson [mailto:br...@electricedgesystems.com]
Sent: Wednesday, June 23, 2010 5:35 PM
To: cf-talk
Subject: Re: How can you GetFileInfo for a datasource?
If you know the absolute path to the DB....
You can just set a global var that holds that path.
Of course that isn't the most graceful solution, but I'm not sure if
there is a way to programmatically determine the absolute path of an
Access DB used in a CF datasource.
If the DB won't be moving around, then I'd just do something along the
lines of what I suggested.
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
web: www.electricedgesystems.com
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.
Please consider the environment before printing this e-mail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:334790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
