Re: GeoIP for Coldfusion?
I know it won't be. I only plan on hitting it once per account in it's lifetime. :) On Sun, Dec 25, 2011 at 4:17 PM, Paul Hastings wrote: > > On 12/26/2011 2:44 AM, Phillip Vector wrote: >> >> Hrm.. The CSV's look feasible to use. Thanks. :) > > if you plan on using your db for this, might think again--performance won't be > all that good. the binary version performs better. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
On 12/26/2011 2:44 AM, Phillip Vector wrote: > > Hrm.. The CSV's look feasible to use. Thanks. :) if you plan on using your db for this, might think again--performance won't be all that good. the binary version performs better. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
Hrm.. The CSV's look feasible to use. Thanks. :) On Sun, Dec 25, 2011 at 10:54 AM, Donnie Bachan (Gmail) wrote: > > FYI, http://www.maxmind.com/app/geolitecity, best to check with them > about your particular use case to ensure you are good to use the free > version. > > Best Regards, > Donnie Bachan > "Nitendo Vinces - By Striving You Shall Conquer" > == > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > On Sun, Dec 25, 2011 at 4:18 PM, Phillip Vector > wrote: >> >> *nods* I was looking for city and state actually. >> >> and it would need to be free. I can't drop $370 on this. >> >> On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) >> wrote: >>> >>> Although this isn't a completely free solution we've used it with very >>> good success without any updates for a while now. >>> http://www.maxmind.com/app/geoip_features. If you are using it for >>> just country level access for $50 it's not a bad investment. >>> >>> I've included some code for accessing checking the IP, once you have >>> the database loaded. Please note that the java database is much, much >>> faster than using the data in a database table. >>> >>> >> output="false"> >>> >> type="string" /> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> (CGI.REMOTE_ADDR)> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> isNumeric(aIPParts[1]) and >>> isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and >>> isNumeric(aIPParts[4])> >>> >> (aIPParts[2] * (256^2)) >>> + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> >>> >> datasource="#getDatasource()#"> >>> SELECT TOP 1 country FROM GeoIP >>> WHERE >>> CAST(#iIPNum# AS bigint) between >>> CAST(begin_num AS bigint) and >>> CAST(end_num AS bigint) >>> >>> >>> >>> >> datasource="#getDatasource()#"> >>> SELECT * FROM >>> countryBlacklist >>> WHERE country = >>> >> value="#getIP.country#" /> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Hope this helps. >>> >>> Best Regards, >>> Donnie Bachan >>> "Nitendo Vinces - By Striving You Shall Conquer" >>> == >>> The information transmitted is intended only for the person or entity to >>> which it is addressed and may contain confidential and/or privileged >>> material. Any review, retransmission, dissemination or other use of, or >>> taking of any action in reliance upon, this information by persons or >>> entities other than the intended recipient is prohibited. If you received >>> this in error, please contact the sender and delete the material from any >>> computer. >>> >>> >>> >>> On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector >>> wrote: Is there a server side solution for GeoIP that I can use? I'd like to make ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
FYI, http://www.maxmind.com/app/geolitecity, best to check with them about your particular use case to ensure you are good to use the free version. Best Regards, Donnie Bachan "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Sun, Dec 25, 2011 at 4:18 PM, Phillip Vector wrote: > > *nods* I was looking for city and state actually. > > and it would need to be free. I can't drop $370 on this. > > On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) > wrote: >> >> Although this isn't a completely free solution we've used it with very >> good success without any updates for a while now. >> http://www.maxmind.com/app/geoip_features. If you are using it for >> just country level access for $50 it's not a bad investment. >> >> I've included some code for accessing checking the IP, once you have >> the database loaded. Please note that the java database is much, much >> faster than using the data in a database table. >> >> > output="false"> >> > type="string" /> >> >> >> >> >> >> >> >> >> >> >> > (CGI.REMOTE_ADDR)> >> >> >> >> >> >> >> >> >> >> > isNumeric(aIPParts[1]) and >> isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and >> isNumeric(aIPParts[4])> >> > (aIPParts[2] * (256^2)) >> + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> >> > datasource="#getDatasource()#"> >> SELECT TOP 1 country FROM GeoIP >> WHERE >> CAST(#iIPNum# AS bigint) between >> CAST(begin_num AS bigint) and >> CAST(end_num AS bigint) >> >> >> >> > datasource="#getDatasource()#"> >> SELECT * FROM countryBlacklist >> WHERE country = > cfsqltype="cf_sql_varchar" >> value="#getIP.country#" /> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope this helps. >> >> Best Regards, >> Donnie Bachan >> "Nitendo Vinces - By Striving You Shall Conquer" >> == >> The information transmitted is intended only for the person or entity to >> which it is addressed and may contain confidential and/or privileged >> material. Any review, retransmission, dissemination or other use of, or >> taking of any action in reliance upon, this information by persons or >> entities other than the intended recipient is prohibited. If you received >> this in error, please contact the sender and delete the material from any >> computer. >> >> >> >> On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector >> wrote: >>> >>> Is there a server side solution for GeoIP that I can use? I'd like to >>> make up some CF code that can detect when sites are connecting in >>> area ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
*nods* I was looking for city and state actually. and it would need to be free. I can't drop $370 on this. On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) wrote: > > Although this isn't a completely free solution we've used it with very > good success without any updates for a while now. > http://www.maxmind.com/app/geoip_features. If you are using it for > just country level access for $50 it's not a bad investment. > > I've included some code for accessing checking the IP, once you have > the database loaded. Please note that the java database is much, much > faster than using the data in a database table. > > output="false"> > type="string" /> > > > > > > > > > > > (CGI.REMOTE_ADDR)> > > > > > > > > > > isNumeric(aIPParts[1]) and > isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and > isNumeric(aIPParts[4])> > (aIPParts[2] * (256^2)) > + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> > datasource="#getDatasource()#"> > SELECT TOP 1 country FROM GeoIP > WHERE > CAST(#iIPNum# AS bigint) between > CAST(begin_num AS bigint) and > CAST(end_num AS bigint) > > > > datasource="#getDatasource()#"> > SELECT * FROM countryBlacklist > WHERE country = cfsqltype="cf_sql_varchar" > value="#getIP.country#" /> > > > > > > > > > > > > > > Hope this helps. > > Best Regards, > Donnie Bachan > "Nitendo Vinces - By Striving You Shall Conquer" > == > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector > wrote: >> >> Is there a server side solution for GeoIP that I can use? I'd like to >> make up some CF code that can detect when sites are connecting in >> areas we don't serve and direct them to a different page. Is there any >> (f ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
Although this isn't a completely free solution we've used it with very good success without any updates for a while now. http://www.maxmind.com/app/geoip_features. If you are using it for just country level access for $50 it's not a bad investment. I've included some code for accessing checking the IP, once you have the database loaded. Please note that the java database is much, much faster than using the data in a database table. SELECT TOP 1 country FROM GeoIP WHERE CAST(#iIPNum# AS bigint) between CAST(begin_num AS bigint) and CAST(end_num AS bigint) SELECT * FROM countryBlacklist WHERE country = Hope this helps. Best Regards, Donnie Bachan "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector wrote: > > Is there a server side solution for GeoIP that I can use? I'd like to > make up some CF code that can detect when sites are connecting in > areas we don't serve and direct them to a different page. Is there any > (free) solutions for ColdFusion to detect where an IP is located? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
GeoIP for Coldfusion?
Is there a server side solution for GeoIP that I can use? I'd like to make up some CF code that can detect when sites are connecting in areas we don't serve and direct them to a different page. Is there any (free) solutions for ColdFusion to detect where an IP is located? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
