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:
http://localhost/GISTerraLog/VolumeDetail.cfm?VolumeID=Maps2
So any clues as to what I am missing?
Thanks for any help,
:hr:
