Posts

Showing posts from 2010

feeling like a nub.. an awesome feature existed since coldfusion 7

Image
Yep, I feel like I know coldfusion pretty well. Well I thought I did... Today, I was looking over cfquery (and now I forget why), but noticed there is an attribute called "RESULT".  I guess I need to go over all the things added since CFMX. But anyways I quickly wrote a quick page to do insert, select, and delete. <cfquery name="iRtr" datasource="commons" result="rRtr"> insert into staff.dbo.test (testData) values('test1') </cfquery> <cfdump var="#rRtr#"> <cfquery name="qRtr" datasource="commons" result="rRtr"> SELECT * FROM staff.dbo.test </cfquery> <cfdump var="#qRtr#"> <cfdump var="#rRtr#"> <cfquery name="dRtr" datasource="commons" result="rRtr"> delete FROM staff.dbo.test </cfquery> <cfdump var="#rRtr#"> And to my suprise, there were some really cool things tha...

coldbox milestone 6 released - moduleExternalLocations

I'm excited to move from m5 to m6 within the coldbox 3.0 milestones. The addition of moduleExternalLocations will allow our team to compile our modules into JAR like packages. For example, we have a bunch of util modules that we now can create a util container folder, and include them all by just providing it in the configuration cfc file!! We currently have one util module with all those "features" under. This new feature will allow us to split that one module into many giving us better development/release control! (PS. yes there are other ways of solving the same issues, but this provides a simple framework solution) Awesome work coldBox team!

Subversion's post-commit on windows with ANT

I was very disappointed when I installed subversion and noticed that the commit scripts were non-windows based within the windows-installer for subversion. Well I quickly got over that, and realized ANT had all my needs. I searched the web for ANT Subversion Commit Scripts; and it returned some interesting articles, but no solid examples. So I quickly, researched ANT SVN plugins, then realized, I will be just executing SVN command line utilities to get the info I needed. First, you can find these details almost anywhere, but quickly for you POST-COMMIT script to work, windows must need to know how to execute it, therefore, it must have a recognizable extension (like .bat). So to start out with rename the file that came with the repository to post-commit.bat Second, subversion hooks run in a non-initialized dos command. That means you are not going to have any of the environment variables to your exposure. The following is the code I have within my post script to execute my ...

Android Calendar Sync Bug

I was bitten by my first bug on my DROID. I've been syncing my work, wife's, and my personal calendar to Google Calendar (each having their own calendar), therefore, I'm able to retrieve all my calendar on my MotoDroid. But last night, I noticed I had (coming in late) on my work calendar, but nothing in my or my wife's personal calendars. WEIRD! Next thing I did, was log in to calendar.google.com. And BAM! there it was, my son's dentist appointment. After doing some "googleing", i found the following issue. I am not sure if it is exactly what I am experiencing, but I am definitely worried now. http://code.google.com/p/android/issues/detail?id=3672

Coding MSSQL Start Job and Wait for it

I've been kicking off SQL Agent Jobs for a long time now, but I've never needed to wait for it to end before.  Until today, I needed to pull data from a Ultra Secure SQL Server database and didn't want my web servers to have access to the ultra secure sql server.  So I decided to create command line SQL Scripts that connected to the secure database and pull data into a "staging" table.  And use a Sql Agent job to run that script.  But using the following SQL kicked off the job, but didn't wait until it was finished. msdb..sp_start_job @job_name = '<job name>' Therefore, I needed a Query that let me know if the job was still running.  The following query checks the activity table to see if one is running and hasn't finished yet, returning job name if it is still running.  select j.[name] from msdb..sysjobs j inner join msdb..sysjobactivity a on a.job_id = j.job_id where j.name = '<job name>' AND a.st...