RE: cfquery results - related question

2013-01-07 Thread Stephens, Larry V
A related question: I have a table of towns that has ~20,000 records. The dataset I need has the record ID, town name, a memo field (usually empty), and fields holding an index into other tables (township, county, state, country). In my form I have a select field to pick the town. I don't want

Re: cfquery results - related question

2013-01-07 Thread Russ Michaels
list of towns is not really a huge query, just do it once and cache and then do a query of query for your auto complete. On Mon, Jan 7, 2013 at 2:06 PM, Stephens, Larry V steph...@iu.edu wrote: A related question: I have a table of towns that has ~20,000 records. The dataset I need has the