Can an iPad be child locked so they cannot escape from one app? I'm planning on getting an iPad, but it very much needs to be childlockable - that is I need the ability to lock it so only one app can be used unless a user has a pincode or password.  I'm presuming I'll have to jailbreak to get the functionality but I'm not sure where to go from there - any ideas? 

This is the only feature I'm looking for - the app I'm wanting to access is likely 'prologue2go' but that's the only reason to purchase - I'm presuming I'll be getting an iPad2 simply because they are, and will be (I pressume) more stably jailbroken.
This is now a feature in iOS 6 by using Accessibility. You can enable this feature by opening Settings > General > Accessibility > Guided Access. Here you can set a Passcode, enable Guided Access, and choose whether to allow the device to sleep or not (in this case you would want that enabled). After that, triple click the home button after opening the app, and configure the remainder of the settings.

One Caveat:
The only way to get out of Guided Access (without entering the passcode after triple clicking the home button) is to reboot the iDevice. This could be a good or bad thing, depending on the scenario. Obviously one could put a passcode on the device itself which would prevent the user from accessing everything else.