well i am using the code below, i need the name of the file uploaded to be
inserted to a record in my table
it works but i get the vaue of in my column instead of the file name any
ideas, also if there is no image selected i get an error saying no image was
selected how can i get around this?
<CFFILE ACTION="UPLOAD"
DESTINATION="c:\inetpub\wwwroot\CompanyImages\"
FILEFIELD="WebSite_CompanyLogo"
ACCEPT="image/pjpeg, image/jpeg, image/jpg, image/jpe_, image/pjpeg"
nameConflict = "MakeUnique">
<CFSET myFileName = #form.WebSite_CompanyLogo#>
<cfquery datasource="DPSGuide">
UPDATE Aged_Care_Facility_Details
SET WebSite_CompanyLogo = '#myFileName#'
WHERE ID=#ID#
</CFQUERY>...
Bookmarks