Claude
Do something like this
<cfloop from="1" to="5" index="i">
<cfif Len(Trim(Form["Image_#i#"]))>
<cffile action="UPLOAD" filefield="form.Image_#i#"
destination="[dir]" nameconflict="MAKEUNIQUE">
<cfif CFFILE.FileWasSaved>
<cfset loadedImages["mainImage_#i#"] =
CFFILE.ServerFile>
<cfelse>
<cfset loadedImages["mainImage_#i#"] = "">
</cfif>
<cfelse>
<cfset loadedImages["mainImage_#i#"] = "">
</cfif>
</cfloop>
<cfloop from="1" to="5" index="i">
<CFQUERY NAME="UPDATE_image" datasource="#ds#" username="#un#" password="#pw#">
UPDATE table
SET property_image_#i# = '#loadedImages["mainImage_#i#"]#'
where id=#form.id#
</CFQUERY>
</cfloop>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
