Posts | Comments

Archive for September, 2007

Us, just after getting married

Justine and I  Kevin and I  Tasia and I

Sean Flanigan, our amazing wedding photographer, has updated his Web site (and therefore I have updated most of mine) with new photos from my wedding to Justine Michele Corcorran (Edge).

Please take a moment to browse the photos (there’s a lot, bring tissues) and I’ll let you know when the final prints are available for purchase!

Thanks again, Sean. You are an amazing person.

So I’ve got this form. On this form will be [n] number of teams, displayed as a text label (the school’s full name), a textfield with the acronym for the school, and a textfield with the option to enter a team score for a scheduled event.

The problem I’m having is this: let’s say you have 8 schools listed, but only have scores for numbers 1-6 and 8 (#7 is missing a score). If you attempt to leave the 7th school blank and save the form, number 8 will appear blank and #7 will inherit the score of #8 (see the screenshot).

Score-It Screenshot of tracking team scores

The variables I’m dealing with are stored as an array of ‘teamID[n]‘ ‘teamAcronym[n]‘ and ‘teamScore[n].’ If you loop through the array, you will have 1-n of scores, only storing when a variable is in-fact loaded (meaning the array doesn’t have an empty slot, such as [1,2,3,4,5,6,8]).

Any thoughts on updating this list? Perhaps I could change the id’s of the teamScore[n] to ‘teamScore[teamID]‘?

I know how to do this in PHP but so-far ColdFusion doesn’t support me well.

Sigh.

Update: an addition for ADP1207 on #coldfusion:

cfdump:

another screenshot

Update: DanWilson in #coldfusion (on IRC) has come up with the answer:

  1. <cfloop List="#TeamID#" index="thisTeamID">
  2. <cfset whatWeWant = "scoring_1_" & thisTeamID />
  3. <cfif structKeyExists( form, whatWeWant)>
  4. <cfquery name="insertTeamRow" datasource="HSST">
  5. INSERT INTO CEdge.TRACK_TEAM_SCORE
  6. (gameTeamID,teamScore1,gameID)
  7. VALUES
  8. (’#thisTeamID#’,'#form[whatWeWant]#’,'#gameID#’)
  9. </cfquery>
  10. </cfif>  
  11. </cfloop>

I thought EBC had a funny handshake, but this takes the damn cake:

(VIA CollegeHumor.com)

Married To The Sea
marriedtothesea.com

This is the second married to the sea post I’ve made. This Web site kills me.

chadedge dot-com is powered by WordPress. Design by Nofie Iman.