All, Any familiar with the ZipMonger CFC?
I've got this great store finder all setup with GoogleMaps integration and I'm
running into a slight problem.
In certain instances, surrounding town zip code are not showing up. Tracking
down one mising zip code down, showed that it's in my zip code database, it's
in the store database, but the CFC isn't including it within the list of zip
codes returned.
What's strange is when Imenaully query the store database for the following
query, I still get stores that have no zip code value and some lats and longs
that are NULL. Could my database be corrupted?
SELECT *
FROM dbo.tblStores
WHERE (lat IS NOT NULL) OR
(long IS NOT NULL) OR
(Zip <> '')
Here are my zipmonger settings and the query to the store database.
<cf_zipmonger
DataSource="#datasource#"
ZipTable="zipcode"
ZipCodeField="zipcode"
ZIPQueryParam="CF_SQL_VARCHAR"
OriginZipCode="#form.ZIPInput#"
Radius="#form.ZIPRadius#"
LatitudeField="Lat"
LongitudeField="Long"
MaxRadius="9">
<cfquery name="get_stores" datasource="#datasource#">
select *
from dbo.tblStores
where active = 1 AND zip IN (
<cfqueryparam value="#Variables.ReturnedZIPS#"
cfsqltype="cf_sql_integer" list="yes" />)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:303738
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
