Hi Graham,

>I am working on creating a News Article section within one of the
>applications that is powered by SpeckCMS. My question is how do I get
>the path location on the hard drive out of the UUID which is stored
>within the spId of my Document Table. I am wanting to link do users will
>be able to download the file within this UUID Directory.

Assuming you are using a picker property to create a collection of
documents which are "related" to an article, you should be able to just
call cf_spContentGet with type="Document" and id="<list of picked ids>" to
get back a query containing paths to the files. These are paths that are
expected to be accessed via a web browser, they are not the physical paths
to the files on the server, but it sounds like that's what you want.

Some background info...
Most Speck property values are simply stored in the database, but asset
property values (i.e. files) are stored on the filesystem. The asset
property type has a contentGet method, which Speck calls when it needs to
get asset property values. This method checks that the file exists on the
filesystem, and returns a path to the asset which can be used as a download
or view link on a web page. So, when you call either sp_content or
sp_contentGet to retrieve content items of a type that has one or more
assets, Speck magically returns a download/view path to the assets, even
though that path isn't actually stored in the database (in fact, we just
store the current version number in the database).


Regards

Mark


--------------------------------------------------------------------
mail2web LIVE – Free email based on Microsoft® Exchange technology -
http://link.mail2web.com/LIVE