Hello.

I've created a simple query.

User enters 3 product IDs (separated by commas), expecting it to return the 3 products and the information related to it.
I've used repeat region for the product to return the original product ID and info related to it,but it's
not doing it.

If I query 1 product, it returns the information that I need for it.

I know what Repeat region does, just not sure if I can use it for this application.

In my testing it in the query box I get the result, but doesn't display in the page

SELECT *
FROM dbo.ix_spc_product
WHERE ID in (MMColParam)

Parameters:
name: mmcolparam
type: text
value: request ("ID)
default value: 1

It was request.querystring ("ID" previously but both doesn't work

what else can I be missing?

nested regions?

Thanks in advance!





Edited by - diggable on 13 Jul 2008 05:18:27