100% Geek
The Adventures of Peter Boughton:
Web Development; OSX; Photography.
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 by Peter on 06-April-2008 at 17:42 ~ Category: cfml , projects
Comments
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. :)
jc @ 10:22 22-July-2008
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.
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.
Peter @ 12:48 22-July-2008
![[White Apple logo][Text: Made on a Mac]](http://blog.bpsite.net/madeonamac.png "Made on a Mac")
![[Blue RSS logo]](http://blog.bpsite.net/rss.png "RSS Feed"){kind=small}