You can also read the article that describes how this is implemented.

undefined NaN NaN Jun 5 2002 Apr 30 2002 Mar 31 2002 Feb 28 2002 Jan 23 2002 Jan 22 2002 Jan 15 2002 Jan 14 2002 Jan 7 2002 Dec 24 2001 Dec 11 2001 Nov 27 2001 Nov 12 2001 Aug 1 2001 Jul 14 2001 Jun 24 2001 Jun 10 2001 May 26 2001 May 12 2001 Apr 30 2001 Apr 22 2001 Apr 14 2001 Apr 8 2001 Mar 29 2001 Mar 24 2001 Mar 17 2001 Mar 10 2001 Mar 3 2001 Feb 24 2001 Feb 17 2001 Feb 10 2001 Feb 3 2001 Jan 27 2001 Jan 20 2001 Jan 13 2001 Jan 6 2001 Dec 30 2000 Dec 23 2000 Dec 16 2000 Dec 9 2000 Dec 2 2000 Nov 29 2000 Nov 25 2000 Nov 18 2000 Nov 11 2000 Nov 4 2000 Oct 28 2000 Oct 21 2000 Oct 14 2000 Oct 9 2000 Oct 7 2000 Oct 3 2000 Oct 1 2000 Sep 29 2000 Sep 27 2000 Sep 25 2000 Sep 23 2000 Sep 21 2000 Sep 18 2000 Sep 14 2000 Sep 11 2000

Dec 2 2000 ********************************************************** Welcome to the latest CoverYourASP newsletter! ********************************************************** Another fun-filled week! I'll let the diary speak for itself first.. ------ 29 Nov ------ - Not only the worst day ever (see below), but the best day ever too. The site got listed on LearnASP.com as a Top ASP site - Charles Carrolls site gets 22,000 visitors a day, so Im hoping the traffic improves...which means the site improves. - Serious problems here this morning. I lost the entire database - members, newsletter subscribers, everything. I would like to say it was lightning or some other act of god, but it wasnt. I was using a new FTP program and hit the wrong button - and uploaded an old corrupt database over the live one. Big oops. I hadnt backed up the database for 3 days, so all memberships and subscriptions to my newsletter since then have been lost. Sorry folks. ------ 26 Nov ------ - Don Welsh was the first to point out that the database in the download didnt have the diary table! Its now fixed of course... - Ken Reed pointed out a bug in the way that all the links work in the latest download. I added a tag recently to utils/Init.asp to define where the relative links are relative to. By default it assumes you run from http://localhost/cya, but many of you dont. I've now published an article about how to set this up - see http://CoverYourASP.com/BaseHref.asp - I wanted to make the default front page smaller for non-members, so I turned off the diary and whats new. I also added a new page - AllContent.asp - that displays everything that the front page doesnt, so members or non-members can both see all the content. This reduced the non-members front page from 25k to 14k! ------ 25 Nov ------ - Found a bug in utils/login.asp - I was reading the personalization flags into the wrong variables, so when you signed in the next time your settings would look wrong. In fact whats stored in the database is correct, and you should now see what you asked for. **** As soon as I uploaded the bad database I knew this wasn't the normal kind of screw up. I was very lucky to have a fairly recent back up. I had to take the site down quickly though, so I quickly typed in a new html page called Maintainance.htm, and added a line to the top of my Init() function in utils/init.asp. Redirect ( '/Maintainance.htm' ); (Redirect is just a wrapper function for either Response.Redirect or Server.Transfer, depending on IIS version) This line was all that was required to send every page on the site to the emergency maintainance page. I've left that line in Init(), but commented it out. Let's hope I don't have to use it again! **** Hero of the Week! Hakan Eskici - of TableEditor fame - has helped a lot this week, including an email asking if there was anything he could do to help when he saw the maintainance page up. What does he do, live on my site? ;-) Of course, I've said in my DBAdmin.asp article that I based the idea of my db pages on his TableEditor - and now he's come out with updates to that I shall be unashamedly looking through to see how I can improve mine! Thanks Hakan. See his growing site at http://www.2enetworx.com/dev/ **** Yuri Smetsers helped out too this week, I appreciate his patience! He couldn't get the site to work with the new relative links and <base href> tag, so he prompted me to solve the problem and publish a new page that helped with setting up include/config.asp, line by line. Read it at http://CoverYourASP.com/DownloadConfig.asp He also suggested that I add a new download containing all the images, so that is now available at http://CoverYourASP.com/Images.zip **** No-one has reported a problem with the cookies that the membership system uses, but I got the following anonymous email this week. Thank you to whoever sent it! "There is a problem (caused by microsoft) and the article about it: http://support.microsoft.com/support/kb/articles/Q271/1/92.ASP function KillLoginCookies ( ) { Response.Cookies ( sCookieEmail ) = ''; Response.Cookies ( sCookieEmail ).Expires = '11/27/1980'; Response.Cookies ( sCookiePassword ) = ''; Response.Cookies ( sCookiePassword ).Expires = '11/27/1980'; } Those days were added by me and now it is working." All that was changed was the date format. **** The number 1 question I get emailed is asking to solve: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. This has been mentioned before in the newsletter, but maybe all the emails this week warrant another mention. This error means that the relevant ADODB driver is not installed. First, check that you have Access installed. Check which version, and use the appropriate setting for sDBDriver in include/config.asp. Try different settings. Here's what MSDN says about the issue. (It talks about SQL server, but it applies to Access too). CAUSE The MSDASQL OLE DB provider is either unavailable or is not registered. This can be caused by an incomplete upgrade or a bad install of the Microsoft Data Access Components (MDAC) components. RESOLUTION Here are two ways to resolve this problem: - Register the Msdasql.dll using the following command: REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL" - Reinstall the Microsoft Data Access Components used. The newest version of MDAC can be downloaded from the following Web site: http://www.microsoft.com/data/download.htm After installing, again experiment with the setting of the sDBDriver in include/config.asp **** Next week I will publish a new article about visitors who leave your pages before they have finished loading, and I'll start to update my categories section to use my own Yahoo style layout. That'll probably take more than a week of my evenings though! A search facility might even come out of that.. Regards, James Shaw [email protected] http://CoverYourASP.com/ ********************************************************** Recommend my site to your colleagues, go to http://CoverYourASP.com/Recommend.asp ********************************************************** If I've helped you, help me keep going! http://CoverYourASP.com/Donate.asp ********************************************************** To subscribe/unsubscribe from this mail, please visit http://CoverYourASP.com/subscribe.asp **********************************************************