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 30 2000 ____________________________________________________________               C o v e r Y o u r A S P . c o m              Welcome to the latest newsletter!                  http://CoverYourASP.com/ ____________________________________________________________ A slightly newer look this week as I try to tidy up my appearance to attract all those advertisers! Freshly slicked back hair and polished shoes. Black Leather Briefcase. Not quite! I can't quite see me making a million from selling banner ad spots, but it was fun code to write. Shawn Jackson from ActionJackson.com was the first to step up and very grateful I am too. My hobby site might pay for itself after all... ____________________________________________________________                     T H E   D I A R Y                The events of the last week             http://CoverYourASP.com/ShowDiary.asp ____________________________________________________________ Oh dear. Not much happened in the Diary this week. There must have been some sort of distraction? ______ 25 Dec ______ - Happy Christmas everyone!   ______ 27 Dec ______ - Modified BannerCounter.asp - it now always increments the clickthrough counter, but doesn't decrement the ClicksLeft if it is a duplicate IP address or unknown browser. See the article at http://CoverYourASP.com/BannerApp.asp if you have no idea what I'm talking about... ____________________________________________________________            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 ____________________________________________________________ I did manage to write up two new articles this week about the advertising system though. The first one, "A complete banner advertising system" can be found at http://CoverYourASP.com/BannerApp.asp Serving up rotating banners for my advertisers, storing the ads in Application variables and tracking impressions and clickthroughs. ______ The second one is also advertising related - called "Limiting clickthroughs to one per IP address per day", it (obviously) describes how one of the requirements from the banner ad system was to protect the clients from spiders and malicious users, by ignoring multiple clicks from the same IP address on the same day. By "ignored" I mean I don't charge for them - they obviously still get to the advertisers site. hehehehe! Read about how that was done with a single Application variable at http://CoverYourASP.com/LimitIP.asp ______ The last change I've uploaded was simply to add my address to the contact and donate pages. I've been asked a number of times by people who want to send me stuff - boxes of rotten tomatoes perhaps? I guess I'll find out soon. ____________________________________________________________               H E R O   O F   T H E   W E E K ! ____________________________________________________________ Hasn't it got to be Shawn Jackson? Feedback and help with the site are the usual criteria, but the first man to send me advertising money has to qualify too! =;-) ____________________________________________________________                 M E M B E R S H I P   N E W S                Updates to Membership Services           http://CoverYourASP.com/MemberServices.asp ____________________________________________________________ Silver membership is almost here - hopefully in the next 2-3 weeks. There will be 3 step-by-step tutorials available to silver members initially, with more to follow as demanded. 1. Installing Personal Web Server - documents how to get ASP    running on your PC. 2. Installing CoverYourASP - shows exactly how to install the    download, configure the server, hook up the database and    email and get it running on your PC. 3. Troubleshooting - what those errors mean and how to fix    them. Many of you get stuck with errors when connecting    to the database. Silver membership will be a lifetime membership, i.e. you'll only pay once, and be a member for life. ____________________________________________________________                      F E E D B A C K             Have something to say? Please share!             http://CoverYourASP.com/Contact.asp ____________________________________________________________ Mark Johnson: "Is there a way to create a SQL query with a field that already contains a text version of someone's e-mail address but 'wraps' that address with the appropriate HTML code?" Me: Use a query like this, assuming the field is called Email and the table is MailingList, as on CYA: SELECT '<a href="mailto:'+[Email]+'">'+[Email]+'</a>' AS Link FROM MailingList ______ Arthur Flintoff: I want personalized settings on default page only to display if they are a signed in member, therefore making content invisible to non-members.  Can this be done? Me: Certainly, I have lots of examples on the site: If ( IsLoggedIn ( ) ) {    // signed in members only } else {    // everybody } ______ Bob Spellman: "How do you allow file download? I can't see anything in your source that would make your line.. <p><a href="FullSite.zip">Download the whole site</a> ..start a download of FullSite.zip?" Me: It has to do with the HTTP content-type - browsers will display the ones that they understand, and offer to save all others. The same thing happens if you try to open ASP files on your local computer by browsing to the file, instead of opening it by URL. The browser itself doesn't understand what an ASP file is - the server has to be involved to "turn it into" html. Here are some relevant articles on MSDN: http://msdn.microsoft.com/library/psdk/iisref/devs4rc5.htm http://support.microsoft.com/support/kb/articles/Q170/8/02.ASP http://support.microsoft.com/support/kb/articles/Q182/3/15.ASP But the best explanation comes from my MSDN CD - I couldn't find this online: "When the Web server returns a file to a browser, it tells the browser what type of content is contained in the file. This enables the browser to determine whether it can display the file itself or whether it has to call another application. For example, if the Web server returns a Microsoft Excel worksheet, the browser must be able to start a copy of Microsoft Excel to display the page. The Web server recognizes file types by mapping the file name extension to a list of MIME (Multipurpose Internet Mail Extensions) types. For example, to start Microsoft Excel, the browser needs to recognize the application/vnd.ms-excel MIME type. You can use the ContentType property of the Response object to set the HTTP content type string for the content you send to a user. For example, the following command sets the content type for channel definitions: <% Response.ContentType = "application/x-cdf" %> Other common content types are text/plain (for content returned as text instead of interpreted HTML statements), image/gif (for GIF images), image/jpeg (for JPEG images), video/quicktime (for movies in the Apple QuickTime(r) format), and text/xml (for XML documents). In addition, a Web server or Web browser may support custom MIME types. To see the content types already defined by your Microsoft Web server, use the Internet Information Services snap-in, to open the property sheets for your Web site, click the HTTP Headers tab, and then click the File Types tab. These file types may be used as a reference when you choose to manually set the content type with ASP." ____________________________________________________________             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 ____________________________________________________________ As always, feel free to tell me what you'd like on the site, and what mistakes I'm making as CoverYourASP grows up. December was another record month, even with limited traffic over Christmas - up 25% on last month. 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 ____________________________________________________________