I bought mine from Firefold.com I already had firewire 800 (9 pin) to Firewire 400 (6 pin), but wanted an 800 to 4 pin 400 (mini connector on my video camera).
I don't remember the length I got, but it works just fine (Canon Elura 100).
Hard to go wrong at $7/cable.
Scott