Yes, I have done it using the Sonic Studios cable.
Did it actually work? No distorted audiosignal on the cam?
Yeah, it worked great. My video ended up with the same audio track as my audio master, and there was no drift, etc.
I recall that as my record levels approached 0 db, I think I *may* have heard the camera's AGC/limiter kick in briefly, so you may want to experiment to see what the optimum record level would be on your recorder/camera setup so that the camera's limiter doesn't engage.
Other than that, the only real problem I ever had was not getting the plug all the way in to the camera one time - got audio in the left channel only that time
. That reminds me, now that I have a computer, that I need to go back to my original audio and video and put that show to DVD.
As long as you're up front, this setup works great. If you're shooting far from the PA/stage, there may be some delay from what you see and when the sound gets to you, but that's just the laws of physics kicking in.