Trimming the file name fromt the path

[Newsgroup_User]

I am using cffile to upload an image to the database. I need to figure out a
way to only store the filename in the database verses the path. How can I do
this?

<cffile action="upload" accept="image/gif, image/jpeg, image/jpg, image/png,
image/psd" destination="E:\webs\website.com\main\clients\logos"
filefield="form.logo" nameconflict="makeunique">


--
Wally Kolcz
Developer / Support

[dempster]

CFFILE returns a set of variables with information about the upload:

Directory: #File.ServerDirectory#
Server File Name: #File.ServerFile#
File Size: #File.FileSize#
Time Created: #File.TimeCreated#
Time Last Modified: #File.TimeLastModified#

ServerFile is the one you want.

[Newsgroup_User]

To be able to use any of those, you would want to enter the cffile prior to
the cfquery INSERT, correct? Would you then set the #File.ServerFile# to a
variable so it can be inserted?

"dempster" <webforumsuser@macromedia.com> wrote in message
news:eb2e4k$13v$1@forums.macromedia.com...
> CFFILE returns a set of variables with information about the upload:
>
> Directory: #File.ServerDirectory#
> Server File Name: #File.ServerFile#
> File Size: #File.FileSize#
> Time Created: #File.TimeCreated#
> Time Last Modified: #File.TimeLastModified#
>
> ServerFile is the one you want.
>
>

[Abinidi]

Yes.
Do your uploading using CFFILE. Once the code completes that section, it will give your variables that you can use in the code .
Now do your cfquery and use the variables that CFFILE created.