Using the ListX module to create a database-driven master-detail interface on a single web page > Forums > Bi4ce Open Source DotNetNuke Skins: DNN Modules: DNN Consulting

Forums

Subject: Using the ListX module to create a database-driven master-detail interface on a single web page

You are not authorized to post a reply.

Author

Messages

sfilip

Posts:9

09/29/2007 1:31 PM	Alert
I've just published an article on my blog (http://dnnuke.blogspot.com) with the title "Using the ListX module to create a database-driven master-detail interface on a single web page". It's a simple tutorial on how to add master/detail functionality when querying a database table on a single DNN page. Please have a look, I would like to hear your opinions. URL: http://dnnuke.blogspot.com/2007/09/using-listx-component-to-create.html

robert_chumley
Please Wait...

Posts:595

10/01/2007 9:17 AM	Alert
Hello sfilip, Very nice article demonstrating what ListX can really do. Your article really combines some of the core to what ListX is all about. One recomendation is that we do not hard code the ModuleID for the destination of the lxFetch call. We typically set a javascript variable to the '[MODULEID, SYSTEM]' in the "detail" wherever we need to refer to one of the "detail" modules. Therefore we can refer to that module in the "master" by that javascript var. This makes switching the "detail" modules in and out easier and allows for future extensibility. This also allows you to use your pattern on another page. In the future you may be able to write something on the fourth parameter to the lxFetch. This parameter is the destination id so you can use AJAX to insert at a specific point on the page. Thanks, robert_chumley

Robert Chumley r2integrated (formally bi4ce)

miamiray

Posts:45

02/27/2008 10:08 AM	Alert
Uh, When you have a couple minutes, could someone do me a favor and give a little example of that? (setting module id to a javascript variable)? Where do I put javascript inside the module? And then just a quick sample of the javascript that would go in the module, and a sample of the lxFetch with it in there. Thanks in advance, Ray

pauldes

Posts:1392

02/27/2008 3:11 PM	Alert
In the master grid module, to link to the detail module, your A tag would look like: <a href="lxFetch(myDetailMod,0,'DetailRecordId=[yourrecordidfieldname]');">View Detail> In the detail DNN Module Settings, go to the Header and insert: <script language="javascript"> var myDetailMod = [ModuleId,System] </script> Then in the Query section of your detail module, it would read something like: select * from mytable where mytableid = [DetailRecordId,Querystring]

ListX....makes you look brilliant, even though you're not.

robert_chumley
Please Wait...

Posts:595

02/27/2008 4:40 PM	Alert
Thanks pauldes, Let us know if this solves the problem miamiray. Thanks,

Robert Chumley r2integrated (formally bi4ce)

miamiray

Posts:45

You are not authorized to post a reply.

Forums > Bi4ce.Modules.ListX > Samples and other shared info. > Using the ListX module to create a database-driven master-detail interface on a single web page