Brillnat DbHTML module
w/ replaceable tags
(DNN v. 3 & 4)
This and other Brillnat modules can be purchased on snowcovered.com
An alternative to the core Text/HTML module that functions like it, but also allow tags to be placed in the text that will be replaced with data from several sources.
1. A selection set from a database
2. Logged in user profile
3. Portal information
4. Querystring parameters
5. User host information
For HTML savvy DotNetNuke implementers who want simple data access.
You provide an optional connection string and SQL statement that returns a recordset where the first column is tags and the second values to replace those tags at display time. The SQL statement can include system tags (2-5 above) that will be replaced with corresponding values before sending the request to the database. See settings example
You can place the tags anywhere in the HTML and they will be replaced with data from the database or system values. See Edit Text samples.
The HTML generated by replacing the tags with values from the dataset and system is cached in a custom table in the DotNetNuke Database. A setting is provided to define the number of minutes that must pass before the database is re-queried and the tags are replaced with the values and the modules output is regenerated. This will reduce calls to the database on data that doesn't change often.
Sample output:
The same module when logged in as a different user:
Database values used in the modules above:
