DotNetNuke provides those with “Host” level access a great screen to execute SQL commands against.

This screen is located under the “Host” menu and is named, “SQL”.  It is a simple box that you simply write your query or paste in your stored procedure script and then press, “Execute”. It is a great way to quickly looking up table information or run a delete command if your EventLog gets to full.

I find myself using this box often to look up information in a table.  The only problem is that I am never quite sure what the name of the table is that I am looking up.  That is when I use this simple SQL command to pull out all the names of tables so I can then do some “SELECT” statements on the table I need.

The command below lists all of the tables in your database.  This code is a copy of the code from here.

SELECT...

As web developers we are often creating ways for people to upload files.  Usually uploading a file is pretty trivial and there are numerous examples of how to do it across the Internet.  From time to time we have the need to secure the file we are uploading, to prevent someone from directly navigating to the file and downloading it without our permission.  It is at these times that we have to modify the file upload process just a bit in order to prevent direct access to our files.  Of course, we still need to be able to use the files that are uploaded, so this walkthrough will show you how to upload and secure your files and also how to download your secured files.�

The premise of our security is that files with the file extension of “.resource” are not served by web servers, at least not by IIS.  Therefore all we have to do is add the file extension of “.resource” to any file we upload.  If we uploaded a file named, “Gnome.jpg”, we would store it on the server as “Gnome.jpg.resource”.  If someone were...

 

I have been fighting with Installing IIS for a day or so now.  I was getting a very generic error regarding that the setup failed to install the components.  There was no real detail as to what the problem was.

Well, I finally figured it out.  You have to install the .Net Framework 3 before installing IIS or IIS won’t install.

It makes sense, but I figured Vista would be smart enough to figure that out.  Guess not.�

Technorati Tags: Vista,IIS,Install,Issue,.Net,Framework

...

 Today I needed to grab the values of a list I have setup in Dotnetnuke
and display it in a dropdownlist.  The code to do this is really quite
simple.

Matt asked on Twitter how he could find all of the roles on his Dotnetnuke site that were not currently being used at either the page or module level.

You can find this information out by doing the following:

 

 

This blog post is intended to provide new comers to Twitter.com with a list of Dotnetnuke users who are active on Twitter.  Twitter is a great place to ask questions, discuss and just chat with people about Dotnetnuke.   If you want to have near real time exchanges we encourage you to insall and use an application likeTweetDeck.   If you would like to have your name added to the list then please use our contact form and let us know.  This list is in no particuluar order.

 Today in a discussion on Twitter the question was asked if the Dotnetnuke Sponsorship program was still valid in light of Dotnetnuke Professional Edition coming out.  In the discussion it was confirmed that that the Sponsorship program is still available and still a powerful way to support Dotnetnuke, even if you do or do not purchase the Professional Edition of DNN.