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

Jan 6 2001 ____________________________________________________________               C o v e r Y o u r A S P . c o m              Welcome to the latest newsletter!                  http://CoverYourASP.com/ ____________________________________________________________ If you thought I was surprised when I got my first advertiser you should have seen me when CoverYourASP took first place this week in the contest for the ASP Guild's 2001 English Language Help Site Award! Considering my site has a 50th of the traffic that some of the big ASP sites have, I realize that it won't last. But it's fun while it lasts. If you haven't voted yet, I'd appreciate one from you! http://www.aspguild.org/group/~12/asp/voteasp2001.asp?a=171 P.S. Get you mother,aunts and old school friends to vote too. ____________________________________________________________          A   W O R D   F R O M   M Y   S P O N S O R S                 http://www.developersdex.com ____________________________________________________________ Developersdex delivers the world's largest index for Microsoft web technologies.  Search, post, and reply to over 13 of the most popular ASP, SQL, VB and XML Usenet newsgroups. Devdex indexes over 5,000 new resources everyday including those from MSDN, ASP.NET, 15seconds, 4guysfromrolla, ASPToday, XML and ActionJackson.com just to name a few. If it's on the NET it's on Devdex!                 http://www.developersdex.com ____________________________________________________________                     T H E   D I A R Y                The events of the last week             http://CoverYourASP.com/ShowDiary.asp ____________________________________________________________ 30 Dec ______ - Found another spider crawling the site this morning - HTTrack has now been added to the list of user agents shown the JustDownload.htm file.. ______ 31 Dec ______ - Happy New Year and best wishes for a successful and prosperous 2001! ______ 2 Jan ______ - Fixed two errors in BannerReports.asp - asking to view a Banner By Day report for dates where no data was available would cause an ADO error, and the date/month were backwards! It worked where it was obvious, say 29/12/00, but not when it wasn't, like today, 1/2/01!! - The silver members only content is now up to 20 pages, and is being proof-read before the new area is launched. Watch this space... - It doesn't look like much has been updated recently, but a lot of pages have been improved in little ways. For example BannerReports.asp got a link to the article that explains how multiple clickthroughs are ignored. No changes big enough to mention on their own, but things are changing! ______ 3 Jan ______ - Another milestone reached today - my 100,000th visitor! ______ 5 Jan ______ - The new HTTP 500 handler installed this week (see below) has found numerous errors that you guys have been getting, but not telling me about (tut,tut)! The latest required changes to DBEditTable.asp, since it didn't even allow you to view any records in the BannerStats table. Now fixed! ____________________________________________________________            R E C O M M E N D   T H E   S I T E !         Please recommend my site to your colleagues            http://CoverYourASP.com/Recommend.asp ____________________________________________________________ One new article this week: "Trapping HTTP 500.100 ASP errors in your pages" Learn how to replace the infamous "Page cannot be displayed" with profuse apologies and an email moaning to the webmaster... http://CoverYourASP.com/500Descr.asp I've used this code for some time on my IIS 5 development machine, but until recently my ISP had me running on NT 4, where the error handling didn't seem available for 500.100 errors. I suddenly realised on Monday that my ISP was now IIS 5, so I set it up, and then wrote about it. So far it (you?) have found numerous errors in the site, all of which have now been fixed. The importance of handling this error can't be over-emphasized. It also showed up something I wasn't expecting - users trying to load the SSI files in the utils folder directly. I may improve the Handle500100.asp file so it tells the user what they've done wrong - I can tell because they'll be getting a VBScript error (shock, horror).      Microsoft VBScript compilation      Invalid character      /utils/init.asp, line 21 VBScript? Well, the SSI's don't have a @language in them because they rely on being included in a "real" page, and the default language is VBScript... ____________________________________________________________               H E R O   O F   T H E   W E E K ! ____________________________________________________________ Steve Moore and I had a conversation this week. Steve has offered some excellent advice to me in the past - this week Steve asked this question: "Talking about using access databases, are you using connection pooling?" The short answer is No, but the theory is easily understood. A pool of connections to the database is shared across ASP sessions, like a cache. Calling DBReleaseConnection as soon as possible after using the recordset is crucial, since that is when the connection is given back to the pool. What I didn't know, or even investigated, was how to set it up. I was saving all this "tuning" for when I moved to SQL... Anyway, Steve gave me the push and the instructions I needed: - Open the registry editor by running the regedit tool   (Run regedit.exe). - Go to the \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\   Microsoft Access Driver (*.mdb) registry key. - Check if CPTimeout string exists. - If the CPTimeout string does not exist add the Key string   via the Edit, New, String Value - The CPTimeout Key string should be set to 60 (60 seconds) As always, whenever the registry is mentioned, you see a warning - YOUR MACHINE MAY NEVER WORK AGAIN. Be careful! Of course EverPlanet, my ISP, implemented this within 15 minutes of being asked. ____________________________________________________________                N E E D   A N   A S P   I S P ?         Use mine. You won't find a nicer bunch of guys.            Cheap, efficient and extremely helpful.                   http://EverPlanet.com/ ____________________________________________________________ Thanks to Charlie Bass too, of the ASP Guild. He helped me by fixing up the mess I made of signing in and updating my affiliate details. Also by adding me to the Award list in record time! ____________________________________________________________                      F E E D B A C K             Have something to say? Please share!             http://CoverYourASP.com/Contact.asp ____________________________________________________________ Arthur Flintoff: Have you any idea's for creating a search of LongDescr by keyword? or range searching numerical values?  As you can see I'm wondering if some of your codes can be used to create a Search.asp. Me: I guess I&#8217;d just use SQL to do the search, i.e. if &#8220;hello&#8221; entered, I&#8217;d search for   SELECT * FROM SearchTable WHERE LongDescr LIKE &#8220;%hello%&#8221; Tip: % means "anything", like *, but it works in Access and SQL. From my limited testing it seemed that SQL didn't understand * ______ Prabhvir Sahmey: Hello, your survey app is a good example, but 1 question... what happens when we have 2 questions of the same type or with the same name, considering that each user can create a seperate question...?, as defined in your db structure, the table "SurveyQuestions" cannot have similar questions, is there a way out for this? Secondly, I am using Access for this project and will later use the "Upsizing Wizard" to use SQL Server, I need to know would there be any changes in my SQL Querys? Me: You're right, I hadn't noticed that because I never did a second survey! I should have either: a) add a AutoNumber QuestionID field, and modify the queries to use that, or b) add the survey name to the primary key. I'd pick a) - I'll add that to my list. Thanks for pointing that out. The same queries will run in Access and SQL if you're careful, but since I'd recommend moving to stored procedures during the upsizing it isn't that relevant. There were some issues with syntax, like using % as the wildcard, not *, and using ' not " to wrap field data, but unless you have hundreds of queries it won't take long to change them. The upsizing wizard may even help for all I know. ______ Roberto: Hi, I noticed you said that you can convert normal HTML pages written in FrontPage... which is exactly the same program I use... convert them into ASP pages. Could you tell me exactly how you do this? Me: I don't remember saying that, but simplistically, just renaming them to .asp makes them an asp file. What I mean by that is that the file will be processed by IIS as an asp file, it just won't find any script in there to execute. To add some script, add a line at the top specifying the language: <% @language=javascript %> Anything inside <% %> is interpreted as asp, so as an experiment you could add this next line in the middle of your body:     This is just some html text, this page is called     <%=Request.ServerVariables('SCRIPT_NAME')%> That's a simple start. Now look at files like my Date.asp to see how to progress...Have fun! ______ Joseph Anderson: [Inside a 404 error handler..] when I do VBSCRIPT     mylocation = Request.ServerVariables("SCRIPT_NAME")   I get "/404.html" instead of whatever I typed in to screw up. (like //mydomain.com/imanidiot.htm, testing - you know) Me: When a 404 page gets called, it's in this form: http://cya/handle404.asp?404;http://cya/dfgg.asp The querystring contains a "404;" followed by the name that couldn't be resolved. Using QueryString without a variable returns the whole thing rather than one part, which is why I do this:     var sMissingPath = '' + Request.QueryString ( ); ______ Matt: A few days ago, I was having problems logging out of your site.  You suggested deleting the cookie manually, and that worked.  Thanks! Me: I don't know why, but 2 or 3 people have had problems signing out. The cookie keeps signing them back in, i.e. it's not being deleted as it should. If anyone could shed some light on this... ____________________________________________________________             H A V E   I   H E L P E D   Y O U ?           If I've helped you, help me help others!             http://CoverYourASP.com/Donate.asp ____________________________________________________________ Continuing thanks to all of you who wade through my site and this newsletter each week. If you're in Atlanta come and visit at the Atlanta ASP User Group, next meeting on January 16th. Check it out at http://www.aspusergroup.com/atlanta/ Speak to you next week. Warmest Regards, James Shaw [email protected] 885 Woodstock Road, Suite 430, #108 Roswell, GA 30075-2247, U.S.A. ____________________________________________________________                 S U B S C R I P T I O N S           Do you want to subscribe or unsubscribe?             http://CoverYourASP.com/Subscribe.asp ____________________________________________________________