Using JOIN in MySQL Update statement | Coldfusion

Posted in Uncategorized on February 17, 2011 by Ron Risman

Along with a photographer and cinematographer I also use the other part of my brain for programming. I design web applications using Adobe’s Coldfusion and SQL apps such as MySQL.

I recently had to figure out how to update a field in one database table, based on information in another database table. To do this I was going to need to use a JOIN statement in order to JOIN the two database tables together based on a common field. For those who are looking to do this here is the process:

Table_A as A JOIN Table_B as B on A.field = B.field
Set A.fieldname = ‘value’
where b.field = xxx


Star Gazing – Seacoast Photographers Group Meetup

Posted in Photography, Uncategorized with tags , , , , , on November 13, 2010 by Ron Risman

This short time-lapse was captured during the Seacoast Photographers Group meetup at the University of New Hampshire’s Observatory. Approx. 300 long exposures combined to re-create the movement of the sky.

A Year of Time-Lapses

Posted in Uncategorized on October 27, 2010 by Ron Risman

This compilation contains time-lapses captured in southern Maine, the seacoast of NH, Groton, MA, and Boston, MA. Most of the time-lapses in this compilation were taken as individual still-frames shot over a period of time, then combined to create motion video.

It takes 30 still images to create 1 second of video, which is why most time-lapse sequences are usually less than 20 seconds in length. When shooting time-lapses of fast action (cloud or people movement) you can usually have the camera take a still frame every few seconds. If capturing 10 frames per minute it would take about 3 minutes to create 1 second of motion video (10 frames x 3 minutes = 30 frames. 30 frames = 1 second of video).

At night, in order for the camera to see all the little stars in the sky each exposure might take 30-40 seconds, which means to capture the required 30 frames (for 1 second of video) it would take about 30 minutes, assuming a 15-20 second delay between exposures. So when you see an 8 second time-lapse of stars moving across the sky you’ll know that the photographer or cinematographer spent at least 3 hours outdoors to capture enough still frames to turn into the 8-second video. Often times I’ll spend 6-9 hours capturing stars and then only use the best 3-4 seconds of footage from the 12-15 seconds that I captured.

You can also capture daylight time-lapse sequences by recording video (instead of taking still frames) and then speeding up the video during the editing process. There is a time and place for this type of time-lapse though there are some effects that are more difficult, if not impossible to capture, using this technique. Both methods have their time and place.

Time-lapses are time consuming to create, especially star lapses.

Trailer: Film About a Girls Love for Horses and Horse Jumping

Posted in Uncategorized on September 22, 2010 by Ron Risman

This is a short 4 minute trailer for a film I worked on this week leading up to the Jumper Classic. The story is focused on 17 year old Equestrian rider, Victoria Birdsall, as she shares her love of horses and for the sport of horse jumping.

If you are interested in having us capture and share their story, whether an athlete, business, or individual please contact me. We living in a world where we are often overwhelmed with information and choices, making it is so important to share your story and let the world know what makes you or your company unique.
Follow me on Facebook:
Contact me directly at:

The Blue Angels – Portsmouth Air Show 2010 at Pease

Posted in Uncategorized on August 29, 2010 by Ron Risman

This past Friday I was fortunate enough to have filmed a couple of hours of the ‘dress rehearsal’ for the weekends Boston – Portsmouth 2010 Air Show. I have only been to a couple of air shows in my lifetime but this was the closest I have ever been to the aerobatics. At one point one of the F/A-18 Hornets flew so low that the smoke left behind filled the area at ground level. Their precision in the air is unbelievable.

Soweto Gospel Choir – Capital Center for the Arts

Posted in Uncategorized on August 23, 2010 by Ron Risman

I had the privilege of filming the Grammy Award Winning Soweto Gospel Choir when they performed at the Capital Center of Arts in Concord, NH. I filmed the event with the help of Photographer Elizabeth Harvey using multiple high-definition dSLR’s for superior low-light capability and a more filmic look. While I am cannot show the performance I have created this promotional ‘trailer’ for your enjoyment.

The two-time Grammy Award Winning Soweto Gospel Choir was formed to celebrate the unique and inspirational power of African Gospel music. The 26-strong choir draws on the best talent from the many churches in and around Soweto and is dedicated to sharing the joy of faith through music with audiences around the world.

If you get the opportunity to see them perform live I would highly recommend it. You can check out their tour schedule on their website:

Behind the Scenes Model Shoot with Lionfish Photography

Posted in Uncategorized on July 19, 2010 by Ron Risman

As photographers we rarely get a chance to be in front of the camera, but if you want to set yourself apart in this new world of online networking, it’s important to do so. When a potential customer is trying to choose between you and a couple of other photographers, allowing them to see what you do and how you do can give you a big edge.

This past week I had the opportunity to create a behind-the-scenes promotional video from Larry Oberlander, a very talented fashion / portrait photographer, and owner of Lionfish Photography. The shoot took place in the mill building where Larry’s new studio is located. This location has tons of great space for shooting – even with all the renovations going on around the building.

The end of the video highlights some of Larry’s images from the shoot. Enjoy!

Ron Risman