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

Mar 3 2001 ____________________________________________________________               C o v e r Y o u r A S P . c o m              Welcome to the latest newsletter!                  http://CoverYourASP.com/ ____________________________________________________________ More sites appearing on the Internet based on CYA this week, some good, some bad! I only added one to my list of good examples shown on http://CoverYourASP.com/MiniMe.asp though. Two of the others I came across were p*rn sites, and particularly nasty ones at that. I can't describe the feeling - people say any publicity is good publicity, but I'm not convinced. Needless to say, they made no attempt to change the appearance in any way, like I ask, preferring to simply take the entire site as-is, with a new logo at the top. The only thing that cheered me up was when I thought that I should leave a "back door" in the code. Just thinking of the possibilities made me smile! ____________________________________________________________         A   W O R D   F R O M   M Y   S P O N S O R S                 http://www.nsoftware.com/ ____________________________________________________________ IP*Works! V4 ASP Edition includes 30 components, optimized for Active Server Page programming.  The standard IP*Works! components are all included, HTTP, FTP, SMTP, POP, IMAP, REXEC etc. Also included are new, higher level components such as WebUpload, WebForm, FileMailer, TraceRoute, and more.   The package includes sample ASP pages demonstrating how to access Web Services such as Yahoo Stock Quotes and UPS Address Verification.                 http://www.nsoftware.com/ ____________________________________________________________                     T H E   D I A R Y                The events of the last week             http://CoverYourASP.com/ShowDiary.asp ____________________________________________________________ ______ 26 Feb ______ - In recent weeks I have been getting more and more returned newsletters because the subscribers mail systems have been detecting the script in my newsletter, and refusing to deliver it to the subscriber. Although this is a laudable idea, my newsletter is not HTML, and no script will be run on your computers! Each of the sysadmin's I have contacted agree, but say that the software they use does not distinguish between executable scripts and articles *about* script. Sorry! ______ 27 Feb ______ - If you want an example of the power of SQL (the language, not the database) take this example. I wanted to display an approximation of the number of days left for an advertisers banner if impression and click rates continued. To do this I used this SQL: SELECT Round(([ClicksLeft]/[ClickRate]*100.0)*        ([EndDate]-[StartDate])/TotalImpressions,0) AS DaysLeft FROM BannerStats Pretty cool, huh? ____________________________________________________________          A   W O R D   F R O M   M Y   S P O N S O R S                   http://www.visualasp.com/ ____________________________________________________________ Download The VisualASP Component Pack v3.1 and start creating fast, lightweight web applications using ASP technology. Try the new TabView Component plus updated TreeView, ListView and MonthView Components. The Component Pack now contains an easy to install (local) examples site showing demonstrations and ASP Script source for each component.                   Download Version 3.1 Now.                   http://www.visualasp.com/ ____________________________________________________________            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 ____________________________________________________________ No new articles this week. I have a new excuse - I've been busy looking for a new house. Found one too, but nothing's been finalized yet... I have started compiling a list of changes that I'm having to make in order to move the site over to SQL Server 2000. I'm surprised how easy it was, but there were enough problems to make it "interesting". And I'm not finished yet. Change #1: change " to ' By default " is reserved for other purposes in SQL, so I changed over to wrapping any string fields with '. Here's a before and after:       SELECT MemberID       FROM Members       WHERE Email="j@a.com" becomes       SELECT MemberID       FROM Members       WHERE Email='j@a.com' Change #2: change # to ' SQL doesn't like dates wrapped in #, and prefers ', so:       SELECT BannerDescr       FROM BannerStats       WHERE BannerDate>=#03/01/2001# becomes       SELECT BannerDescr       FROM BannerStats       WHERE BannerDate>='03/01/2001' Change #3: Re-using aliases This is the most complicated, and one I needed help to sort out. I asked on the microsoft newsletter hosted at Shawn Jackson's http://aspdex.com, and got a reply within 10 minutes! Here's a simple example of what works in Access, but not in SQL:        SELECT a AS b, b+1 AS c        FROM MyTable Using the AS clause, I'm creating an alias 'b'. This alias is then used in a subsequent expression when creating 'c'. This works perfectly in Access, but maybe it shouldn't! I've been told that it shouldn't anyway, but there are probably lots of "opinions" on this. The answer is shown below. I had to stare at this for a few moments before it made sense...        SELECT V.b, V.b+1 AS C        FROM ( SELECT a AS b FROM MyTable ) AS V To show you why I gave a simple example, here is the query I actually need to get working in SQL!...        SELECT Banners.BannerDescr,        Min(BannerDate) AS StartDate,        Max(BannerDate) AS EndDate,        Sum(ImpressionCount) AS TotalImpressions,        Sum(ClickCount) AS TotalClicks,        Banners.ClicksLeft,        Round([TotalClicks]*100/[TotalImpressions],2) AS Rate,               Round(([ClicksLeft]/[Rate]*100.0)*             ([EndDate]-[StartDate])/TotalImpressions,0) AS DaysLeft        FROM BannerStats        INNER JOIN Banners ON BannerStats.BannerID = Banners.BannerID        GROUP BY Banners.BannerDescr, Banners.ClicksLeft ____________________________________________________________          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 20 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 ____________________________________________________________               H E R O   O F   T H E   W E E K ! ____________________________________________________________ More interesting facts from the server log department this week - I found another hero lurking there! Well, hardly lurking - http://tcp-ip.com/ sent me 18,000 pages worth of visitors in February alone! To put that in context, the second best referrer sent 6,000, aspin.com sent 4,500 and aspcode.com 2,500. So you can see why it was an easy choice this week. I asked them for some background info on who's behind this incredibly successful site - I was surprised to learn that it started as Bruce Knapton's personal collection of bookmarks! In his words: "it just sorta grew from there" His wife, Sherie, now runs the show and copes with the 350 pieces of daily email (can you imagine that much?) - but that's still not the best part. Sherie runs this site 99.99% on her own, and she has a full-time job working for Office Depot! As Bruce says: "She has absolutely no computing background, just seat of the pants learning. Hobbies include Marine Aquariums, raising Carnivorous Plants, Quilting and riding her Honda Gold Wing. The site is maintained in the morning and evenings as time permits." Kind of like my site, just a little bigger! (on last count they had 7,500 listings..) ____________________________________________________________                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/ ____________________________________________________________ I'm going to retire next month - I had 3 new $1 donations this week using that new Amazon.com Honor System! It's anonymous, so I can't thank you personally, but you know who you are. Thanks. Amazon takes a share so, I get $2.10. That's almost enough for my favorite lunch - a 6" Parmesan Italian BMT sub at SubWay. Who'll give me a cookie?   http://s1.amazon.com/exec/varzea/pay/TMXVAS3OE44G3 ____________________________________________________________         A   W O R D   F R O M   M Y   S P O N S O R S      http://www.hexillion.com/refer.asp?id=cya7&dest=%2F ____________________________________________________________ Get FREE sample code, online utilities, and articles at Hexillion. Add intelligence to your ASP applications! Look up Whois records, check email addresses, do DNS lookups, find network problems with Ping and Traceroute, and more. http://www.hexillion.com/refer.asp?id=cya7&dest=%2F ____________________________________________________________                      F E E D B A C K             Have something to say? Please share!             http://CoverYourASP.com/Contact.asp ____________________________________________________________ Rafael Archuleta and I swapped a few emails this week, lamenting the poor support PayPal.com have offered for sites that sell content, downloads or anything that can be accessed from the web. I confirmed to Rafael that there is no secure way to do this with PayPal - they don't even show as the referrer when they call the confirmation page after the transaction! Rafael then went on to say: "the 70% font size thing just doesn't work well for Macs... I have to set the text zoom in IE5 to 200% to be able to read the source code displayed on your page. You can probably guess how ridiculously huge this makes the rest of the text. Let me know if you would like any CSS to help with this problem." Me: Of course, that would be cool! I don't have access to a Mac, and basically no-one ever browses my site with anything but IE4+ on a PC! I've heard it before, but never seen it, but Mac text is far smaller than PC text. It seems that I'll have to set it to at least 95% when on a Mac. ______ Dan Streib: "Thanks in advance...(And howdy neighbor, from Kennesaw.) I am a  PHP pogrammer and now I am required (at work) to create a site using IIS and ASP. Viewing your source code today - and surprised to see the syntax SO DIFFERENT from ASP and SO MUCH LIKE PHP. :) Main Question:  Does using JavaScript vs VBscript have downsides?  Are all built-in "ASP" capabilities available? etc? Me: Yes, you can use either language as you wish - it's just personal preference. More jobs in VBS though, if you care. (my clients with small sites don't). ______ Michael Webb: "great site, great downloads, just wnated to know: how can I change the site content without hand-coding HTML? Dreamweaver just goes (blank) and so does Frontpage! Is there a program to do this sort of thing?" Me: Sorry, but I'm a handcode-only kind of guy! See why at http://CoverYourASP.com/DontRender.asp ______ Carl: "You mention that once payment has been taken on Authorize.net's form they redirect back to a page on your site. Is this page configured when you set-up with charge.com or hidden somewhere on their secure form? How do you detect a user who doesn't complete the authorize.net form, or if their transaction fails - do you get redirected to an alternative page if you so wish? Thanks for a useful and demystifying article!" Me: The reply page is configured on a setup page on their site, but you can also override it with a hidden field if necessary. All the data is POST'ed to this page, and you can see whether the transaction passed/failed in there. You can configure a confirmation email to you and the customer too. ______ Sanjay Nayak: "Dear James, I am trying to run an asp file from one server (Win NT and IIS) and using FSO, create a file in a mapped drive of another machine running NT (No IIS installed on this machine). The code is fine and works well on my own machine but gives a 'permission denied' error when I run it for a mapped drive. There is no help in MSDN or on the web. Me: Sounds like you just dont have permission - the anon internet user needs at least read permission to your mapped drive. Sanjay: "Thank you for replying so quickly, but yesterday evening I finally managed to solve the problem. The solution is that for any machine that you want to access, a user has to be created on that machine, with username 'IUSR_machinename', where machinename is the machine name of the web server. I don't think I can explain it correctly so please refer to these links and also share it with everyone on the mailing list. This solution took me 3 days to find out using Google.com and CodeHound.com and I hope somebody does not go through the same process again. The links are How does FileSystemObject access files from a UNC \\share\? http://www.aspfaq.com/faq/faqShow.asp?fid=55 Why do I get 'Permission Denied' errors with FileSystemObject? http://www.aspfaq.com/faq/faqShow.asp?fid=147 Microsoft does have a mention about the solution but as usual it is hidden in layers and layers of useless information. http://support.microsoft.com/support/kb/articles/Q197/9/64.ASP There is also a small mention on ASPFAQS.com http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=23 Thank you once again for replying so soon. In times of ASP-crisis, Microsoft is the worst place to turn to and people like you sincerely replying, helps a lot." ______ Scott Watermasysk: "A cool feature to add might be a dynamic bookmark. I think when you bookmark a page you get the default/index page, not the page you are currently viewing. I don't know if anyone will get anything out of it, but it could be cool. Me: Thanks for the feedback Scott! It does work that way already - the page you're on gets bookmarked. What is probably confusing (and needs changing) is that the bookmark is always called "CoverYourASP!", not the current page title. I'll fix that. (Since replying I checked out Scott's site - it's not finished, so I won't mention it yet - but thanks for the excellent link from your site Scott! Let me know when you're done and I'll give you a plug...) ____________________________________________________________         A   W O R D   F R O M   M Y   S P O N S O R S                 http://www.codecharge.com/ ____________________________________________________________ Powerful Code Generation tool for Professionals and Beginners - develop database-driven web applications in matters of hours. Developing anything from Grids & Forms to Portals and Intranet just became easier. CodeCharge generates ASP, JSP, PHP, Perl, CFML and comes with examples of Online Store, Bug Tracking System, Task Management System, etc.              Visit http://www.codecharge.com/ ____________________________________________________________             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 ____________________________________________________________ Anyone want a sneak peek at the soon-to-arrive "fun-style" CYA UI? http://CoverYourASP.com/images/CYAlogo.jpg You may not be able to tell how cool this is, but I will once and for all put an end to the emails telling me to get a professional looking site! It's my site and it'll be FUN if I want it to be. ;-) Thanks Guys! Speak to you next week. Warmest Regards, James Shaw james@CoverYourASP.com 885 Woodstock Road, Suite 430, #108 Roswell, GA 30075-2247, U.S.A. ____________________________________________________________    V O T E   F O R   Y O U R   F A V O R I T E   S I T E          (or don't, if it's not CoverYourASP.com) http://www.aspguild.org/group/~12/asp/voteasp2001.asp?a=171 ____________________________________________________________ ____________________________________________________________                 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 ____________________________________________________________