SQL brain fart

I feel like I am having a total brain fart. I am trying to use a select * where statement to get all the records from my database that match a given setup and using a URL variable:

FROM dbo.TerraLogMain
WHERE Volume = '#URL.VolumeID#'

Now I know for a fact that there are multiple records for Volume = Maps2 for example but I am only getting one record returned.

It also looks like the URL variable is getting passed okay:


So any clues as to what I am missing?

Thanks for any help,