Mar
09
2011

Rock N' Roll Marathon Video

(Add / View Comments) (0)Wednesday, March 9, 2011 - 06:06:56 pm
(Posted Under: Tempe Music Scene Tempe Music Scene, Music Music)
Some video from January that I shot. Well, that Katie shot technically. It's the first time we've really tried out video on the D5000. It's a shame that auto focus doesn't work in video capture mode. And the audio was absolutely horrible, distorted six ways to Sunday. Though I didn't buy the D5000 for video capability anyway, so I'm not really complaining.

Thankfully I had the TASCAM rolling, and overlaid the audio from that to the video, which sounds great.

Hell this was a fun morning.

Now Playing: Ghetto Cowgirl - Don't Care
Mar
09
2011

More Hacking Nikon's "Picture Project"

ODBC Connections To Access Databases in PHP

(Add / View Comments) (0)Wednesday, March 9, 2011 - 01:28:51 pm
(Posted Under: Development, Photography, PictureProject)
As a follow up to Hacking Nikon's "Picture Project", with a bit of playing around, amazingly I've been able to automate the entire process of moving photos onto network drives. The only missing part of the puzzle was updating the access database without screwing around with Access.

Using the ADOdb Database Abstraction Library for PHP, it's possible to create a connection to the Access database and manipulate the data from a PHP script. Pretty sweet, and it put's all the pieces in place for me.

The execution of a simple SQL query will relocation the file location.

UPDATE SourceTable SET Path='DST' WHERE Path='SRC'
Of course, with anything Microsoft, nothing is simple. "UPDATE SourceTable SET Path=Replace(Path, SrcPattern, DstPattern)", which would work if run directly in Access does not work with the ODBC drivers as the 'replace' function isn't available. Every row to update needs to be SELECTed, and then UPDATEd individually, with any text replacement done in PHP.

As far as I can tell it only works under Windows. It'd be convenient for me if there were ODBC drivers for Access under Linux. But with that said, I can absolutely make this work for me.

Switch Styles

About Style Switching.

!Weblog Index

Feb March 2011 Apr
SU MO TU WE TH FR SA
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31

Categories

RSS FeedRSS Feed