Randy,
Thanks, works now.
James
"Adkins, Randy" wrote:
>
> 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
