updating track info from external db

[jwalton333]

I use XBMC for my regular media management at home and itunes for the ipods/iphones.

i can query sqlite3 for the file locations of played tv shows into a list, but how do i iterate the list and compare video kind TV show and unplayed in itunes to change from true to false with applescript?

[jwalton333]

I can get applescript to return the location of tracks for video kind is movie and unplayed is true but it doesn't work for video kind is TV show. I am running iTunes 10

# this works
tell application "iTunes"
set filesTowatched to (get location of tracks where (video kind is movie) and (unplayed is true))
log (filesToWatched)
end tell

# this does not
# I get this response
# applescript error: iTunes error: can't get location of every track whose video kind = TV show and unplayed = true
tell application "iTunes"
set filesTowatched to (get location of tracks where (video kind is TV show) and (unplayed is true))
log (filesTowatched
end tell