I can't understand this ive done it a million time but now forgotten
something obvious.
I want to see if a variable is defined.
<cfif isdefined(form.modifiedbannerpic)>
<cffile action ="UPLOAD"
filefield ="Modifiedbannerpic"
nameconflict = "overwrite"
accept = "image/gif"
destination = "e:/inetpub/wwwroot/store/banners">
<cfif #file.filewassaved# eq "yes">
<cfset modifiedbanpic = '#trim(file.serverfile)#'>
<CFQUERY NAME= "update_query" DATASOURCE= "#application.dsn#">
UPDATE tblbanners
SET Banner_pic = '#trim(form.modifiedBannerPic)#'
WHERE ID = #Form.BannerID#
</CFQUERY>
<cfelse>
PIC NOT SAVED
</cfif>
</cfif>
Regards - Paul
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
