John Ramon's ColdFusion Blog

Outputting A to Z only from Query in ColdFusion

Fri, 14 Dec 2007 13:03:022 MST

So yesterday I needed to display the alphabet letters only if a database field started with the letter. Uh? Well let's say you have a table and you wanted last names, and then lets say there are only 2 name John Ramon, and Joshua Cry (sorry Josh) I wanted to output the alphabet only matching our last names. So...

| C | J |

I use Joshua cause I asked him for help and funny story he had to do the same thing yesterday, funny how things work out. So on to the code we came up with.

Ray Camden's Yahoo Weather Extended

Thu, 06 Dec 2007 09:21:041 MST

Ray wrote a cool ColdFusion app using the Yahoo Weather API, I love it but I wanted images. So attached is an updated version of the app with image support. You can use it one of two way, the version attached uses Yahoo's images, or you can replace http://us.i1.yimg.com/us.yimg.com/i/us/we/52/ with the folder holding your own images. Yahoo uses the standard 'Condition Codes' used by The Weather Channel so if you find the images for the Weather Channel's API, which I believe comes in different sizes, you can use them with this app. Hope this helps someone, like it helped me.

Thanks Ray for another great app.

First confirmed site using CFBloggy

Thu, 06 Dec 2007 08:11:002 MST

So Steve Miller is the first confirmed non test blog running CFBloggy. Check out his blog here I must say he did a great job skinning it, very nice looking blog. Nice work Steve, if anyone else is running CFBloggy let me know.

No I'm not dead!!!

Sun, 14 Oct 2007 20:19:039 MST

Hey everyone just wanted to let everyone know what's been going on. I'm not dead and I'm not moving to PHP haha, I know it's been awhile since I have posted anything. Let's see I am super busy with work, my wife is 9 months pregnant with our second child, and I have to keep up with my 6 year old. If the baby is not here by Tuesday, they will induce Tuesday night. So I should have another son by Wednesday. I do have a secret project I'm working on. It's not a software package but something I hope will help bring the CF community together, super cool project I must say.

