Try naming your queries and referencing your results as #queryname.var#.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Alan Koenig [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 1:00 AM
To: CF-Talk
Subject: Multiple CFFile
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
