Link a file using ColdFusion Variable
I have following code to generate a csv file using my stored procedure return.
After file created, I create a link to let user access.
The link does not add my file name variable.
Are there any better way to add my variable to the link that user can access the file just created or just created the file on the local machine that user can access
locally?
Your information and help is great appreciated,
Regards,
<Cfset thisPath = ExpandPath("*.*")>
<cfset f_dir = GetDirectoryFromPath(thisPath)>
<cfset f_name = "#dateformat(now(), 'mmddyy')##timeformat(now(), 'hhmm')#.csv">
<cffile action="WRITE" file="#f_dir##f_name#"
output="MtField1, MyField2" addnewline="Yes">
<cfloop query="#myQuery#">
<cffile action="APPEND" file="#f_dir##f_name#"
output="#Field1#, #Field2# addnewline="Yes">
</cfloop>
<br>
<a href="MyServer\Report\" + #f_name#>Here is the file</a>
AdChoices