I do both (ha!). Seriously, my general rule is to put generalized queries
(getUsersList or such) in index.cfm, and to put what I call "close-tied"
queries (pick lists for forms, queries dependent on module variables) in the
module files. Generalized queries tend to be more shareable, so makes sense to
have them visibly exposed for reference in index.cfm, and close-tied queries
rarely have shareable natures, so it makes sense to have them tucked into the
module.
This approach grew out of my tinkering quite some time ago with a frm module
type, which contained all the guts necessary to process a screen form, somewhat
analogous to Access form objects. It was a nice idea, but became rather
ungainly in full implementation, so I stripped it down to keeping just a few
bits that seemed to fit well with the existing module types.
- Jeff
On 9 Apr 2001, at 8:18, Hal Helms wrote:
> Folks,
>
> Question on how you handle queries: Some people always include query files
> in other files, like this in actDoSomething.cfm:
==============================================================
| Jeffrey S. Peters | "Specialization is for insects." |
| [EMAIL PROTECTED] | - Lazarus Long |
| PGP key for Jeffrey S. Peters at ldap://keyserver.pgp.com |
==============================================================
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
