I have two tables. The first table is the zip code table. Once I find the zipcodes that fall within the milage radius input, I take the list of zipcodes and seatch against my store table. I'm trying to figure out how to get the results from my store database to be in the same order by the zipcode's distance to the orignal zip code entered. In my sample is was 01860.
Thanks >I can't see any ordering in that query; there's no order by clause. > >On Mon, May 19, 2008 at 11:21 AM, <[EMAIL PROTECTED]> wrote: > > >-- >mxAjax / CFAjax docs and other useful articles: >http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
