I've been a coldfusion developer for over 9 years now, and tinkered with web design for at least 12. It's pretty rare for me to find something I've never used before and didn't know existed in HTML… but today, I did.

The OPTGROUP tag is how you make non-selectable headings in select lists. I guess for some reason I always assumed that was done with javascript or CSS, but no, it's a simple tag.

In case I ever need it again, this is the CSS to force a "proper" ordered list hierarchy all the way to 6 layers deep. (pro tip – if it's 6 layers deep, you're doing something wrong)

<style type="text/css">
  OL { list-style-type:upper-roman }
  OL OL { list-style-type:upper-alpha }
  OL OL OL { list-style-type:decimal }
  OL OL OL OL { list-style-type:lower-roman }
  OL OL OL OL OL { list-style-type:lower-alpha }
  OL OL OL OL OL OL { list-style-type:lower-greek }
</style>

Oddly, hunting for a house and buying one is a bit time consuming.

All in all, I looked at about a dozen homes before deciding on one. It's a 105 year old Queen Anne, a couple blocks from the river. I moved in a month or so ago and I'm still not completely settled in. It's about 2200 finished square feet, technically 4 bedrooms 1.75 baths (but one bedroom is set up as a laundry room and I'm using another as an office). There's also a great third floor/attic that's finishable (and big enough that I could probably add a loft to it), and a 450 square foot 1 bedroom/1 bathroom "mother-in-law suite" over the "carriage house", which I'm renting to a ND divinity student. On one side of the house is the neighborhood association building. On the other side — a pair of nuns. Across…  a street that leads straight down to the river.  Behind, the 2 car "carriage house", and an alley, and a couple of houses that are currently being restored by the neighborhood association. So overall a pretty quiet location, if you ignore that the street is a fairly busy one and the hospital's less than a mile away. Big yard for being in such an old section of town. I've been here almost a month now. Enjoying it thus far. We'll see how it goes :)

And now, back to the regularly scheduled neglect of blog.

I have no idea why this information was so difficult to find, but I'm posting it here in case I ever need it again.

To do a reverse lookup in coldfusion:

<cfscript>
rawIP = createObject("java", "java.net.InetAddress").getByName('#ipaddress#').getAddress();
hostname = createObject("java", "java.net.InetAddress").getByAddress('#rawIP#').getHostName();
chostname = createObject("java", "java.net.InetAddress").getByAddress('#rawIP#').getCanonicalHostName();
</cfscript>

Note — this is slow. If you're doing them in bulk, you may need to go in small batches or set a higher timeout.

Also, this was perhaps useful: http://api.hostip.info/get_html.php?ip=#ipaddress#&position=true — returns the country, city, state, and geotag info for an IP address, where available.

Assumption: table named locations that has a location name and the location's latitude & longitude as a single field, with lat and lon comma separated, both in signed degrees format.

This is an intentional cartesian join… so if you have a lot of locations, use with care.

<cfquery datasource="MyDSN" name="getDist">
SELECT DISTINCT   
    a.latlon AS thestart,
    a.locName AS startname,
    b.latlon AS theend,
    b.locName AS endname
FROM     locations a
CROSS JOIN    locations b
WHERE     a.locName<> b.locName
ORDER BY     a.locName, b.locName
</cfquery>

<cfoutput query="getDist" group="startname">
<h4>#getDist.startname# to…</h4>
<ul><cfoutput>
<li>#getDist.endname# — #3963.0*acos(sin(listfirst(thestart)/57.295779513082323)*sin(listfirst(theend) / 57.295779513082323)+ cos(listfirst(thestart) / 57.295779513082323)*cos(listfirst(theend) / 57.295779513082323)*cos((listlast(theend) – listlast(thestart)) / 57.295779513082323))# Miles
</li>
</cfoutput>
</ul>
</cfoutput>

———————

This is based on a snippet of SQL code someone forwarded to me which was signed "RBarryYoung, 31-Jan-2009″ — so credit to RBarryYoung for it. :)

An interesting tidbit of information: If you create a cartogram of the United States, by county, based on the number of voters in the 2008 presidential election, and then shade each county red/blue based on the percentage of mccain/obama votes, it comes out looking strangely beautiful, like a purple bird in flight.

At the risk of sounding overdramatic, after 7 years in chains, hope now flies — on purple wings.

I'm really getting tired of seeing this guy… I made the graphic for IT security, but I wasn't expecting them to filter firefox, too….

in the name of love?

Some modifications to the vacation plans

Thursday night — Park & Fly package at a hotel by the airport in chicago, dinner at the Woodfield Mall.

Friday — Fly to PR, pick up rental car (Jeep Wrangler), check in to Da House and explore Old San Juan.

Saturday Morning — El Yunque Rain Forest

Saturday Afternoon — Flight from Fajardo to Vieques (Air Flamenco, who actually answers the phone…), check in to Casa de Amistad.

Saturday Evening — Biobay tour with Island Adventures.

Sunday Morning — Rent a car from Martineau Car Rental and check out the island. No specific plans.

