Exploring ColdFusion InputBaseN() And FormatBaseN() Functions

Posted August 8, 2007 at 2:33 PM

Tags: ColdFusion

As part of my ColdFusion calendar system, I got into fooling around with some colors. I didn't end up going in that particular direction, but it got me messing around with both the ColdFusion functions, InputBaseN() and FormatBaseN(), neither of which I had ever used before. They do very simple but very powerful calculations for you.

InputBaseN( strValue, intRadix ) - This takes a numeric value and the radix that defines the numeric value and converts it to our standard base 10 format.

FormatBaseN( strValue, intRadix ) - This takes a base 10 value (what we use all the time) and converts it to a number with the given radix.

Using the ColdFusion InputBaseN() function, we can easily do things like convert HEX (hexadecimal) color values to RGB (red-green-blue) decimal values:

 Launch code in new window » Download code as text file »

  • <!--- Start out with a base HEX web color. --->
  • <cfset strHEX = "FFCC00" />
  •  
  • <!---
  • Get the red, green, and blue parts (each two
  • characters of the given HEX value).
  • --->
  • <cfset strRed = Mid( strHEX, 1, 2 ) />
  • <cfset strGreen = Mid( strHEX, 3, 2 ) />
  • <cfset strBlue = Mid( strHEX, 5, 2 ) />
  •  
  • <!---
  • Convert the HEX colors to RGB decimal colors
  • where 0x00 = 00 and 0xFF = 255. HEX is base
  • 16 and we want to convert to base 10 (our
  • standard number system).
  • --->
  • Red : #strRed# : #InputBaseN( strRed, 16 )#<br />
  • Green : #strGreen# : #InputBaseN( strGreen, 16 )#<br />
  • Blue : #strBlue# : #InputBaseN( strBlue, 16 )#<br />

Running the above code, we get the following output:

Red : FF : 255
Green : CC : 204
Blue : 00 : 0

We can also easily convert bit/binary values to decimal:

 Launch code in new window » Download code as text file »

  • <!--- Loop over BIT values. --->
  • <cfloop
  • index="strBits"
  • list="0:1:10:11:100:110:111:1000:1100:1110:1111"
  • delimiters=":">
  •  
  • <!---
  • Convert the bits to integers. Bits are in
  • base 2 and we are converting to base 10 (our
  • standard number system).
  • --->
  • #strBits# : #InputBaseN( strBits, 2 )#<br />
  •  
  • </cfloop>

Running the above code, we get the following output:

0 : 0
1 : 1
10 : 2
11 : 3
100 : 4
110 : 6
111 : 7
1000 : 8
1100 : 12
1110 : 14
1111 : 15

Pretty easy stuff! And, as easy as that is, ColdFusion's FormatBaseN() function makes it just as easy to go the other way, such as converting RGB values to HEX values. The only thing that complicates this conversion is that we need a 6-digit HEX value (at least if you are cool, you do), and there is nothing about FormatBaseN() that enforces this. So, in addition to actually changing the base radix, we also need to check the value lengths:

 Launch code in new window » Download code as text file »

  • <!--- Set up our basic Red/Green/Blue color values. --->
  • <cfset intRed = 255 />
  • <cfset intGreen = 14 />
  • <cfset intBlue = 128 />
  •  
  • <!---
  • Now, we can create HEX numbers using RGB values. When
  • creating the colors, things are little more complicated
  • because we need a 6 digit value, but simply converting
  • base 10 to hex might not give us two digit values for
  • each color.
  • --->
  • <cfset strRed = FormatBaseN( intRed, 16 ) />
  • <cfset strGreen = FormatBaseN( intGreen, 16 ) />
  • <cfset strBlue = FormatBaseN( intBlue, 16 ) />
  •  
  • <!--- Now, make sure they have two digits. --->
  • <cfif (Len( strRed ) EQ 1)>
  • <cfset strRed = ("0" & strRed) />
  • </cfif>
  • <cfif (Len( strGreen ) EQ 1)>
  • <cfset strGreen = ("0" & strGreen) />
  • </cfif>
  • <cfif (Len( strBlue ) EQ 1)>
  • <cfset strBlue = ("0" & strBlue) />
  • </cfif>
  •  
  • <!--- Combine the RGB HEX values to get the color HEX. --->
  • <cfset strHEX = UCase(
  • strRed &
  • strGreen &
  • strBlue
  • ) />
  •  
  • <!--- Output HEX value. --->
  • #strHEX#

