Hello and thank you in advance for your help,

I have a requirement to make a module which queries the same database table on a single DNN page.  We will need the ability to add several instances of this module on the same page with different permission for users to see this module.

The module which I am making is a download module which has a Rad grid as the core element in the module.

I am storing the module ID in each record which is added to the module.

I am querying the database, and using where module id = module id.

But the query seems to be pulling duplicate records back - even though when I just use a select all statement in MS SQL server on the database table, the records are fine.  The module id is correct and different for each module I put on page.  But I just dont understand why my stored procedure is pulling back multiple records(actually duplicates of the same record).

Please help I am really stuck here.

And thank you again for your help.

Where and how is that stored on the DNN database?

Hi,

You are facing this problem because ModuleDd is unique to the module, but not the instance of that module on a specific page. According to your current requirement you would need to use TabModuleID from the TaModules table and you can filter according to TabModuleId.

Thanks,
Avinash Kumar
Mindfire Solutions