qpScanner is a simple tool that scans your codebase looking for queries. For every query it finds, it will check if there are any CFML variables in that query that are not contained within a cfqueryparam tag.
Once complete, it will display a list of files with queries to be checked, listing the line numbers and showing the contents of the query.


Please see the main project page for full details:
http://www.hybridchill.com/projects/qpscanner.html


Planned features for future versions:
- ability to auto-insert cfqueryparams;
- integration with Apache Ant;
- integration with mxUnit;
- option to exclude directories;
- option to store/retrieve settings.

If you have any feature suggestions, please let me know using the Contact Project link above.


v0.7.1 (24-Sep-2008)
Fixed: IE check affecting ColdFusion didn't work.
Fixed: Win/CF expandPath fix, drive letter was case-sensitive.


v0.7 (23-Sep-2008)
Changed: Significantly faster processing.
Added: Multiple output formats.
Added: Ability to override Request Timeout.
Added: Option to specify file/directory exclusions.
Added: Option to include/exclude Query of Queries.
Added: Option to include/exclude built-in CFML functions.
Added: Eclipse Plugin for easier execution.


v0.6.1 (29-Apr-2008)
Fixed: Proper query names now display.
Added: Option to exclude ORDER BY clauses.
Added: Option to list scopes used.
Added: Option to highlight client scopes.
Fixed: Was giving false positives for cfswitch.


v0.5.2 (19-Apr-2008)
Fixed: Corrected \ to Server.Separator.File so qpScanner now also works on non-Windows machines.


v0.5.1 (17-Apr-2008)
Fixed: Was case-sensitive and found "cfquery" but not "CFQUERY". Is now case-insensitive.
Changed: Init->init in jre-utils. Enables BlueDragon support.

Running the QueryParam Scanner tool requires a Java-based CFMX-compatible CFML engine (uses CFCs and Java object).

Supported on:
- ColdFusion 8
- ColdFusion MX7
- BlueDragon 7
- Railo 3


NOTE: If your server is CF5 (or other unsupported), I recommend getting Railo Express in order to run the tool.


Uses three other open-source projects, jre-utils, jQuery and Fusebox, all included.

You may access this project's Subversion repository with your client here: http://svn.riaforge.org/qpScanner.

You may download the latest set of files from Subversion as a zip file.

Anonymous users have read access to the repository while the administrator has write access.

This project is sharing its code via Subversion. Subversion is an open source source control method. You may find more information about Subversion here: http://subversion.tigris.org/