Running the above code, we get the following output:

FF0E80

So anyway, I didn't end up using these yet, but it's great to know that this functionality exists. If it didn't, I would probably have to end up doing manual multiplication and division and stuff - certainly not something we should be wasting our times on.

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page





Reader Comments

Aug 9, 2007 at 7:44 AM // reply »
1 Comments

Thank you for the code, I will see what it can bring to me


Aug 13, 2007 at 1:05 PM // reply »
4 Comments

Very nice! This will help me when converting colors in some server-side font and image manipulation tools I use that require decimal color values. I know a lot of hex color values by heart, but not many equivalent decimal values.


Aug 13, 2007 at 1:23 PM // reply »
7,539 Comments

Glad to help in some way :)


P
Nov 16, 2007 at 11:05 AM // reply »
1 Comments

Thank you for sharing.


Aug 28, 2008 at 3:50 PM // reply »
2 Comments

I am using InputBaseN to convert IP addresses to decimal (dotted-decimal to binary to decimal); it works for lower-numbered addresses (such as 10.0.0.0), but returns a negative number for higher-numbered addresses (such as 192.0.0.0). It seems its treating the variable like a signed int? Any ideas?


Aug 28, 2008 at 3:57 PM // reply »
7,539 Comments

@Tom,

How are you going from dotted-decimal to binary. I am not even sure what that would do?


Aug 28, 2008 at 4:28 PM // reply »
2 Comments

It's for an application that maps a specific user login to one or a range of network addresses. This permits assignment of a "default account" to workstations per the logical/physical network on which they reside (e.g. different campus locations). I convert to decimal to make the comparison to configured network address ranges mathematically simple. All dotted-decimal IP addresses are fundamentally decimal numbers; dotted decimal is a rather arbitrary notation, but it makes network classification, routing, subnet and supernet masking possible.

The process is convert each portion of the dotted-decimal IP address (from CGI variable) to binary, pad the binary to 8 chars where needed (the second, third and forth values need to be 8 chars), concatenate the result (creating the binary equivalent of the dotted-decimal) then convert to decimal.

When the first decimal is small e.g. 10.x.x.x (usually used for internal private networks), InputBaseN works fine - when the first decimal number is large e.g. 192.x.x.x (also used for internal private networks) or 169.x.x.x (Microsoft private assigned in absence of DHCP) the decimal value returned is negative.


Aug 28, 2008 at 4:38 PM // reply »
7,539 Comments

@Tom,

Ok, I see what you are trying to do. I would check with Michael Dinowitz over on www.blogoffusion.com. He often converts IP addresses to integers for database storage (I believe). I think he will be able to give you better advice than I can.


Mar 27, 2009 at 12:57 PM // reply »
7 Comments

Ben,

I have the same requirement as Tom where I would like to take a IP address from a Nigeria spammer 212.100.69.11 and convert it to binary so I can look it up in a database table I got from http://www.maxmind.com/app/geolitecountry

I could not locate anything on Michael Dinowitz site, i think there is something wrong with it.

Dave


Jan 14, 2010 at 4:02 PM // reply »
2 Comments

Dave, I know this is now 2010, but in case you or anyone else is still wondering, the MaxMind database you're talking about stores its IP address in decimal format to support faster lookups.

The way they do it is this:

Take an IP address - e.g. 1.2.3.4

The numerical representation for the IP is:

(1 * 256 * 256 * 256) + (2 * 256 * 256) + (3 * 256) + 4

This will give you a maximum of a 10-digit number.

This makes it easier to match an IP address against a range, just by using BETWEEN in SQL.


Jan 14, 2010 at 4:07 PM // reply »
7 Comments

Erich,

Thanks for the heads up, I am using the MaxMind database and it is working great - I love that they are giving it away for free.

I have an example page here:
http://www.pickrent.com/misc/geoip.cfm

Dave


Jan 16, 2010 at 4:34 PM // reply »
7,539 Comments

@Dave, @Erich,

I'm still not great on bit-wise manipulation; but, is the multiples of 256 basically a mathematical way to perform bit-shifting?


Jan 20, 2010 at 6:13 AM // reply »
3 Comments

@Ben: yes, however coldfusion bit shifting operate on signed integer, which is not good for this operation.

