Removing Groups of Posts from the DNN Blog Module Removing Groups of Posts from the DNN Blog Module If you happen to run DotNetNuke with the Blog Module as one of your major modules for content, you may find the need to remove a group of posts from the module at some time. For instance, you were active in Paid-to-Post at one time, have received your money from the posts, have fulfilled your obligation with the organization that hired you, but are still being penalized by Google for having the posts on your site. Well, there are only two tables in DNN that you need to query and delete records from to remove these posts permanently. Patrick Stevens 2009-05-09 370 0
CSS Rounded Corners CSS Rounded Corners I have been creating my own rounded corners using a table structure and 6 images on a couple of web sites that we are building. But I started to wonder if there was an easier way to round corners without all the images and etc. Today I came across benogle and his CSS Rounded Corners demonstration which is one really nice way to create what used to require quite a bit of image slicing. Patrick Stevens 2009-05-07 192 8
Finding a Way to Link to Landing Pages without Linking Finding a Way to Link to Landing Pages without Linking I thought I had found a decent way to link to landing pages without actually linking to them. I did this so Google wouldn't know I was linking to certain sites and for some reason punish my rankings. Well I found a decent solution using the Redirection plugin for my Wordpress Blogs. I would create 301 redirections to certain directories on my site which would redirect to the landing page. But some new blogs I created, I received a 401 error on the home page when this plugin was activated. So this solution didn't always work. For those cases I altered the .htaccess file in the root directory to accomplish the same redirection. Patrick Stevens 2009-04-30 214 4
Changing your BlogSpot Blog to DoFollow Changing your BlogSpot Blog to DoFollow I have casually been running a Blogspot blog for some time mostly for linking back to my main web sites. Until today I hadn't taken the time to find out how to alter the blog from a nofollow blog to a dofollow blog. At first it seemed like altering the layout HTML would be all that was necessary but there were no nofollow tags in the code. Then I came across Tips for Blogspot which showed the needed flag 'Expand Widgets'. After selected this checkbox and replacing the two rel="nofollow" with rel="nofollow external", I was set. Patrick Stevens 2009-04-23 206 11
JavaScript OnMouseOver for Firefox JavaScript OnMouseOver for Firefox I wrote a fairly simple JavaScript line to modify the size of an image when there is a OnMouseOver event. And then wrote a similar line of JavaScript to reduce the size back to normal on the OnMouseOut event. The only problem is the JavaScript didn't work on FireFox although it was great with Internet Explorer. After some research I found that using the 'this' object was needed with FireFox. So I adjusted my code to also have the events in the image object itself. Here is the code: Patrick Stevens 2009-04-10 483 17
Updating a Table Without Firing the Trigger Updating a Table Without Firing the Trigger Having a Trigger on a SQL Server table is a great feature that can keep data in sync and update records automatically when needed but what about those cases where you want to run an update command and don't want the trigger to fire. I came across a situation where an update timestamp on a record was being displayed on a web page and I wanted a specific date to show up. The easiest way to fix this issue was to disable the trigger, update the update timestamp on the record, and then enable to trigger. Here is the code: Patrick Stevens 2009-04-09 209 1
Collapsing and Expanding HTML Code Collapsing and Expanding HTML Code When in need of a quick way to expand and collapse HTML code on the client without posting back to the server of your web application, utilize the tag with a style and some Javascript. Start with the style display set to either none or block and then interchange these two setting based upon a hyperlink click event. Patrick Stevens 2009-04-01 409 16 Adding Items to the Cache, Retrieving the Items, and Clearing the Cache Adding Items to the Cache, Retrieving the Items, and Clearing the Cache When working with a web application that contains data items that do not change too often, it improves the performance of the application to store data items in the server cache and retrieve those items from the cache instead of making an extra trip to the database. Also clearing the cache when a item does change is important for your application. Patrick Stevens 2009-03-27 188 7 Getting a List of SQL Database Tables with One Statement Getting a List of SQL Database Tables with One Statement There are a number of really good content management systems available today from Dot Net Nuke to Joomla to Wordpress and creating web sites with them is fast and somewhat easy allowing you to focus more on design and content. But when you need to dig into the database to remove old ads or quickly delete spam comments, knowing the tables available with a single SQL statement is very helpful. I came across a great SQL statement that shows not only the tables but record counts within those tables. And after finding the table containing the information to be changed, getting a list of the Top 10 records with all the columns available makes creating the needed delete or update statement a snap. Patrick Stevens 2009-03-23 163 3 Binding a DataSet to a DataGrid in ASP.Net Binding a DataSet to a DataGrid in ASP.Net I am in the process of enhancing the functionality of an ASP.Net application that I inherited and today I needed to display a grid of related data below an entry form on a page. Some of the functionality was present on a different page following the style the original programmer implemented. A database function to return a Datasource did not exist within the data class so that was my first step. I found this great code below showing the basic syntax of binding a dataset to a datagrid in ASP.Net which was helpful. Patrick Stevens 2009-03-13 254 4 1 52 53 54 55 56
Adding Items to the Cache, Retrieving the Items, and Clearing the Cache Adding Items to the Cache, Retrieving the Items, and Clearing the Cache When working with a web application that contains data items that do not change too often, it improves the performance of the application to store data items in the server cache and retrieve those items from the cache instead of making an extra trip to the database. Also clearing the cache when a item does change is important for your application. Patrick Stevens 2009-03-27 188 7
Getting a List of SQL Database Tables with One Statement Getting a List of SQL Database Tables with One Statement There are a number of really good content management systems available today from Dot Net Nuke to Joomla to Wordpress and creating web sites with them is fast and somewhat easy allowing you to focus more on design and content. But when you need to dig into the database to remove old ads or quickly delete spam comments, knowing the tables available with a single SQL statement is very helpful. I came across a great SQL statement that shows not only the tables but record counts within those tables. And after finding the table containing the information to be changed, getting a list of the Top 10 records with all the columns available makes creating the needed delete or update statement a snap. Patrick Stevens 2009-03-23 163 3
Binding a DataSet to a DataGrid in ASP.Net Binding a DataSet to a DataGrid in ASP.Net I am in the process of enhancing the functionality of an ASP.Net application that I inherited and today I needed to display a grid of related data below an entry form on a page. Some of the functionality was present on a different page following the style the original programmer implemented. A database function to return a Datasource did not exist within the data class so that was my first step. I found this great code below showing the basic syntax of binding a dataset to a datagrid in ASP.Net which was helpful. Patrick Stevens 2009-03-13 254 4