Does anyone know about those 5 megapixel digital video cameras with the memory cards?

I wanted to buy one, however, is the 32MB internal memory or the memory card large enough to tape a 2 hour school play or a 1 hour soccer game? And can they be hooked to the TV to record over to a DVD?

Does anyone know about those 5 megapixel digital video cameras with the memory cards?
In short, Yes, a 2GB memory card or so will hold more than 2 hours of footage. But with my experience in the industry I would never buy those types of cameras. The main reason being, the camera is a camera with a video function and not a true video camera. So the quality of what you are recording is crap and the same quality as a Youtube video. They are Cheap and Nasty cameras.
Reply:Don't know myself, but have always found the staff in camera shops to be very knowledgeable. If you have a John Lewis store nearby, their staff are usually very helpful too. I recently bought a good camera for my daughter and her partner and the staff told me that the storage capacity wasn't good, but for only a few quid I upgraded the memory card to ensure there was plenty of storage. Bought from John Lewis.
Reply:man there's like 10 megapicel cameras now. get them ones.