server.mappath() for CF?

[TruthInSatire]

I'm trying to set up a dynamic db connection but can't see it being very portable if i have to give the direct path to the db.
asp has a server.mappath function to give the the root directory then i add the rest of the path as needed to reach the db. is there anything like server.mapPath in CF or any easy way to get to the root?

Thanks.

 

[SidianConsulting]

Yes, it's called ExpandPath():

<cfoutput>#ExpandPath(&quot;.&quot;)#</cfoutput>

If you were in

http://www.mysite.com/mypages/index.cfm,

and the "mypages" directory was a sub-directory under c:\InetPub\

http://wwwroot,

the physical path would be:

c:\InetPub\

http://wwwroot\mypages

-Tek

 

[travmak]

what is the best way to get down to the

http://wwwroot

so its easy to change the folder. the thing is we have all of our db's in one folder. we can be 12 folders deep and want to get to the root then specify the db folder.

not in relation to where I am but to relation to root.

so if my db's are in ...

http://wwwroot/databases/

and i was in

http://wwwroot/me/my/mysite/default.cfm

i want to drop the me/my/mysite...

server.mappath returns the root, then add what you want

server.mappath("/databases/mydb.mdb&quot returns

http://wwwroot/databases/mydb.mdb

 

[imstillatwork]

you can treat

http://wwwroot/me/my/mysite/default.cfm

as a "/" delimited list and get anything you want from it. help?