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:
Code:

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


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

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

http://localhost/GISTerraLog/VolumeDetail.cfm?VolumeID=Maps6

I also tried using a direct statement just to see if that gave up any hints:

SELECT *
FROM dbo.TerraLogMain
WHERE Volume = 'Maps6'

but I still only get one record returned.

So any clues as to what I am missing?

Thanks for any help!

Cheers,
Melissa