@Tom: Personnally i use the following to convert from dotted decimal to decimal:

<cfset ipdec = 0>
<cfloop list="#ip_source#" delimiters="." index="i">
<cfset ipdec=ipdec*256 + i>
</cfloop>


Jan 20, 2010 at 11:01 PM // reply »
7,539 Comments

@Silmaril,

Ok, cool, I see what you're doing now.


Jan 26, 2010 at 12:04 PM // reply »
3 Comments

I found this to be very interesting and quite useful for some IP stuff I need to work on, but forgive me for asking...

In the example by Silmaril, using 216.201.6.99 as an example IP, how do I convert 3637053027 backwards to the original IP?


Jan 26, 2010 at 12:17 PM // reply »
7 Comments

Frank, I would be glad to show the code I am using but I can't post it here in the comments.


Jan 26, 2010 at 1:05 PM // reply »
3 Comments

@Dave,

I have a few old isp e-mails that I can throw out that are generally safe if you want to share the code, or you're welcome to toss me a link to a "hidden" page with the code displayed if that's your choice. Either works.

Feel free to try phobos[at]bright[dot]net

I'd be appreciative!


Jan 26, 2010 at 2:21 PM // reply »
7 Comments

I just sent you an email with my code.


Jan 26, 2010 at 9:11 PM // reply »
7,539 Comments

@Frank, @Dave,

I know you guys already covered this, but I took this as an opportunity to practice my bit-manipulation skills (thinking in Bits is still shaky for me).

http://www.bennadel.com/blog/1830-Converting-IP-Addresses-To-And-From-Integer-Values-With-ColdFusion.htm

Thanks for the inspiration!


Jan 27, 2010 at 12:14 AM // reply »
7 Comments

I just copied the code I got off the maxmind site and made it my own, Ben you have taken it much farther than that it appears.


Jan 27, 2010 at 8:58 AM // reply »
3 Comments

Fantastic, and thanks to both of you!


Feb 3, 2010 at 7:38 PM // reply »
2 Comments

Dave & Frank, I'd also like to see what you've come up with. How about CC'ing me on the same?

erichc[at]eonflex[dot]com

Thanks!


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 18, 2010 at 5:35 PM
Exploring ColdFusion Component Runtime Class Properties And Serialization
Saving private properties is necessary so that you can "reconstitute" an object on the other side of the wire, or load up a serialized object you saved to disk. If it didn't save the private state o ... read »
Mar 18, 2010 at 4:04 PM
jQuery's Event Triggering, Order Of Default Behavior, And triggerHandler()
Tks! You saved-me today. it can be chained into one statement: $("#x).attr("checked","checked").triggerHandler('click'); ... read »
Mar 18, 2010 at 1:18 PM
Finally Finished Ayn Rand's Atlas Shrugged Audio Book
@joaopft, Not disputing what you say - but... If I understand you correctly, you are saying that Positivism is based on sense experience (what I experience is what is), but Quantum theory states tha ... read »
Mar 18, 2010 at 11:48 AM
Duplicate() Much Faster Than ColdFusion Query-of-Queries
I am working on a massive xml parsing, qofq app to create 2 seperate xml files. I just don't understand the concept/purpose of duplicate function, are you duplicating the data or the row, into a new ... read »
Mar 18, 2010 at 11:22 AM
Exploring ColdFusion Component Runtime Class Properties And Serialization
@Zarko, Ha ha, you know ColdFusion is my first love ;) ... read »
Mar 18, 2010 at 11:15 AM
Exploring ColdFusion Component Runtime Class Properties And Serialization
Hi Ben, nice to have you back! I already gave up on you, thinking you'll write about jQuery and iPhone for the rest our our lives! :) ... read »
Mar 18, 2010 at 10:36 AM
Ask Ben: Javascript Replace And Multiple Lines / Line Breaks
@Ben Nadel, Hey Ben, thanks for you're response. It works!! However.. if you could please kindly look at http://edeals.zzl.org/divchange2.php where I am trying it out you will see that with the " ... read »
Mar 18, 2010 at 9:56 AM
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
This works too. I learned this trick a long time ago and it's really powerful for flags. SELECT g.hair , COUNT(*) AS girl_count , sum(did_date) AS did_date_count , sum(abs(did_date - 1)) AS did_ ... read »