SQL Issue with passing an ID to the Action Page

[monoone]

Hello;

I have what seems to be a complex problem. I have a productPage that has a URL Link to a detail page for close up images. The detail page has thumbnail images that link to the detail page. I can get to the detailPage (has large image) fine but there are multiple images for this one product so I want to have those thumbnail images generated under the bigger image.

The problem is that once I use the detailImageID for the multiple images I can't use the original ProdID to still generate the thumbnail of that one product.

Here is the SQL for the detail Page:
--------------------------------------------
<CFQUERY NAME=&quot;GetProductDetail&quot; DATASOURCE=&quot;studentDB&quot;>
SELECT
DI.DetailImage,
DI.ImageThumb,
PR.ProdID,
PR.ProdName,
PR.ProdNum,
PR.SRP,
PR.BriefDesc,
PR.Features,
PR.LongDesc,
PR.SmImage,
PR.LgImage,
PR.CatId


FROM
DetailImage DI,
Product PR
WHERE
DI.DetailImageID =#URL.DetailImageID# AND
PR.ProdID = DI.ProdID

</CFQUERY>

------------------------------
Can any body help?

Thanks,

Eric

 

[izachar]

Is creating another cfquery with another nmae and having 2 cfoutputs an option. One for the large image and one for the thumbnails.

 

[izachar]

Is creating another cfquery with another name and having 2 cfoutputs an option. One for the large image and one for the thumbnails.

 

[monoone]

Maybe but how would I dynamically generate the ProdID for the correct DetailImage?

Ideally, I would like to pass the prodID over to this page through the url link that has the detailImageID. Is it possible to carry over two diffrent ID's in one link?

Maybe a stupid question?

Eric