CoverYourASP --> Newsletter archives

Free membership

Join in the fun! Sign in
Member Services

Site navigation
Download the entire site!
Search my articles
Free Magazines
Browse the directory

Send me feedback
Buy my boxer shorts

Recommend this page
Printer-friendly page

Resources I recommend
Link to my site
Advertising slashed!
About your privacy
Legal stuff
Site statistics
64 active users
3788 visitors today
2795 pages today
(only part of today)
Tools I use

Copyright © 1999-2016 James Shaw.
All rights reserved.

RSS submissions

Now open source with SourceForge!

Pick a newsletter to read - you can receive these every Saturday by subscribing.

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 27 2001


              C o v e r Y o u r A S P . c o m

             Welcome to the latest newsletter!


A lot of downtime all around this week! Some voluntary and
some not so voluntary - I'm just glad that I wasn't alone.

Spookily I even found a problem on Friday with my DNS setup
that is still unresolved - but at least I have a secondary
DNS that is still working. ;-)

Apparently it's been broken since November, so I'm not going
to panic. don't *seem* to have updated the IP
address of my primary DNS that was changed over 2 months


        A   W O R D   F R O M   M Y   S P O N S O R S

Get FREE sample code, online utilities, and articles at

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.


                    T H E   D I A R Y

               The events of the last week



21 Jan

- Added a little exception handling to utils/database.asp.
This is just the start of putting using real error handling,
and was just hacked in this morning in response to the
security issue I found. I'll document it when my heart rate
returns to normal...

- Had to take the site offline for a few minutes this morning,
then the T lines went down for 4 hours...Sorry! The problem
was upstream, not with my ISP.


22 Jan

- It took me a long time, but I finally found out why "once a
day" scripts were sometimes happening more than once a day!
My Banner reports page refreshed the Application variables
containing the banners whenever clicks were moved between
banners by an advertiser. How? By setting
Application('BrandNewDay')=1 !! (see LimitIP.asp for an
explanation). It is now fixed...


23 Jan

- Hakan Eskici just pointed out a potential problem with the
code that ignores IP addresses. It was "possible" to ignore
an IP address that shouldn't have been. Note that advertisers
would have got more free clicks, not less, so no-one's

- Added a new page to the trouble shooting section to help
you fix problems installing Personal Web Server.

- I succumbed to reason last night and added the Opera browser
to the list of "supported" browsers to my clickthrough
system. To make it easier to share the code I added a new SSI,
called Browser.asp which contains a new function
IsKnownBrowser( ).


24 Jan

- I enhanced (my still undocumented) exception handling in
utils/Database.asp a lot tonight. Now you get much more help
when you get ADO errors when first setting up the site on your
computer. And if the real site ever gets an exception when
connecting to the database I get sent an email. I will write
an article on exception handling this week.

- Fed up with receiving emails from my HTTP 500 error handler
when people load my Server Side Includes directly, I modified
Handle500100.asp to only send email if the page in error is
in the root folder.


25 Jan

- Touched over 70 files again today - improved the breadcrumbs
on the multi-page articles so that you could jump to the start
of the article, and found an amazing HTML error - I use &#0149
all over the site for my bulleted lists, but it should be
• (note the semi-colon) oops!

- If you're getting the message "'oRecordSet.EOF' is not an
object" please download the source again - the error reporting
has been much improved!

- Quick Tip: Don't trust anyone that quotes how many "hits"
their site gets! My recently enabled WebTrends log analyser
shows me for the first time this statistic and it looks very
impressive to the uninitiated - I'm getting 2 million hits per
month at the moment! Hits are requests for any file on your
server - SSI, images, even the robots.txt file!


           R E C O M M E N D   T H E   S I T E !

        Please recommend my site to your colleagues


Two new articles this week:

"Using exception handling to trap database connection errors"

To make setting up my downloaded site on your computer easier
I use exception handling to trap any errors that occur when
connecting to the database...

