Here an article by Andy Leonard that demonstrate how to put data from a result set into variables.

Object Variables, ResultsSets, and Foreach Loop Containers[/url]

If you have multiple rows in your table and want to loop through each, this kind of approach will work.