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:
SELECT * 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,