Hi,

I'm new to DNN and starting to figure some things out but I am hoping that someone can point me in the right direction on this one.  Outside of developing my own module (I have a time constraint), is there anything available that would allow me to design a query and return results with very little limitations?

For example, I want to:

SELECT T1.field1, T1.field2, T1.fieldn, T2.field1, T2.field2, T3.fieldn
FROM table1 T1
INNER JOIN table2 T2 ON T1.field1 = T2.field1
WHERE T1.field2 = FORM.param1
AND T1.field3 = FORM.param2
etc...

Access the results as some structure and output the page to include the results...

I'm basically looking to build a page/template as you would using ASP or Coldfusion etc...

Is there something out there that can get me close to that?  I have XMod and from what I can tell it is very limited in terms of allowing me to specify my own query input params and the search functionality is pretty locked down so that I can't modify.

Any direction would be appreciated - thanks!

Several other modules provided similar but different capability.  Check out DNNStuff's SQLView Pro or my SQLGridSelectedView  - examples can be seen here

Paul.