On 3/16/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > So, it was a select * into app scope?
Well.. not TOTALLY... certain "codes" in the table have multiple values.. but for the most part we don't care about the multiple values... so I only used the first value... table id (code type), table key (code), code value Our mainframe application stores *ALL* of its codes in this single code table. You can see an example of the data at www.it.dev.duke.edu/tools/codebook I built a flex app for looking up codes =) All over the web site, I have dropdown lists populated by these codes... they used to be based off a query of queries, and the base query was stored in the application scope... now they just query the db directly. Rick -- > CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! > http://www.cfmbb.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272793 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
