D.S.
You have already received some good suggestions so I won't duplicate those. I will tell you one place that you definetely should not stay. DO NOT stay at the La Quinta near Military Pkwy. We stayed there 2 weeks ago and I actually filed a formal complaint with corporate. It was awful. I'll spare you the details, but I told them that I would not stay there again even if it was free. I'm not bagging on all La Quintas. I usually like them. it was just this particular location.
Have a blast in San Antonio!