Blog

I wanted to shoot out on this as I do not use MSSQL 2005 and greater too much and need help on what would be the best and great way to do record paging. I am so used to this in MySQL and you can see a sample of MySQL below:

SELECT SQL_CALC_FOUND_ROWS

Users.user_id, Users.user_fname, Users.user_lname, Users.user_email, Users.user_isActive

FROM wiki_users as Users

WHERE Users.user_isActive =

LIMIT ,

SELECT found_rows() AS foundRows

First of all, do you see any problems with this approach?

Second, how would I reproduce this in MSSQL?

ColdBox 2.6.3 was released today and you can now download it from the main coldbox website.

This version tightens up the new features introduced into 2.6.2 and actually did more optimizations and cleanup.  So you will see that the core size has actually been reduced in this release (Go figure!!).  We have also introduced some nice enhancements to the new features introduced in 2.6.2 and you can read all about it in the What's New Document for 2.6.3.  You can also read all about the fixes and optimizations in our Latest Release Notes.

We will be holding a pre-conference training at CFUnited 2009.

Below you can find information about the course and how to register.

What is CBOX-100?

Intro to ColdBox is an intense 1-day training course that will get you started with ColdBox Application Development. This course focuses

on the main aspects of ColdBox Development and it delivers a one-two punch to get you started.

Event Details: http://www.coldboxframework.com/index.cfm/events/cfunited-2009-cbox100

Registration: https://secure.teratech.com/training/classReg.cfm?TrackID=361

Pre-conference classes are a separate cost from the main CFUnited event.

Location:

Lansdowne Resort and Conference Center.

Date:

August 11, 2009

Hours:

9:00am - 5:30pm

Food:

Breakfast, Lunch, and fully replenished snacks and beverages are provided throughout the day.

Cost:

$549

Seats per class:

20

Extras

• Free wireless Internet
• Includes all materials and Certificate of Completion
• ColdBox Schwag

Just an announcement that the Early Bird Pricing for ColdBox Training ends tomorrow at 5pm Pacific. After that, you will get the standard training price. I would recommend you register this week so you can take advantage in over $250 in savings.

This course is 2 Days of intense ColdBox and Enterprise Application Development Training, that will help you not only get ColdBox Trained but also help you plan and architect enterprise ColdFusion applications.

I did an interview for CFConversations back in October and it is now released.  Please check it out by visiting the cfconversations website.

It was a true pleasure to talk to Brian Meloche and Adam Haskell.  I had a great time talking to those guys. We talked from everything about El Salvador, Salvadorean food, the Salvadorean Civil War, coming to the US, the roots of ColdBox and the future of ColdBox.

So if you have time, please check it out and don't forget about ColdBox Training is now available for March 14-15th in Ontario, CA.

I am pleased to announce our third ColdBox Training seminar to be held in sunny Southern California on March 14-15th, 2009. We have a great venue at the Hyatt Ontario Mills in Ontario, California (ONT). Just 30 minutes from Disney and super close to Los Angeles and surrounding beaches. This seminar will cover our flagship course: CBOX-101 - Core ColdBox and it will include everything ColdBox up to version 2.6.3. Wait a minute, 2.6.3 is still not out, well it soon will be, but the docs are ready!!

The early bird pricing has been announced and it is an INCREDIBLE early bird price. So head over to the ColdBox Training site and register now as occupancy is limited.

I just got back from vacation and had great news that my topic was accepted for CFUnited 2009.. CFUnited is one of the premier ColdFusion conferences around the world and I definitely recommend that you register for it NOW!

See you in D.C. in August!

In full X-Mas spirit, here is my X-Mas Gift to the ColdFusion Community: ColdBox 2.6.2 Final Release codename series "FAITH". 

This is a major maintenance release that is full of joy and goodies.  There have been over 33 critical fixes to the core, over 4 major sample applications added, over 5 more documentation guides and about 30 nice little additions that will make you giggle with joy!! So what are you waiting for, download it now!

Enjoy it and don't bother me as I leave for vacation tomorrow to El Salvador, to enjoy lots of sun, beach, good food and family!!

This is a tip and reminder (I just spent like 10 minutes shouting why why why!!), of a very subtle difference when creating structures in CF. AT first glance creating something like the following will produce what you expect:

mappings = structnew();

mappings.FirstName = "Luis";

mappings.LastName = "Majano";

You would say that the keys for this structure would be "FirstName" and "LastName" would you? Well, the answer is NO!! The keys would be "FIRSTNAME" and "LASTNAME" because the are uppercased by CF. If you really want to keep case, then don't use dot notation but array notation:

mappings = structnew();

mappings["FirstName"] = "Luis";

mappings["LastName"] = "Majano";

By using array notation you are explicitly setting the key with the correct case. I re-discovered this gem by yes, UNIT TESTING, the ColdBox caching engine and some tests where failing because the keys could not be found. Well, DUUHHHH!!! You where assigning them wrong. Anyways, I thought I would share my stupidity on the matter and hopefully save someone or even myself in the future, the few minutes of "WHY WHY WHY!!"