I've installed DNN today, and find i have a question about displaying a daily image(s) and text from a recordset, pulled from a query. I've done this for years as the 'image and tip of-the-day'. Each day, a row in a table is displayed, based on 365 records. The html for the image is dynamically created at run-time from a query, and tied to the page as an image connected to the recordset.

How is something like this done in DNN?

You should be able to use a User-Defined Table for this.

For each image, enter the date that it would display (a Date field), the image (Image field) and text (Text field).

You can use filter settings on the table to show the correct image.

If you need to control the layout, use a custom XSL to render the table, although you'd have to manually define the filter within the XSL.

You should also visit Snowcovered to see if someone's already created a module that does this (I'm pretty sure there would be).

I have just the module for you. It's called ContentDejour and is available for free in the DNN Forge projects section:

http://www.dotnetnuke.com/Products/Development/Forge/tabid/824/ctl/Details/mid/3713/Projectid/101/Default.aspx?page=1&filter=2

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner