100% Geek

QueryParam Scanner

The code for my QueryParam Scanner has been uploaded to RIAForge.

QueryParam Scanner is a simple tool which scans your code for queries and reports back about any variables that are not inside <cfqueryparam/> tags.

Download QueryParam Scanner from RIAForge.

Posted:
06 April 2008, 17:42
Tags:
CFML
Projects

There have been 2 comments.

jc @ 2008-Jul-22 10:22
How about a version 2.0 that uses the CFDBinfo to see what the referenced field is and write the basic cfqueryparam tag for it? Wouldn't be perfect, but it would definitely speed things up in the battle against legacy code. :)
Peter @ 2008-Jul-22 12:48
Yeah I was thinking of something like that - I've had someone mention that they used it on a large app, but when they tested their app with the cfqueryparams added, they found several bugs where the developers had left single quotes and so on.

I was thinking of an extra page that allowed specifying the types to use, then simply added the tag for them - slightly more manual, but wouldn't need CF8 nor access to datasources, so I'd probably start with that then maybe make it smarter later.
Registered Members
If unregistered, leave blank.
If unregistered, leave blank.
Unregistered Guests
Identifies your comment
Not displayed publically. Allows new comment notifications, or for the blog owner to contact you.
Link your name back to your personal website.
Comment