many thanks - much help.
seamus
At 11:22 am 9/03/01 , you wrote:
>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
