Hi
frustrated now
this code allows users to download files
specific to the company they are part of
it all works fine for every file type BUT
Mpgs
I get an HTML file down instead of the
requested file .. but the file download dialog knows its an Mpeg but the
save as dialog box thinks its an HTML file
anyone know why?
Thanks
---------------------------------------------------------------------------------------------------------------------------
<cfif
isdefined("session.UserID")>
<cflock
scope="session" timeout="10">
<cfset request.userId =
session.userId>
<cfset request.CompanyId =
session.companyID>
</cflock>
<cfquery
datasource="#datasource#" name="getuser" dbtype="odbc"
dbserver="#dbserver#" username="#dbusername#"
password="#password#">
Select userName
from
tbluser01
where
companyId = #request.companyID#
and
userId = #request.userId#
</cfquery>
<cfif getuser.recordcount EQ
1>
<cfquery datasource="****"
dbserver="*****" username="****" password="**"
name="getfile">
Select *
from tblfile01 #
where fileID = #val(url.FileId)#
and companyId
=#request.companyId#
</cfquery>
<cfheader
name="Content-Disposition"
value="attachment;filename=#trim(getfile.fileName)#">
<CFCONTENT TYPE="application/unknown" DELETEFILE="No"
FILE="***\secure\#trim(getfile.Filelocation)##trim(getfile.Filename)#"
RESET="Yes">
<cfelse>
<script>
self.close();
</script>
</cfif>
<cfelse>
<script>
self.close();
</script>
</cfif>
|\--------------------/|
Matt Horn
Web
Applications Developer
Ph:+2782 424 3751
W: http://www.matt-horn.org
E:[EMAIL PROTECTED]
|\--------------------/|