Sunday Evening — Sunset from a beach (Probably the west end of Starfish beach) or possibly a second biobay tour.

Monday Morning — Return car, Flight from Vieques to Fajardo, board the Erin go Bragh III for a day of snorkeling and sailing.

Monday Evening — Return to San Juan, check in to the Caleta Guest House's Jungle Room.

Tuesday Morning — check out any of the San Juan stuff we haven't done yet.

Tuesday Afternoon — Arecibo Observatory and the Caguana Ceremonial Ball Courts, then check in to the Casa Grande

Wednesday — Breakfast, Yoga, a bit of a rest, then the ferry around Lago dos Bogas (Youtube link) and lunch at one of the cantinas there. Then back to the casa for some rest (and maybe a side trip if we missed anything on tuesday)

Thursday — Breakfast, Yoga, then a trip to Ponce for the day. We'll visit the Tibes indian site, the coffee plantation, Seralles Castle, and maybe the art museum, as well as some shopping. Then back to the Casa for dinner & relaxation.

Friday — Breakfast, Yoga, and a day of complete relaxation.

Saturday — Breakfast, Yoga, and back to San Juan… maybe visit something on the way there since our flight isn't til 2pm.

Going back to PR again this year! Here's the current outline of the vacation plans… subject to change.

Here's the map.

Arriving Friday afternoon, staying Friday night in "Da House", a sort of bohemian artsy place on top of a popular nightclub, packed full of art by local artists.

Spending Friday afternoon/evening exploring Old San Juan, probably have dinner somewhere with local criolla food, and walk along the walls of old san juan, the street vendors, etc… have some good coffee…

Saturday morning, head to Fajardo and board the Erin Go Bragh, a 50 foot sailboat, which will take us on a 7 hour tour of some of the small islands of the Spanish Virgin Islands (you never hear about them because they're smaller than the other ones, considered a part of PR and until like 2004 they were mostly restricted military training grounds), including snorkeling and lunch.

After that, we head to the island of Vieques, either dropped off by the Erin Go Bragh, or taking the ferry from Fajardo, and check in to the Casa de Amistad, drop off our things, and as the evening approaches, head off for a biobay tour, where we'll boat and swim in one of the worlds few bioluminescent bays, where little plankton things glow when the water around them is disturbed. (We might end up having to do this Sunday instead because of time constraints)

Sunday we'll rent a jeep and explore the island. Until very recently it was almost entirely restricted as a naval training area, but now it's a protected national or state park or something… we plan to visit the other town on the island, take a quick half hour tour of the local fort and museum, and then drive around… maybe do some more snorkeling on our own or find a nice beach to relax on. In the evening, we'll watch the sun set over the ocean from a beach on the west coast. (Unless we can't get in a biobay tour on Saturday).

On Monday, we'll leave Vieques by ferry, and head to El Yunque rain Forest. We haven't decided exactly what we want to do there, but probably a guided tour and some hiking and maybe swimming in one of the pools with waterfalls and stuff. :)

From there, we head back to Old San Juan, check in to the "Jungle Room" at the Caleta Guesthouse, and tour the old forts and we're not sure what else just yet… there's lots to do there. I suggested celebrating our stay in this bohemian crash-pad by drinking copious amounts of local rum.

Tuesday morning, we'll check out and head east. We may visit Arecibo town and the lighthouse park there, may not. Then on to Arecibo Observatory, that giant radio telescope up in the mountains that was used in the movies Contact and Goldeneye.

From there, we'll visit the Caguana Ceremonial Ball Courts in Utuado, a Taino indian site with over 25 ball courts. They played a sport similar to soccer to resolve disputes, and for fun.

And then from there we head to the Casa Grande and relax for the rest of the day, with maybe a short hike through the surrounding area if time allows. Yoga every morning at the casa, also.

Wednesday, depending on how time goes, we plan to take the ferry around the nearby mountain lake, stopping at one of the cantinas for lunch, and if time looks good, head south to Ponce to tour a coffee plantation, the castle home of the Seralles family, who founded DonQ Rum, and a second indian site. We'll also do some shopping (Ponce is sort of the arts & crafts center) and visit the art museum there, then head back to the hotel for dinner and relaxation.

Thursday we'll either relax completely with maybe lunch at a cantina, or do al the stuff I listed for Wednesday and have lunch in Ponce, which seems much more likely as we continue adding ideas to the ponce visit.

Friday is *nothing*. we're going to spend the day soaking up sun, napping in the hammocks, and just totally, completely relaxing.

Saturday we head back to San Juan, possibly taking care of any little things we wanted to do between the casa and san juan on the way… our flight doesn't leave til 2 or so, so we have a good bit of time.

And then we're back in good old Chicago and on our way to SB and … work. blech! :)

Back when they first figured out how to put custom ringtones on the iPhone, I immediately knew what I had to do. And on some odd whim, I'm now uploading them for whoever wants to use them.

Fair warning: being awakened by a murloc gurgling loud enough for the neighbors to hear may be hazardous to your sanity, if you plug your phone into external speakers at night like I do, exercise caution. :)

Next Page »