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.