"Please help me design my new search facility - take the survey!"

There are three proposals on how I will add searching to my
web site - which one would you prefer?

And one updated article:

Over the last month I've been moving away from displaying
pages and pages of source code without documentation. All
my latest articles are heavily documented "snippets" of code
rather than the old "here's the contents of the file".

Now I'm going back through the old pages (I can't call them
articles) and revising them. The first to be revised is the
page that discusses my Server Side Includes. Rather than
displaying the contents of 12 rather large files I now give
an overview of SSI, then describe each one individually.

To try and be helpful I have cross-referenced the relevant
articles to each SSI, so you know where to read more.

Worth a re-visit.


              H E R O   O F   T H E   W E E K !

Jon Gilkison takes the honor this week.

Jon sent in the following email - definately above and

"I love your site [always a good way to start an email!],
it's great to see someone doing ASP in javascript.

Your database.asp file is great, I added some functionality
to it that you might enjoy:

Added a DBRowCount() function to return the number of rows
in a result.

Took your functions and wrapped them up in a javascript

     db = new dbConnect ( );
     records = db.query( "SELECT * FROM someplace" );
     db.execute ( "UPDATE..." );
     db.close ( );

Also, added two unique functions, converting a record set
into an array of javascript objects and a function to
convert a recordset into XML text.

Again, thanks for the great resource!"

Thanks Jon. Integrating this and continuing with the theme
is on my list of things to do, but I promised a search and
a few other things first!

For those of you that want to see Jon's efforts you can view
it here:


               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.


Added to my collection of domains this week. Can't resist!

I have been reading "The 22 Immutable Laws of Marketing"
and was thinking about Law#2, the law of the category. If
you can't be first in a category, create a new one.

Since I'm the only ASP site to offer itself up completely
for download I thought that could be my category.

As an extension of that I looked for domains, and my second
choice was available so I snapped it up. I am now the proud
owner of http://DownloadASP.NET - currently pointed at
the CYA site. is not being used, but it's already
registered by NetZero of all people!

So, in a couple of years, when "Classic ASP" is just a quaint
memory and ASP.NET is the technology of choice I'll have
CoverYourASP.NET and DownloadASP.NET to serve you with!


         A   W O R D   F R O M   M Y   S P O N S O R S


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 just to name a few.

If it's on the NET it's on Devdex!



                     F E E D B A C K

            Have something to say? Please share!



I usually have to filter the feedback and pick out the
choicest topics, but not this week. When I went into my
Feedback folder where I put interesting emails of the week
the cupboard was almost bare!

Instead, I'll mention a pleasant email I received from Eddy
at - CoverYourASP is this weeks site of
the week.

Go check out my interview!


            H A V E   I   H E L P E D   Y O U ?

          If I've helped you, help me help others!


By the way, it's my birthday today - 37 years young and
feeling more like 67 when I see all those 24 year old
billionaires writing revolutionary web apps!

I'm pacing myself, that's what it is. "Millionaire by 40"
sounded so much more feasible when I was 25...

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.


P.S. Thanks for keeping me at the top for the whole of the
first month of voting - only 10 more weeks to go!

   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

                S U B S C R I P T I O N S

          Do you want to subscribe or unsubscribe?


Featured sponsor
My favorite resources

I share my content

Supporting ASPRSS

Do you need a quick and easy way to link to my articles? All the information you need is published with ASPRSS...

See my source code
wherever you see this icon...

You can also download the entire site source code for FREE!

Qualify for Free Trade Magazines

Free subscriptions to industry leading publications for those who qualify!

CoverYourASP Mugs, T-shirts, caps - even Boxer shorts...
I don't make a penny from these, but they're a lot of fun! Don't you need a new mouse mat?

New Proposal Kit Professional 5.1
Brand yourself as a top professional: create quotes and amazing proposals and get many legal documents free!

The latter saved me 3 times the purchase price on the first day I owned it!