I have 4 cffiles set up on one form page. The first cffile uploads to the proper
location and also inserts into the db however the other 3 do not get the proper
information.
My code looks like this.
<cffile action="UPLOAD" filefield="ItemPicLB" destination="#storepath#\images"
nameconflict="OVERWRITE">
<cfquery datasource="#datasource#">
UPDATE ProdPics
SET
ItemPicLB = '#ItemPicLB#'
WHERE #ItemID# = PicID
</cfquery>
<cffile action="UPLOAD" filefield="ItemPicF" destination="#storepath#\images"
nameconflict="OVERWRITE">
<cfquery datasource="#datasource#">
UPDATE ProdPics
Set
ItemPicF = '#ItemPicF#'
WHERE #ItemID# = PicID
</cfquery>
<cffile action="UPLOAD" filefield="ItemPicB" destination="#storepath#\images"
nameconflict="OVERWRITE">
<cfquery datasource="#datasource#">
UPDATE ProdPics
Set
ItemPicB = '#ItemPicB#'
WHERE #ItemID# = PicID
</cfquery>
TIA
Alan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
