Thank you. This is helpful. but I'm still stumped and it's the last thing I
have to fix for this Store locator with a Google Maps mashup.
But If I'm feeding results from a zipcode query as a subquery into a store
query, how do I get the results from the store query to sort the store results
by the zipcode distance when the zipcode query is the subquery? Make sense?
Here's the two queries.
SEARCH THE STORE DATABASE WITH THE ZIPCODE QUERY RESULTS
<cfquery name="get_stores" datasource="#datasource#">
select *
from dbo.tblStores
where phone <> '' AND lat IS NOT NULL AND long IS NOT NULL AND active = 1 AND
zip IN (
<cfqueryparam value="#zipquery.zipcodes#" cfsqltype="cf_sql_char"
list="yes" />)
</cfquery>
GET THE ZIPCODES BASED ON THE RADIUS AND ZIPCODE ENTERED BY USER
select zip, state, city,
SQRT(
SQUARE(#lat_miles# * (latitude - (#z1.latitude#)))
+
square(#lon_miles# * (longitude - (#z1.longitude#)))
) as dist
from zip
where
latitude between #lat1# AND #lat2#
AND
longitude between #lon1# AND #lon2#
order by dist asc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305767
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
