finding extension

[hoz]

How do you find an extension (either doc or pdf) of a file by querying a
database that gives you the ID of the record when you don't know which
extension it is? I know how to get this info when uploading a file, but I want
to get this info when checking my records on a cfm page. Is it possible to get
whatever follows the period on my link below:

<cfquery name='qproject...'

<cfoutput query='qproject'
<a href="/webservices/publication/samples/#pubID#.">)SAMPLE OF PROJECT</a>
</cfoutput>

So the URL above would either
http:[url]www.mydomain.com/webservices/publication/samples/40.(pdf[/url] or 40.doc)

Thanks,

Hoz

[mxstu]

If your table does not store the filename for some reason, you could probably
use the FileExists() function to determine which file extention to display. If
the file "40.pdf" exists in the target directory, show a link for that file,
etc...

[hoz]

That works. Thanks!