TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

Query of Query bug

October 31, 2006 By Michaela Light Leave a Comment

Recently ran into a strange bug with Query of Query.

I'm looping over an outer query “queryA”, which has the collection of patterns.

For each one, I have 2 other queries; queryB and queryC.

I tried getting a QofQ on the queryB, then looping over that to check an error condition. then for error, list a key field of the outer main A query. Looping over the QofQ gave me the wrong result from the outer query!

Tip: If you're using a Q of Q, and looping over it, make sure to put fields from the outer query in local variables. Or find a way that doesn't involve Q of Q until they finally fix the stupid thing 🙂

(same or similar issue was there ever since CF5; still in 7.0.1 cumulative hotfix 2. We've run into on many projects)

– David and Ajay

Related Posts

  • 104 Cfer Mental Helpers (Stay Sane During Crises) With Jeff Kunkel- Transcript104 CFer Mental Helpers (Stay Sane during Crises) with Jeff Kunkel- Transcript
  • Four Steps To Optimize Your Coldfusion Server And ApplicationFour Steps to Optimize Your ColdFusion Server and Application
  • Top 6 Things I Learned Interviewing Cio’s About Adobe ColdfusionTop 6 Things I learned Interviewing CIO’s about Adobe ColdFusion
  • 058 Progressive Web Apps Building – Amazing Lucee Cfml And Coldbox Tricks With Miles Rausch – Transcript058 Progressive Web Apps Building – Amazing Lucee CFML and ColdBox Tricks with Miles Rausch – Transcript
  • Tuning Cf 8.0.1 64 BitTuning CF 8.0.1 64 bit
  • 008 The Best Rest You'Ve Ever Had: Coldbox Rest With Nathaniel Francis- Transcript008 The Best REST You've ever Had: ColdBox REST with Nathaniel Francis- Transcript
  • Facebook
  • Twitter
  • LinkedIn

Filed Under: ColdFusion Developer

← Previous Post Where’s That Bus?
Next Post → CF 8 wishlists

Popular podcast episodes

  • Revealing ColdFusion 2021 – Rakshith Naresh
  • CF and Angular – Nolan Erck
  • Migrating legacy CFML – Nolan Erck
  • Adobe API manager – Brian Sappey
  • Improve your CFML code – Kai Koenig

CF Alive Best Practices Checklist

Modern ColdFusion development best practices that reduce stress, inefficiency, project lifecycle costs while simultaneously increasing project velocity and innovation.

Get your checklist

Top articles

  • CF Hosting (independent guide)
  • What is Adobe ColdFusion
  • Is Lucee CFML now better than ACF?
  • Is CF dead?
  • Learn CF (comprehensive list of resources)

Recent Posts

  • New Adobe CF Builder (VS Code extension) beta release
  • Into The Box 2022 (ColdFusion Development Conference)
  • 117 ACF and Lucee roundtable (Part 3 – future CFML) with Charlie Arehart, Gert Franz, Mark Drew and Ben Nadel
  • Adobe ColdFusion Developer Week 2022
  • CFCamp 2018 Announcements and Big Expectations

Categories

  • Adobe ColdFusion 11 and older
  • Adobe ColdFusion 2018
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion Developer week
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Projects
  • Adobe ColdFusion Security
  • Adobe ColdFusion Summit
  • Auto Security Lockdown
  • AWS
  • CF Alive
  • CF Alive Podcast
  • CF Camp
  • CF Tags
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFUnited
  • ColdBox
  • ColdFusion and Cold Depression
  • ColdFusion and other news
  • ColdFusion community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Maintenance
  • ColdFusion Roadmap
  • ColdFusion Security
  • ColdFusion Training
  • ColdFusion Webinar
  • CommandBox
  • Docker
  • Fixinator
  • Frameworks
  • Fusebox
  • FusionReactor
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn CFML
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Microsoft Azure
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Open- Source
  • Ortus Developer Week
  • Ortus Roadshow
  • Performance Tuning
  • Programming Languages
  • Server Crash
  • Server Software
  • Server Tuning
  • SQL
  • Survey
  • Survey results
  • TestBox
  • Transcript
  • Uncategorized
  • Webinar
  • Women in Tech
  • Home
  • Services
    • ColdFusion Consulting
    • ColdFusion Development
    • ColdFusion Maintenance
    • ColdFusion Security
  • About Us
  • CF Alive
    • CF Alive Book
    • CF Alive Inner Circle
    • CF Alive full resources cheatsheet
  • Blog
  • Podcast
    • Podcast Guest schedule
  • Contact
  • Sitemap

The ColdFusion Experts:
Develop, Secure, Optimize

TeraTech Inc
451 Hungerford Drive Suite 119
Rockville, MD 20850

Tel : +1 (301) 424 3903
Fax: +1 (301) 762 8185

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Pinterest Follow us on YouTube

Copyright © 1998–2022 TeraTech Inc. All rights Reserved.