By host on Saturday, February 16, 2008 7:47 PM

Drive 200km (120 mi) north of Toronto... and boy do you find Snow.    Spent a lovely day in a snow bank ... and helped the local economy. 

Read More »

By host on Monday, February 11, 2008 8:21 PM

Well... I have been thinking about this for a while.. and how best to support UDT in SQLGridSelectedView.  My current belief is I shouldn't as I can't know all the possible needs. 

So I decided to develop a generic Stored Procedure

Read More »

By host on Sunday, February 10, 2008 9:38 PM

I have been playing around with the Membership tables and saw a request in the DotnetNuke forums that go my attention.  It seems there is a lot of confusion on just how to get data out of the ASPNET_Membership data tables.  

The user was asking how to get the LastLoginDate for a user and adjust that by the timezone ... Well is all in there somewhere.  

Consider the following procedure.  The following stored procedure will return the username (for conformation) and the LastLoginDate adjusted by the timezone value associated with the user.  The default if none is found is 0. 

You should be able to tweak this procedure as you need.  Just use the script in the Host>SQL window ..

I have been rather explicit in the way I built the proc so you can see where all the intermediate field come from ... you can combine some of these to possibly improve performance (??)  but I prefer the readability over the slight gain you may get. 

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetLastLoginDateByUser]') AND type in (N'P', N'PC'))...

Read More »

By host on Sunday, February 10, 2008 2:25 PM

The follow blog will relate the steps I took to implement this new DotNetNuke Version 4.8.0 site.

Some Background would be helpful. The Old site was on DNN V3.3.5 and had been there for quite some time. I was rather embarassed that site had been unchanged for over 6 months, especially after being at Open Force '07 in Vegas.

So once the new year had come, I began working on the how I would upgrade the site. I choose to start fresh with a new DNN 4.8.0 site base on several factors: a) I want a clean up so old stuff I had in the site b) I wanted to move to SQL 2005 c) I believed I would spend more time upgrading and fixing then starting with a new copy d) I had time - it's cold and snowing.

Here are the steps I took. Please note that my site is hosted by DotNetPark and any reference to actions taken on their site my differ depending on your hosting provider. By the way, I highly recommend DotNetPark.

1) Backup the database - Using DotNEtPark's Database backup functionality I copied the...

Read More »