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
177 active users
4594 visitors today
3452 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

Dec 30 2000


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

             Welcome to the latest newsletter!


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


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


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

Serving up rotating banners for my advertisers, storing the
ads in Application variables and tracking impressions and


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


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


Silver membership is almost here - hopefully in the next 2-3

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!



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?"


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?


Certainly, I have lots of examples on the site:

If ( IsLoggedIn ( ) )
   // signed in members only
   // 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="">Download the whole site</a>

..start a download of"


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:

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/ 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!


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?


Featured sponsor
My favorite resources

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?

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

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

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!

Qualify for Free Trade Magazines

Free subscriptions to industry leading publications for those who qualify!

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...