Hi Dan I found your code examples just after posting the last message and then just used your php file as an example to copy from. I added the 31348 towns to the file and it is about 694 KB but seems to run ok. so should be able to stay with that. I just now have to work on the style sheet to make it return the results in some nice colours.
On 4/19/07, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > > > James, > > >Hi Dan I did try doing this in cold fusion but it looks like there is a > >limit on how big your script can be as it gets turned in to a class file. > > I've run into some huge CF templates and never had a problem, but I can't > for the life of me understand why you'd have a large CF template. You > template only needs to be a few lines: > > <cfsilent> > <cfparam name="url.q" type="string" /> > <cfquery name="getResults"> > select > column1, column2, column3 > from > table > where > column1 like <cfqueryparam type="cf_sql_varchar" value="#url.q#%" > /> > </cfquery> > </cfsilent><cfoutput query="getResults">#column1#|#column2#|#column3# > </cfoutput> > > That's basically all you need. Very simple stuff. There's absolute no > reason > you should be using any kind of hard code data. > > -Dan > > > > >
