So I’m pulling my hair out and pulling my hair out trying to figure out why my code isn’t working. In the process I resolve a fairly significant logic flaw (which is a good thing) but still it doesn’t seem to work and nothing is changing in the results when I finally remember that I put maxrows="10" on the <cfoutput> for troubleshooting.
Long and short that means I couldn’t figure out why anything past the 10th record was not updating and the reason was because I told the code not to update anything past the 10th record.
Thank you for joining me for that moment of Geek Zen.