At 08:26 AM 3/9/01 +1100, you wrote:
>This is maybe slightly off-topic and possibly a dumb question, but
There are no dumb questions.
>with a long list which rarely changes (such as zip codes)
>
>1. is it better, quicker to have them as a list rather than a query, say
>in a drop-down box in a form.
A short list, like states, is better as a list because the program can read
the entire list in less time than it could do a database read. A list of
zip codes, however, which is massive, is much better in a relational table,
especially since you're usually only returning one record on the zip code
match and the query into the relational table would be much faster than
searching the entire list sequentially.
>2. Is it good practice to have it as a query in an application.cfm (server
>or application scope)
I don't see any benefit from carrying a variable of this size around thru
the whole app. Just include or query at the point in the code where you
need it.
>3. if a list is good practice how do you set this up and then access it later
>
>or is there a better way altogether
See above.
Judith Campbell
Chief Technical Officer
Digital Positions, Inc.
[EMAIL PROTECTED]
404-351-9366
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists