Todd over at cfsilence has narrowed down all of the nominations for the 2006 CFeMmys. This is a great way to show those in the community that you appreciate their hard work. Click on the link below so you can vote today. cfsilence: 2006 CFeMmys - Vote Now!!

Have you ever come across a column or a table that uses a reserved keyword. ColdFusion has a list of reserved keywords, which are typically part of the SQL language and are not normally used for names of columns or tables. To escape a reserved keyword for a column name or table name, enclose it in brackets. ColdFusion supports the following SELECT statement examples: SELECT [from] FROM parts; SELECT [group].firstname FROM [group]; SELECT [group].

I know I have seen something similar somewhere else so do not think I am claiming to invent electricity here. We all have applications that need to be updated right? The larger ones usually include some type of code promotion to the production server while the smaller ones are not really thought out. I have a quick way of updating code or a database that I use on smaller sites that are live. When it is time to make a change I simply change my downForMaintenance variable to true.

Peter J. Farrell who is one of the lead developers for Mach-II, a co host of The ColdFusion Weekly Podcast (where does he get the time) and a very active member of the ColdFusion Community (no seriously did you invent a time machine) is asking for your new years resolutions. More specific he is looking for CF related resolutions. Your resolution can be short, long, funny, or serious. You can send them a resolution by calling their skype line at the number below or by clinking on the link below.

This weekend I had a chance to download ajaxCFC and play around with it a bit. If you are not familiar with ajaxCFC please be sure to click the link above to learn more about it. The short version of what it is though straight from the source of Rob Gonda's website is as follows.

I am sorry to bore everyone but I just wanted to take a second to send out a few thank you's. It is nice to know that people out there are actually reading my articles. It makes writing so much easier when you know you actually have an audience and you are contributing to a community that has given you so much already. With that being said I had a post on passing parameters to ColdSpring that was picked up by some people listed below.

I am curious to know what first comes to mind when you hear the title of this article. The reason I ask is the result of a conversation I was having with a friend of mine. The topic at hand was ColdFusion components. I have been using them ever since they were introduced in v 6.0. I am currently in the middle of trying to learn and adapt some of the OO design patterns being used throughout the community and wanted to get his perspective on a couple things.

I have always found it easier to learn something when there are multiple perspectives on different platforms. With that being said I have found video tutorials and presentations to be a wonderful teaching tool. I am in the early phases (and still considering) starting an Open Source ColdFusion video tutorial site. The site will have training videos for ColdFusion such as installation, administration, debugging and any other topics the ColdFusion community deals with.

I am going to continue on my Payflow Pro run here and share a simple problem and solution that a client recently presented me with. The customer uses the Payflow Pro manager to view the transaction list. The only problem is that the order id on our end is passed to the gateway but it is in a comments section and the only way to view the comments is to view the details.

I just realized that in my last post I did not explain what to do after you make the call using the Payflow Pro tag. The query attribute in the tag is the variable you will use to parse out the result. The query variable will return a query with the following values. #Queryname.resultstr# gives the full, exact response from the server. For example, if you passed QUERY = ?Transaction? to the ColdFusion CFX_PayFlowPro tag, then you could refer to the data as #Transaction.