image upload again - Coldfusion - Advanced Techniques

[Craig77]

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>

[weswhite7]

you would instead do:
<cfset myFileName = #cffile.serverFile#>

<cfquery datasource="DPSGuide">
UPDATE Aged_Care_Facility_Details
SET
WebSite_CompanyLogo = <cfquery paramvalue="#myFileName#">
WHERE ID = #ID#
</CFQUERY>

as for gettin an error about the image....

<cfif #form.WebSite_CompanyLogo# eq "">
(this would do nothing)
<cfelse>
run the upload code you have
</cfif>

[Craig77]

ok i tried that but i get this error

Context validation error for tag cfquery.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding </cfquery>. If the body of the tag is empty you can use the
shortcut <cfquery .../>.

The error occurred in C:\CFusionMX7\wwwroot\CFIDE\DPSGuideWeb\All
Files\WebSite\Files\Update.cfm: line 59

57 : <CFSET myFileName = #cffile.serverfile#>
58 :
59 : <cfquery datasource="DPSGuide">
60 : UPDATE Aged_Care_Facility_Details
61 : SET WebSite_CompanyLogo = <cfquery paramvalue="#myFileName#">

[weswhite7]

can you post your whole block of code?

[Craig77]

ok see below

many thanks

<cfif #form.WebSite_CompanyLogo# eq "">
<cfelse>

<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 = #cffile.serverfile#>

<cfquery datasource="DPSGuide">
UPDATE Aged_Care_Facility_Details
SET WebSite_CompanyLogo = <cfquery paramvalue="#myFileName#">
WHERE ID=#ID#
</CFQUERY>

</cfif>
<CFOUTPUT>Name of file uploaded to server: #myFileName#</CFOUTPUT>

[weswhite7]

Ok see attached code..

you need to make sure that in your form you make a hidden field to hide your
id that has been assigned

<input type="hidden" name="id" id="id value="#id#">

<cfif isdefined("form.submit")>

<cfif #form.WebSite_CompanyLogo# eq "">

<cfelse>

<CFFILE ACTION="UPLOAD"
DESTINATION="c:\inetpub\wwwroot\CompanyImages\"
FILEFIELD="WebSite_CompanyLogo"
ACCEPT="image/pjpeg, image/jpeg, image/jpg, image/jpeg, image/pjpeg"
nameConflict = "MakeUnique">

<CFSET myFileName = #cffile.serverfile#>

<cfquery datasource="DPSGuide" name="namehere" password="passwordhere"
username="usernamehere">
UPDATE Aged_Care_Facility_Details
SET
WebSite_CompanyLogo = <cfquery paramvalue="#myFileName#">
where id = #form.id#
</CFQUERY>

</cfif>
<CFOUTPUT>Name of file uploaded to server: #myFileName#</CFOUTPUT>

</cfif>