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 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.

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...

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.

I have been working on the Link Exchange System converting to a CFC based script. I had to disable the addlink page because of spammers, but the new version will have LylaCaptcha to cut down on all that mess. Hope to have it updated by next weekend and will release to code then.

Ray Camden released a cool website today called ColdFusion Bloggers. Very cool ColdFusion 8 project, I love it. Ray being the nice guy he is released the code for the whole site, so I downloaded it to check it out. Going through the code I found cfsavecontent.

So I had my ColdFusion Advanced training and the book has one page on getters/setters. I'm still trying to wrap my head around this but I think I'm getting it. I'm going to put a test script together tomorrow and see if I can figure it out. I found a post explaining it and hope I can figure it out from that. If anyone has any good resources explaining it let me know.

Every now and then I have to get all the files from a directory that updates quite often. Not wanting to update the static text on the page everytime files are added or removed, I use cfdirectory to make a list then query the list and output the files.

I received an email asking how to use the CF Mini Calendar with none date fields. What does that mean? Well if you have a database that stores dates like so, jul-16-2007 or July 16 2007 in a varchar or other none date field in the db you can easly convert to dates. The way I started using it was something like this Day(blDate) in the query, this pulls just the date from the db. One problem is if I switch from access to sql or mysql it may not work properly.

So 2 weeks ago I went to my advanced ColdFusion training. The school was great and the teacher was good to. I learned alot and I have a better understanding of CFC's. I even learned about ini files and how to use them. I'm still going through the book and working on CFBloggy giving it an update. I am in the process writing my Application.cfc for CFBloggy.

Even before I took the class I wrote the Jedi Name Generator using a CFC, after the class I found a few things wrong and will update here soon and rerelease. I'm going to start bloggin on the Application piece by piece. Not only for other but mainly for myself for future reference.