Solved

Using cfloop with image upload

Posted on 2006-11-02
4
245 Views
Last Modified: 2010-04-16
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
Comment
Question by:tubize
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 4

Expert Comment

by:hclgroup
ID: 17861216
before the loop
<CFSET #startcount#=0>

within the loop
<CFSET #countVar#=#startcount#+1>
0
 
LVL 4

Expert Comment

by:hclgroup
ID: 17861312
=== ignore last comment ===

before loop
<CFSET #countVar#=0>

inside loop
<CFSET #countVar#=#countVar#+#startcount#+1>
0
 
LVL 4

Accepted Solution

by:
hclgroup earned 125 total points
ID: 17861319
Also, I noticed that startcount wasn't initialised anywhere
0
 

Expert Comment

by:kieken69
ID: 17893645
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

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Starting up a Project

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question