Convert IPs to Integers
More fun with IPs, this time converting them to integers.Convert IPs to Binary
I'm working on some SQL to search for data based on IPs and IP Ranges. Doing this with character data in the database is horrendous. When searching through millions of records using JOINs with LIKE comparisons, the performance is completely unacceptable. So I'm working on converting the IP addresses to Binary format to do some (hopefully) faster searching. I have all of the SQL code to do this, which I'll post a little later with some performance benchmarks, but first some ColdFusion code to deal with display and conversion of IP addresses to and from binary. If you use the code, please let me know if it works out for you, and look for a further post on making use of this in SQL Server. So, without further ado, here's the function:Error when Upgrading to CF9
I finished the installation of our new CF9 license with just one hiccough along the way. I installed CF9 next to CF8 so that we can move clients over to the new CF9 server one at a time and test as we go. After the file installation is finished, CF9 opens the migration wizard to allow you to bring over all of your old CF8 settings. During this process I got the a monstrous cfdump with the following error:
Server Monitoring And API is not available in this edition of ColdFusion server.
A quick Google search didn't return any relevant results, but a quick email to the CF team got a me a link to a Knowledge Base article with the answer. I replaced the two CF8 migration templates with the ones provided from teh article, went back to the CFAdmin, and everything finished without a hitch.
0 comments | Posted by Daniel Short on Nov 24, 2009 at 10:49 AM | Categories:
ColdFusion -