• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Using cfloop with image upload

I have set up a form to upload up to 9 photos and would like to upload them using cf_autoresize and then add the photo name to my dbase with the sortordr field increasing by one for each photo. I am using the following code:

<cftransaction>
<cfif isdefined('form.submit_photos')>
  <!--- Get Photo Number --->
<CFLOOP from="1" to="#form.lastnum#" index="i">
<CFSET countVar=startcount+1>
<cf_autoresize_jrp imagepath="d:\inetpub\expat-online\club\irishclub\images\album\fullsize" maxsize="500" thumbsize="150" prefix="tn_" filefield="photo_#countVar#" thumbpath="d:\inetpub\expat-online\club\irishclub\images\album\thumbnail" nameconflict="makeunique">

<!--- Then post to dbase --->
    <cfquery datasource="business" name="InsertData">
        Insert into club_albums_photos (photoName, album, sortordr)
        values ('#Photo#', #album_no#, #countVar#)
    </cfquery>
</cfloop>      
</cfif>
</cftransaction>

It keeps uploading the same photo and does not increase thye sortordr by one. This is not a difficult problem but I am at a loss to figure it out.

Thanks

John
0
tubize
Asked:
tubize
  • 3
1 Solution
 
hclgroupCommented:
before the loop
<CFSET #startcount#=0>

within the loop
<CFSET #countVar#=#startcount#+1>
0
 
hclgroupCommented:
=== ignore last comment ===

before loop
<CFSET #countVar#=0>

inside loop
<CFSET #countVar#=#countVar#+#startcount#+1>
0
 
hclgroupCommented:
Also, I noticed that startcount wasn't initialised anywhere
0
 
kieken69Commented:
hclgroup should be right.

This should work too:

Use the index (=i) of the cfloop and don't use <CFSET countVar...:

<CFLOOP from="1" to="#form.lastnum#" index="i">
<cf_autoresize_jrp imagepath="d:\inetpub\expat-online\club\irishclub\images\album\fullsize" maxsize="500" thumbsize="150" prefix="tn_" filefield="photo_#i#" thumbpath="d:\inetpub\expat-online\club\irishclub\images\album\thumbnail" nameconflict="makeunique">

<!--- Then post to dbase --->
    <cfquery datasource="business" name="InsertData">
        Insert into club_albums_photos (photoName, album, sortordr)
        values ('#Photo#', #album_no#, #i#)
    </cfquery>
</cfloop>    
</cfif>
</cftransaction>
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now