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
121 active users
422 visitors today
332 pages today
how is this done?
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

Mar 3 2001


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

             Welcome to the latest newsletter!


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


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

The package includes sample ASP pages demonstrating how to
access Web Services such as Yahoo Stock Quotes and UPS
Address Verification.



                    T H E   D I A R Y

               The events of the last week



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:

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


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

                  Download Version 3.1 Now.



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

        Please recommend my site to your colleagues


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


      SELECT MemberID
      FROM Members
      WHERE Email=''

Change #2: change # to '

SQL doesn't like dates wrapped in #, and prefers ', so:

      SELECT BannerDescr
      FROM BannerStats
      WHERE BannerDate>=#03/01/2001#


      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, and got a reply within
10 minutes!

Here's a simple example of what works in Access, but not in

       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,
       Round([TotalClicks]*100/[TotalImpressions],2) AS Rate,              

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


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

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



              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 - sent me 18,000
pages worth of visitors in February alone!

To put that in context, the second best referrer sent 6,000, sent 4,500 and 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

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.


I'm going to retire next month - I had 3 new $1 donations
this week using that new 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?


        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.


                     F E E D B A C K

            Have something to say? Please share!



Rafael Archuleta and I swapped a few emails this week,
lamenting the poor support 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


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

Main Question:  Does using JavaScript vs VBscript have
downsides?  Are all built-in "ASP" capabilities available?


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


Sorry, but I'm a handcode-only kind of guy!

See why at



"You mention that once payment has been taken on's form they redirect back to a page on your

Is this page configured when you set-up with or
hidden somewhere on their secure form? How do you detect
a user who doesn't complete the 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!"


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

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.


Sounds like you just dont have permission - the anon internet
user needs at least read permission to your mapped drive.


"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 and and I hope somebody does not go
through the same process again.

The links are

How does FileSystemObject access files from a UNC \\share\?

Why do I get 'Permission Denied' errors with FileSystemObject?

Microsoft does have a mention about the solution but as
usual it is hidden in layers and layers of useless

There is also a small mention on

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.


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


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.



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

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


Anyone want a sneak peek at the soon-to-arrive "fun-style"

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

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

                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

Qualify for Free Trade Magazines

Free subscriptions to industry leading publications for those who qualify!

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!

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

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?