We had today several awesome presentations at CFObjective and our awesome jedi Curt, presented on MockBox in less than 6 minutes. We also had fun being his padawans. Awesome job Curt!
To those who attended, thank you very much!
[vimeo]http://vimeo.com/11172436[/vimeo]
Location/City : OREGON - Salem
Meridian Technology Group is looking for a Senior "Expert" Cold Fusion Web Developer with Cold Box
The upfront workload and timeline for this project is intense due to the need to complete the work within the 2010 timeframe. The overall design has been completed and the software components and interfaces have been defined. Such that the person in this position MUST HAVE EXPERT KNOWLEDGE OF COLD FUSION AND COLD BOX, along with substantial experience participating in the development of large cross-platform applications, to focus on the job of generating the code to the specified timelines. In this role, you will be expected to participate in a full functional project team to meet the tight deadlines with the use of Unit Testing and code reviews to ensure that the interfaces are held to specifications.
Not only will I speak, but I will be holding a 3 day training session for CBOX-101 and a 1 day of full hands on development using ColdBox. There are still seats available, so go over to our discount site and get registered with a hefty hefty discount.
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/.
cn | email
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:
So if you still are undecided, then DECIDE!! Come on over and hang out with us and learn fun stuff!!
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.
