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

Feb 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/ ____________________________________________________________ I have been pleasantly surprised to see sites springing up based on my code. I won't mention the sites by name, yet, but I'd like to start compiling an online list of them on the site. They are very impressive web sites in their own right - but I can recognise parts of forms, or odd words here and there! Of course, these guys have my full support. As my Legal page attempts to make clear, these sites are using my code exactly how I intended. If any of these guys are listening, I'd love to give them some free publicity, so please contact me: "tractor guy", "biz guy", "connect guy", "education guy" and "south pacific guy"... ____________________________________________________________         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 ____________________________________________________________                     T H E   D I A R Y                The events of the last week             http://CoverYourASP.com/ShowDiary.asp ____________________________________________________________ ______ 27 Jan ______ - Apologies to the newsletter subscribers - I got two copies this morning, so I assume you did too! Since I only sent it once this time, I'll have to do some investigation... ______ 29 Jan ______ - Just so that you know, I'm busy reviewing every page of every article on the site and typing in keywords for the search functionality due out by the end of the week. I may still implement the HTML search too (see my survey), but the keywords will come first. And, I want you to know that it's hard work...;-) ______ 30 Jan ______ - I improved the DBEditTable.asp page today - just two small changes, but they make a lot of difference! First, You can now sort the table by any field by clicking on the field name. Clicking again will toggle between ascending and descending. The second change was just to wrap the code with a try...catch to trap errors caused by the query. ______ 31 Jan ______ - Seems quiet this week, but I've been beavering away behind the scenes! Tonight I will finish the manual indexing of all the keywords in my articles, and tomorrow you will finally be able to search the site! ______ 1 Feb ______ - A few of you have noticed that you cannot sort the BannerStats table by the BannerID field. That's because I use an INNER JOIN to another table with that field also, so my generic ORDER BY generates an error: "The specified field 'BannerID' could refer to more than one table listed in the FROM clause of your SQL statement". Since this error is only caused by the way I hide the real content of that table, I now simply ignore your request to sort by that field. - Here's a question - why are 6 out of the 20 prospective members (those that haven't yet confirmed their membership) using rediffmail.com email addresses? Is it coincidence? Certainly it is a domain where the majority of people ask to sign up, then 10 days later the account gets automatically deleted... - Search away! - an article on how I implemented the keyword search is coming soon...the source code is already in the download though. ______ 2 Feb ______ - Come on everybody, get voting! Click on my new catchy random rotating incentives on the right. What I really need are some cheerleaders up here...got any spare? ____________________________________________________________            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 ____________________________________________________________ Only one new article this week, but it was a doozy: "Adding search capability to CoverYourASP" See how a single Server Side Include containing a single function is all you need.. http://CoverYourASP.com/SearchDescr.asp More on search coming soon though... ____________________________________________________________          A   W O R D   F R O M   M Y   S P O N S O R S                 http://www.visualasp.com/ ____________________________________________________________ Thanks for welcoming aboard Neil from VisualASP.com, my latest advertiser. Many of you have been visiting his site since the banner went live on Thursday - so many that his banner won't last long! I seriously love his components. To be honest I hadn't seen them before, but they are sooooooo cool. I am amazed that they are all pure server-side components - you can make your web site look like a Windows Application without anything but HTML being sent to the client. ____________________________________________________________               H E R O   O F   T H E   W E E K ! ____________________________________________________________ Bob Spellmann takes the honor this week. Bob has regularly sent in helpful tips and suggestions, all explained in great detail and clarity. Thanks Bob. The only slightly odd thing I've noticed is that he's one of the 3% of visitors that use that old Netscape thingy... ;-) ____________________________________________________________                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 have to say a quick hi to a new subscriber before I forget. They said later that they read the whole thing from top to bottom, and it was "very nice". So, this is a test.                                  Hi Mum. ____________________________________________________________          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 ____________________________________________________________                      F E E D B A C K             Have something to say? Please share!             http://CoverYourASP.com/Contact.asp ____________________________________________________________ Abdel: Subject: Showsource.asp?page=contact Message: "Hi James, As the subject of this message puts it, I'm interested in the way you display some of your pages, (also commonly used on web sites) using the URL stated as the subject. Are u documenting this anywhere ? Me: I'm surprised to find that I don't! You can pass parameters into a page using this syntax: (by the way, this is how forms with an action of GET send their data to the server)     http://test.com/page.asp?a=1&b=2&c=hello. Then use Request.QueryString ( 'a' ) to return 1, etc. To "cast" them into numbers or strings use this syntax: var sString = '' + Request.QueryString ( 'c' ); var nNumber = Request.QueryString ( 'a' ) - 0; ______ The Mad Hacker, aka Hakan Eskici, aka "TableEditor man": "I've found a potential security flaw in.." and "I've tried something that all of us usually forget..." Me: Hakan, what would I do without you? I won't publish your emails, or my responses until I've fixed the second one - your email only came in after I'd started writing this newsletter. ______ Ismed: Hi James! I found error when ran your code on my NT4 wstation using the downloaded PWS from MS. The error found as follows : Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /cya/utils/Email.asp, line 28 Invalid class string What does it mean James? Me: It means that you don't have an entry in your registry for the ProgID you used in the Server.CreateObject call. In your case, the SMTP service isn't installed, so there is no registered COM component called "CDONTS.NewMail". Haven't got an NT4 box to hand, but look in Control Panel, Add/Remove Programs for an SMTP entry. ______ Randy had a number of problems connecting to his database, and many emails were exchanged. It turns out that his ISP *insists* that everybody's databases are placed in the same single folder on the server. That makes it almost impossible to reference with a DSN-less connection since it requires the path of the database. Why "almost" impossible? Normally you don't know, or want to know, the absolute path of your web site on the server. Everything is relative to the root of the site. The database in my download is in the folder "DBPATH/DB.MDB". That relative path is turned into the absolute path that the connection needs by calling Server.MapPath( ). The problem with Randy's ISP is that Server.MapPath won't return an absolute path if the relative path is outside your web site, i.e. you can't do this:   sAbsPath = Server.MapPath ( '../../../JimsSite/DB.mdb' ) Remember, is an ISP insists on this scheme it's because he wants to charge you for a DSN connection - most do, and make his life easier, not yours. Which means that you should visit http://EverPlanet.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 ____________________________________________________________ Following the hassle that the latest advertiser went through to send payment I shall be investigating accepting credit cards and checks online next week. Hopefully that'll go through ok, and you can see how all that is implemented. And those of you that are lined up to send in donations, but can't use PayPal, can use that instead. ;-) I joke about it, but did you know only 6 people have ever done so? Now that's an exclusive club to join! One last thing - I'm still hanging on to the lead in the ASP Guild competition (see below), but the traffic that "the other site" gets is finally taking it's toll. With them having almost exactly 10 times the page views in January that I got, I'm still proud that we kept the lead for the whole month. I bet they didn't get emails from their readers saying they had dynamic IP's and could vote every time they dialed up... Thanks Guys! Speak to you next week. Warmest Regards, James Shaw [email protected] 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 ____________________________________________________________