Archive for June, 2009

SQL code lists email addresses of all members of DNN security role by name

June 29th, 2009

This is a very simple (and portable) SQL statement that will list the email addresses of all members of a DNN security role by the security role name.

This is useful if you use 3rd party newsletter or email listserv software and need the email addresses of all members of a DNN security role.

SELECT u.Email FROM Users u, UserRoles ur, Roles r
WHERE r.RoleID = ur.RoleID AND
ur.UserID = u.UserID AND
r.RoleName = 'Registered Users'

You can replace 'Registered Users' with any Security Role name.

This can be executed from the Host>SQL page or using the Microsoft SQL Server Management Studio.

Adding HTML Form Submission to the Text/HTML module in DNN

June 25th, 2009

Question: How can I add an HTML <form></form> element to the Text/HTML module in DNN?

Problem: When editors add a <form></form> tag to the Source of the Text/HTML module, the <form></form> tags are removed after they click the Update link on the “Edit Text/HTML” form.

Cause: ASP.NET only allows one form per page and by default creates its own form just inside the <body></body> tags.

Solution: Here’s an example form we will add to our Text/HTML module.

Read more…

Adammer releases new website design

June 24th, 2009

All of us at Adammer are excited to announce the release of our new website design. In keeping with our strict adherence to web standards, this new site is XHTML 1.1, CSS 3, and WAI-Level 3 compliant.

And we’re proud to introduce this new blog, using our very own custom WordPress theme.

We love being an industry leader in web compliance and accessibility and appreciate all the support we’ve received from all of you in the web community.

Please leave a comment and let us know what you think.

– Team Adammer