Documentation

[lunatasha]

:moon;

I inheirited a mess of CFM pages. I have been asked to document then, what
databases/tables they access and what other webpages they use. Other than the
old OPEN/READ technique, any better ideas. Please someone tell me there is a
useful software or feature. I have CF5.0 Studio.

Kat

[jdeline]

You may have to write a couple of CF seripts to help yourself out. One script
would read each .CFM file and look for "<CFQUERY". Then scrape the table names
from the SELECT, INSERT INTO, UPDATE and DELETE. Of course, there are
complications if the table names are dynamic. :-(

The second script could read each .CFM file and look for <FORM...> and
<CFLOCATION ...>. Make a list of each filename you find in these tags.

[lunatasha]

I do not think I have ever done anything like that. Can you push me in the right CODE direction please.

[jdeline]

1. Do a <CFDIRECTORY>, filtering on .CFM file extention
([url]http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags14.htm#1097918[/url]
)

2. Loop through all the files:
a) read a file into a local variable "filename"
b) doing a <CFSET pointer = FindNoCase("<SELECT", filename)>
c) if found, do a FindNoCase("FROM", filename, pointer)
d) you are now positioned next to the table name
e) repeat b, c and d until no more SELECTs are found
f) repeat b, c and d for UPDATE, INSERT INTO and DELETE.