Are you attempting to save the FORM.Filename as the filename? What you actually want to store in your database is File.ServerFile, which is a CF variable available after using CFFILE. For more of these variables right-click in CF Studio, select Insert Expression, select variables and CFFILE for more CF variables available for use. Hope this help Regards Mike Connolly -----Original Message----- From: Shally [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 14:59 To: CF-Talk Subject: Please help!! Hello Every one, I am using Cffile in my action page to upload a file in a particular location. This is working fine. But then I have to insert the file name which is being uploaded in my table too. I used Cfinsert aswell as SQL insert statement to insert the file name in the database biut neither worked. Please Help!! Shally ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
