Hey everybody, just a reminder that we will be hosting Terry Ryan this Wednesday for our CF/Flash Builder Launch Party at the Inland Empire User Group in Cal Poly Pomona! We got lots of food, drinks, prizes and goodies. So please remember to stop by before 7pm in the following location:

Here’s a building plan for Bronco Student Center that shows Ursa Minor as room 2135 near the center of the 2nd floor (right click to make the map zoomable and draggable http://www.asi.csupomona.edu/bsc/bscmap.php.

Also see the campus map at http://www.csupomona.edu/maps/dynamic/index.php?structureID=Bg-35

Non-students could use the GUEST wireless network for their laptops. See http://www.csupomona.edu/~ehelp/wireless/.

I had a cool little SQL problem yesterday where I had a table with 2 columns: cn, email and for some reason there could be many entries for the same email address:

cn | email

1 | [email protected]

23 | [email protected]

So I needed to get a nice query where I could join all the values of the cn column into a single column for the same email. This was tricky but custom SQL functions to the rescue. This is for MSSQL but you can tweak it for MySQL very easily. So the first thing is to create a function:

CREATE FUNCTION [dbo].[getValueList]

(@email varchar(500))

RETURNS varchar(500)

AS

BEGIN

DECLARE @listStr VARCHAR(500)

SELECT @listStr = COALESCE(@listStr+',' , '') + cast(cn as varchar)

FROM tempTokenMailingList

WHERE emailAddress = @email

RETURN @listStr

END

Once I did this, it will return to me a list of column values based on an incoming email on my target table. You can make this more dynamic but it basically solves my use case. Then on my selection I do this:

select distinct emailAddress, name, token,

( dbo.getValueList(emailAddress) ) CN

from tempTokenMailingList

order by emailAddress

Run that and VOILA! You get a cool way to get your cn column concatenated as a list of values.

CF.Objective is almost 3 weeks away and man am I excited!  If you have not attended CF.Objective before, you should be, as it is the premier advanced ColdFusion/Flex/Air conference.  It was been a great delight to participate in this conference and this year promises to be really awesome also.  One thing different about this year is that we have amazing trainings happening before the conference at very awesome prices.  Of course, I will be there teaching CBOX-100 for our 1 day workshop and course.  There are also the following amazing classes:

• Coldbox:100 Training (April 21)
• Building Secure CFML Applications (April 21)
• Developing Applications with ColdFusion 9 Object Relational Mapping (ORM) (April 20-21)
• Getting Started with Flex and AIR Development with the Flex SDK (April 21)
• Mach-II and OOP from the Ground Up (canceled)
• Programmers Guide to Mura CMS (April 21)
• Rapid Development with Model-Glue 3 (April 20-21)

So if you still are undecided, then DECIDE!! Come on over and hang out with us and learn fun stuff!!

I blogged a few days ago on the main ColdBox blog site that the ColdFusion Builder extensions have been drastically updated. They can now connect to ForgeBox and install any entry almost command like style, auto-update itself, and so much more. I am really happy with the way the extension is developing and we have great plans for it.

The most compelling reason for the extension is productivity! I have seen my development totally increase because of the extension. Where it can create my handlers, actions, views, integration tests and more all in one gentle sweep. So if you have not used the extension, I really recommend you take a quick spin of it, as it will totally change the way you develop your ColdBox applications.

Just a reminder that we will be holding a cool CF & Flash Builder Launch Party at the Inland Empire ColdFusion User Group on April 7th at 7pm! We are honored to host Terry Ryan, Platform Evangelist for Adobe, as he will demonstrate these two cool products. Not only that but we will have food, drinks, games and prizes. Check out our IECFUG post for more information so you can RSVP to this event!

Hi everybody, I just wanted to announce that I will be attending scotch on the rocks on May 24-25 for the very first time. I will also be presenting on ColdBox and we have organized (thanks to Andy Allan) a 3 day intensive ColdBox training right after the conference from May 26-28. We will be doing 2 days intense CBOX-101 course and then the last day we will hold a ColdBox bootcamp and build some apps the entire day!

Just remember that seats are limited, so reserve your seat right now!

CF.Objective Coldbox:100 Training

April 21 - One Day

Course Description

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.

Requirements

Below is a listing of some of the course requirements or assumptions you will need:

• Laptop or Personal Computer Basic CFC knowledge Intermediate ColdFusion Knowledge Basic understanding of web applications
• Basic knowledge of CSS,XML,HTML,JavaScript and AJAX

More information at http://coldbox.org/index.cfm/courses/cbox100

Maximum number of students: 20

Price: $500 for Early Rate, $600 Regular Rate

Early Registration Deadline for cf.Objective() is February 14th! Save $100 by Registering Now!

The ColdBox February 20-21st CBOX-101 training seminar is getting close and there are only a few seats available. I am running a super special available for only the next 5 days with a surprise and HEVY discount.

So if you are interested in attending the seminar, use the following link to register: http://coldbox.eventbrite.com/?discount=superweek

I am also willing to give awesome discounts for students. So if you are a student and would be interested in attending our seminar, please send me an email to [email protected] with the subject titled: Starving Student Needs ColdBox! And you shall get an amazing discount.

Again, you can register here: http://coldbox.eventbrite.com/?discount=superweek and view our event details here: http://www.coldbox.org/events/ca-feb-2010

Today is the last day for forgebox submissions that will make you win a ColdBox free Book. So get your code on and submit code entries to win a free book. Also remember that we will ship around the world, so ANYBODY can win!

Just submit code entries and the person with the most submissions by 5pm PST today wins!!!

This Thursday is the last night for forgebox submissions that will make you win a ColdBox free Book. So get your code on and submit code entries to win a free book.