In my last blog posting I discussed the advantages of using MaxMind GeoIP to obtain a site visitors geographical location based on their IP. In this posting I will show you how to integrate GeoIP into your site using ColdFusion.

Early this year I wrote a blog article about using IP2Location to identify a users location and ISP based upon their IP. You can find the previous articles here: http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=1078 http://www.bpurcell.org/viewcontent.cfm?

I ran into a confusing issue with ColdFusion 8 that could affect users that install the enterprise version with the evaluation option and are using multiple instances. Here is what led up to this issue occuring for me Installed ColdFusion 8 as a multi server install with the evaluation option Created an additional instance of ColdFusion Entered in a valid serial number into the new instance that I had just created.

A new version of the MySQL driver has been released that detects ColdFusion when it is running with Coldfusion MX 7 (and 8). This should result in much better performance for CF/MySQL users.

This was something that I meant to write about a while ago but never got around to it. I recieved a question recently by email and wanted to provide some tips and tricks when using ISAPI Rewrite in a multi-tiered load balanced environment. I wrote an article with Frank DeRienzo several years ago about using a multi-tiered load balanced enviroment.

Most developers do not spend a lot of time reviewing logs so a lot of errors occur without ever knowing about them. If every error ends up in your inbox then you are forced to address them. I use a template similar to the one below for every site I have developed. <!--- Send an email with information about the error ---> <CFMAIL TO="youremail@host.com" FROM="error@site.com" SUBJECT="Error on http://#CGI.HTTP_HOST##CGI.SCRIPT_NAME#" TYPE="HTML"> A user experienced an error on #ERROR.

Although it has been quite a while since JRun 4.0 was released the next release is right around the corner. The JRun team has asked me to post the following message to find developers that are interested in test driving the next release of JRun. The beta release of next version of JRun appserver,  code named Cheetah, is available. Adobe JRun Team is inviting serious evaluators to give feedback on this beta release. Contact vrreddy@adobe.com to be included in the Beta program.

Steven Erat pointed this link out to me regarding ColdFusion MX and JVM Tuning Links.http://www.pixl8.co.uk/index.cfm/pcms/site.resources.cfmxtuning/ Here are a few others:http://devnulled.com/content/2005/09/coldfusion-mx-tuning-and-clustering-roundup/ Free stack trace utilityhttp://www.seefusion.com/seestack/seestack.

In a previous blog posting I discussed how to obtain a users geographical location based on their IP with IP2Location and ColdFusion. In this article I explain how to import the data, break the data into multiple tables for optimization, then create the UDF to perform the lookup. I have had several requests for the stored procedures used to break up the IP2Location data. I have posted them along with the CF code.

I recently was encountered with a problem where I needed to find what location a user was logging in from based on their IP. There were several reasons why such a system was needed that I highlight below.