How do I interact with queries in FusionDebug?

The best way to show how easy it is to debug your queries with FusionDebug is to give you a quick example. Lets start by putting the following code in a file, setting a breakpoint and then running it:

As you can see it's a very simple page which just grabs some information from a database and then outputs it. If you step through upto the cfloop command then you will see the following information in the variables view:

By opening the query object you'll be able to see all of the column names and data types. You will also see each of the rows returned and the data within. As well as having access to this query object as you debug, FusionDebug also gives you the Current Query object. Step past the cfloop tag and your variables view should change to something like this:

As you can see, the Current Query object shows you exactly what row you are on and what data is held within it. Additionally, if you look back at the query object, a marker has been placed to show which row is currently active.