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: > This the last thing I have to figure out. > > I've got this CF store finder application that does what it's suppose to do. > It takes > the zipcode and the radius and returned an order list of zipcodes sorted by > the > distance from the original zip code entered. The only problem is when I plug > this list of zip codes, into a query to extract a list of store locations, it > returns > the list of stores NOT in the same zipcode order, order by distance. > > Why aren't the stores being returned in the same order as the zipcodes > returned? > > My query to the stores database that is taking the zipcode ordered list sorted > by distance to the original zipcode entered of "01860" is ... > > > SELECT * > FROM dbo.tblstores > WHERE (Phone <> '') AND (lat IS NOT NULL) AND (long IS NOT NULL) AND > (active = 1) AND (zip IN (01860, 03858, 01985, 01913, 03865, 01830, 03827, > 01834, > 03848, 01950, 01922, 01832, 01835, 03826, 01833, 01952, > 03811, 03874, 03819, 03844, 01951, 03841, 01969, 03833, 01921, 03079, 03873, > 03842, > 01844, 01845, 01841, 01840, 03044, 01843, 01938, 03862, > 01983, 03885, 03042, 01810, 03036, 03087, 03038, 03840, 01949, 03077, 03857, > 01982, > 03076, 03870, 01984, 01864, 01929, 01923, 03053, 01826, > 01876, 01850, 03801, 01915, 01852, 03290, 03032, 03824, 01940, 01887, 01960, > 01854, > 03051, 01944, 03291, 03854, 03034, 01851, 01867, 03904, > 01930, 01970, 03109, 01862, 01966, 01821, 01880, 03903, 03905, 01879, 01863, > 03060, > 01904, 01945, 03103, 03037, 01824, 01803, 02180, 03820, > 01907, 01902, 03825, 03104, 01801, 01905, 01906, 03101, 03062, 01901, 03054, > 03063, > 02176, 03102, 03110, 01827, 03106, 01890, 01741, 03261, > 01886, 01730, 02148, 03909, 03869, 01908, 02151, 02173, 02155, 02149, 03908, > 03878, > 03049, 03884, 02174))
-- 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:305590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
