|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 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
Oh dear. Not much happened in the Diary this week. There must
have been some sort of distraction?
- Happy Christmas everyone!
- 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
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
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
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!
"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
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
"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?"
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
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/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!
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.
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?