So why no posting or playing with the super cool features of CF8, well if anyone has kids can tell you my wife is nesting. Whats nesting? Well it the time in a womens pregnancy when she drives her mate crazy wanting everything cleaner then clean. I had to clean the crawl space out (crawl space: a small spider infested area to store junk you'll never use again) and let me tell you I hate spiders. Why did I have to clean it out, will the new born be playing there, will anyone see it? No! But when a women is nesting she is crazy and everything has to be just right or it drives them crazy, and if their crazy you'll go crazy. Two more days then the fun starts, no sleep, long nights, but hey I wouldn't traid it for anything. I can't wait for my 6 year old to meet his little brother. So give me a few weeks to get in a groove and I'll start posting more again.

Family Guy - Star Wars

Sun, 23 Sep 2007 20:49:055 MST

Wow, my sides hurt from laughing so much. Did anyone else see it? I finally know why there called tie fighters haha that was awsome. I sure hope Ray got to see it. I'm sure it will show up on Youtube soon. When it does check it out funny as hell.

Happy birthday!!!

Wed, 19 Sep 2007 08:24:035 MST

Wow today is the first dirthday of my blog, seems like it just flew by. I haven't posted all month and I should be doing something but work has been busy and my wife is 8 months pregnant. So with getting the babies room ready, work, and spending time with my 6 year old son I haven't had time for anything. I do have a couple of new projects in mind and as soon as I have some time I'll start working on them.

As for CFBloggy I have a list of bug's I will be working on here soon, now that I'm running the latest version I have found a few. If anyone has any issues please email me them and I'll get them fixed up. I'm working on Version 2 when I have them time. Version 2 will have alot of the code cleaned up and the admin section will be using CFC's, the biggest features will be security. I'm going to test out a few other spam prevention methods, someone is posting comments that make no sense and is filled with links to sites.

ColdFusionBloggers.org, I'm sorry!!

Fri, 31 Aug 2007 20:28:022 MST

Well I guess updating my site to a whole new system, ColdFusionBloggers.org thought I was a new site and pulled the last 20 entries. My dates didn't change on the site or through my feed. Sorry Ray I don't know what happend. I am running a new database and the feed was not updated, although it is dynamic.

JohnRamon.com updated!

Fri, 31 Aug 2007 15:51:038 MST

Finaly my site is running the latest version of CFBloggy, and got a new look to go with it. It's also running MSSQL, no more Access yea! I may have lost a few hits in the update but nothing to worry about. If anyone sees any mistakes or anything not working right let me know, please. I figured my site could use a new look on it's first birthday.

Spammers got love them, or tell them where to go.

Thu, 30 Aug 2007 11:08:023 MST

I have received lots of spam over the last week or so. It's really starting to bug me. I wrote a small script to catch the IP addresses and block them, hopefully this will stop most of it, if not all of it. I have a feeling it's from the same person, and I am using Lyla Captcha. It's only hitting the same to old posts over and over. Could it be a Bot? Has anyone else using Lyla had this problem?

I'll post again after I catch the IP addresses and block them see how it goes. If I still get them I will be adding CFFormProtect and see how it works out.

100 Posts and one month till my blogs birth day!

Sat, 18 Aug 2007 21:13:049 MST

What a week! I have been super busy with work, and play. Last weekend my 6 year son won Grand Champion at his first Taekwondo Tournament. Very proud day for me and my wife. Also this week I'm no longer an employee at my company, I'm a partner. What better way then to grow old, but to grow old writing ColdFusion code. (Insert geek comments here).

I've also been trying to workout the 6 pages of css code to make a template from JohnRamon.com, and I have giving up. I am working on a new design, and I hope everyone likes it as much and the old one. I must tell you that the code on my blog is so outdated it scary. So updating to the newest version will improve preformace and stop the errors my code here kicks off from time to time.

CFBloggy layout updates coming.

Sat, 11 Aug 2007 21:29:035 MST

I posted about updating my site with the newest version of CFBloggy, and I am working on it. I'm also going to release the layout for all to use. So if anyone is waiting for the JohnRamon.com layout it shouldn't be to long. To run the layout I have to update CFBloggy, but the good news is the default layout wil be rewriting to work with the new layout. I hope this doesn't mess up anyone's work, but it needs to be done.

P.S. this is post 99 next one is 100, a small milestone.

CFBloggy major updates released

Thu, 09 Aug 2007 23:37:033 MST

I updated CFBloggy tonight, there where alot of updates and fixes. I cleaned alot of the code up and created some new files. I updated the updates.txt file with all the updates, to many to list here. So grab a new copy and have fun. If you find any bugs please call the Orkin man, haha just kidding. Send me an email with what you found and I'll fix it.

Now that I'm done I will start the revamp of my personal site. I have received several requests for the JohnRamon.com template. I will turn it into a template for CFBloggy. Basically when I'm done all you have to to is download the zip and add the css and image files to your CFBloggy.

CFBloggy now has SQL and MySQL goodness

Wed, 08 Aug 2007 21:48:039 MST

I have updated CFBloggy to support SQL and MySQL. I haven't updated the project page I still have to do lots of testing but things look good. I will be updating the project sometime this weekend. Also included in the update is the subscribe to post and remember me functions.

I also want to update the application.cfm if I have time. I have lots of stuff to do, and little by little I'll get it done. Keep an eye out on CFBloggy.com for bug reports and update releases.

JohnRamon.com Overhaul

Tue, 07 Aug 2007 15:54:034 MST

Over the next week I will be updating my site to the latest version of CFBloggy. Currently I'm running a pre pre alpha version with more bugs then a rotted out log. I added some cool stuff to the latest version, which I have not updated on RIAForge.org. I will in the next few days need to do some testing. What did I add you ask? Well I added 'remember me' and 'subscribe' features to posts. So now if someone posts a comment to your comment and you subscribe you'll know it. I don't want to be posting every little change I make so you can always check out CFBloggy.com for news and updates before releases come out.

Project news

Mon, 06 Aug 2007 22:04:056 MST

There will be a few updates in the next few weeks to CFBloggy, one thing is I want to add subscribe to post feature. That's the big one and a bunch of small updates to it as well. I have received lots of positive feedback on CFBloggy, I feel a little better about releasing code. Even though the code looks like someone through it up, hehe. I will be updating it lot, so keep up todate on CFBloggy.

On another note, I will be taking another look at the Link Exchange System I wrote awhile back. While it did have it's flaws I think with a little work and recoding it could be great, read on...

Jedi Name Generator latest update

Sun, 05 Aug 2007 00:49:035 MST

I found a few things wrong on the form page so I updated it. You can download the newest version below.

If anyone is using please let me know, I know it's useless but I learned something from it.

CFBloggy update

Sat, 04 Aug 2007 23:11:055 MST

There are a couple of fixes for CFBloggy, check the CFBloggy site for more info.

CFBloggy released!

Fri, 03 Aug 2007 19:04:031 MST

CFBloggy has been release, yes I know if took almost a year and blah blah blah. It's kind of hard for a noob (maybe not a noob, but still feel like one) to release code to the wonderful ColdFusion community. I still feel a little self conscious about it, especially a project this big.

I know there are some bad coding practices, and lot's of no no's, but trust me I'll be fixing them little by little but the core of the application was writing 9 months ago. So as I have time I will be updating and posting them on CFBloggy.com. The first thing I will be working on here is the application.cfm.

CFBloggy launch coming!

Fri, 03 Aug 2007 16:12:022 MST

So I just installed CFBloggy Version 1.0 on CFBloggy.com. I setup a project at RIAForge.org and am waiting for the project to be approved. I have worked long and hard on it and I hope it works out for anyone who downloads it. Not that it won't work, hehe, but I learned alot writing it and I hope others learn something from it as well.

About Me

Wed, 01 Aug 2007 11:13:029 MST

My name is of course is John Ramon, I am a ColdFusion Developer. I have been working with ColdFusion for over 2 years now. I use to work with PHP, but when I started with ColdFusion I've pretty much put it away. I work for a web design company as the Lead Project Manager, and my job is to basically to oversee the application development and maintained for our client software. I use to work for the unnamed telecom company that rhymes with crapcast (hehe), I hated my job and if you've seen Office Space, that was my job. Only I was a bit closer to putting a bullet in my head.

Working with ColdFusion on a daily basis is great I wouldn't want to do anything else. I have a few ColdFusion projects, and my blog software I'm developing. You can always contact my through my contact page. I have loads of ideas for project and new features for other projects, look for those in the near future.

So I'm 34 years old have a 6 year old son and another son one the way (at the time of creating this page), and of course my lovely wife. I have a cat named Alley and a dog named Pedro (name from Napoleon Dynamite movie). I live in Parker, CO a small town 20 min southeast of Denver. As for my hobbies other the ColdFusion, well spending time with my family is the most important thing to me so my hobbies usually involve them. I do have some RC cars, and love doing work around my house.