Advice was given to me to buy firewire cable as my sony handycam DCR-TRV22E wont recognize by my mac OS X ver. 10.6.6? what type of firewire shld i buy?

Macs use either 6 or 9 pin firewire cables. The camera uses a 4 pin cable.
You require a 4 to 6 pin cable or 4 to 9 pin cable depending on the Mac.
Firewire can aslo be called iLink or IEEE 1394a (6pin) IEEE 1394b (9pin).

I'm glad to provide the information about the required firewire cable.
All Sony Camcorders are having 4 pin firewire/i.LINK port.
You can purchase a Firewire cable depends upon the number of pins available on the firewire port on the Computer.
If you have 4 pin firewire port in the Computer, you can purchase a 4 to 4 pin Firewire cable.
If you have 6 pin Firewire port in your Computer, you can purchase 4 to 6 pin i.LINK cable.
In rare cases, it may also 4 to 9 pin.
Please refer the manual of your computer or contact apple to get the information about the number of pins available on the Computer.
You may also get back to me with the model # of the Computer so that I might be able to check the pin information.
Thanks for understanding.
If you need any further assistance, please let me know..