the spray basting sold at my local walmart works just fine for me, so i've never needed to try anything more expensive.
check any brand of spray adhesive to make sure it's intended to be temporary and wash out.
it sounds as though you bought a product intended to be a permanent spray-on glue.
if it doesn't have the word "basting" in the product name or somewhere on the can, it's probably not a good idea to use it as a basting spray.