James,
When the information is stored into the database
( DOCUMENTS ) check the variable named used
with in the insert
There is where you want to use #File.ServerFile#.
Then yes, your content would use the variable
that you pull from the docs query.
*** Note the name in the Select Line must be the same
in the CONTENT File name.
Example:
<cfquery name="docs" datasource="lsars">
select documents
from taavon.submissions
where lid = '#url.lid#'
</cfquery>
<cfcontent type="application/pdf"
file="c:\inetpub\wwwroot\Intranet-Secure\lsar_new\pdf\#docs.documents#">
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 10:44 AM
To: CF-Talk
Subject: Re: Resolving file name after upload
Randy,
Do I use that in my CFCONTENT. Currently i have....
<cfquery name="docs" datasource="lsars">
select documents from taavon.submissions
where lid = '#url.lid#'
</cfquery>
<cfcontent type="application/pdf"
file="c:\inetpub\wwwroot\Intranet-Secure\lsar_new\pdf\#docs.name#">
"Adkins, Randy" wrote:
>
> After the file is uploaded, you should be able to use:
> #File.ServerFile#
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 13, 2001 10:13 AM
> To: CF-Talk
> Subject: Resolving file name after upload
>
> After successfully uploading a file to the server I want to be able to
> view from the web. Instead of storing the actual file name in the
> database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp.
>
> I am using a CFCONTENT tag which works great if do direct insert into
> the database via SQL INSERT, but when using my CFFORM it uses this temp
> name. What can I do to resolve this problem to get the actual fil name
> in the database?
>
> Thanks!
>
> James
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
