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
115 active users
4306 visitors today
3214 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

May 26 2001


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

             Welcome to the latest newsletter!


For the past five weeks I have been getting the site to send
me an email whenever someone fails to find anything with my
search (

I did this mainly to see if there was something new that I
should write about, and to prioritize new articles.

Surprisingly though, no subjects stand out, although the
sheer volume of failed searches was alarming at first! So
far 1221 searches have failed. Many were typos.

I'll work through the list whenever there's a spare moment
and resolve some of them to existing pages.


        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



12 May

- Check out the improved database administration - now you
automatically get dropdown lists from foreign keys!


13 May

- I apologize but I failed to update every file in the
download - so the include/config.asp was missing the new
bDisplayAllianceBanners variable. You would have seen an
error about this when running the site. The download is
fixed now.


14 May

- As a follow-up to my "Accepting credit cards on your site"
article, I'd like to say how pleased I've been with Just as I hoped, they have been remarkably
helpful and efficient.

I'd also like to thank those sites that have signed up
through my link - a cool $200 check turned up today for
two successful referrals!


15 May

- has had a major re-write, and very
kindly included a special "CoverYourASP" section
dedicated to my articles. Check them out!


16 May

- It's moving day in the Shaw household, so I won't be
responding to any emails until Friday 18th - wish us luck!


18 May

- OK, I'm back. The new house is beautiful and there's even
something for you too - there is a new item on the
navigation bar above. "Directory" takes you to a huge list
of resources provided by!


22 May

- The Cable Guy gave me some bad news today - there is too
much signal drop over my 600 foot drive to get a cable
modem. So I have to use a dial-up connection for 2-4 weeks
while they prepare to dig up my drive.

Anyway, the good news for you is that I can now tell you
how to run my site with a dial up (I could never test it

When asked to "Connect" or "Stay offline", choose
"Connect". Then, when prompted to dial-up, choose
"Work offline".

It's a pain, but that's the only way to run ASP with a
dial-up. Or, of course, you could just stay online... ;-)


23 May

- Check out the new easy access to all of's
resources at the bottom of the front page. I've moved over
the ASPWire content to make room.

Now you never have to leave my site... ;-)


25 May

- Do you have the Alexa toolbar installed? If you do,
beware. I did until recently but there is a side-effect
you should be aware of if you are a web developer.

If you upload pages to your server to test them and think
it's safe because they aren't linked to from anywhere -
think again.

The Alexa toolbar is listening, and will happily cache
your "private" file and crawl it whenever it fancies...

        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.



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

        Please recommend my site to your colleagues


As promised, I wrote a new article about foreign keys.

"Displaying foreign keys in your database as list boxes"

My original database administration tool didn't look for
foreign keys, and just displayed a confusing list of
primary key values. Now, it's been improved with
automatically generated list boxes...


         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 !

Robert Brooks is this weeks Hero of the Week. Robert sent me
an email related to calling Server Side Includes from a HTML
page, or more accurately a .shtm page. Following my reply to
David in the last newsletter, Robert prompted me again to
give the correct answer!


"Thanks James, These files look like just what I
need. Do you have an example of calling an ASP function
from a default.htm file?"


"Actually, that's exactly the situation I was describing in
the note I sent about the obscure configuration option that
prevents duplicate headers from being output from .shtm
files.  In case you (or he) is still interested, here's the
original message.  Feel free to forward it to him... with the
note that he must use a .shtm (server-parsed html) file.

- - - - -
I was going crazy trying to find the fix for this problem!  
Now that I've (or more accurately, my host has) found it, I
want to share it with you.

I got into ASP by hacking around the existing code for  The site was primarily HTML with #exec calls to
ASP routines.  So most of the files had .shtm extensions,
and had calls like this:

<!-- #exec cgi="/common/ad_station_khyi_ampsite_1021.html" -->

Everything was fine until we went to move to a new host. It
was crazy - everything worked fine except that every .shtm
file with a server side include had the HTTP headers
repeated in the text sent to the browser!

The new host ( was a Linux house trying
Windows for the first time, so they were as stumped as I
was. And worse still, nothing on the 'net pointed to a

The most detailed fix was to find a way to wrap a meta-tag
around the unexpected text data - a most unsatisfactory

To make things worse, the problem prevented "default.shtm"
from being the default page. This made no sense at all.

Finally, after poring over the IIS settings and manuals, the
new host's webmaster found the solution.  Here's the note he
sent me:

>Believe it or not, a checkbox labeled "buffering enable"
>needed to be unchecked to get rid of both the can't get
>default.shtm and the wonderful header message across the
>top of the screen. So we've overcome that now.

So there you have it -- my contribution to the world of ASP.  
To enable SSI in .shtm files, you have to find an obscure
checkbox and uncheck it. I hope you find this info helpful!

Feel free to direct folks to to see my
100% ASP site in action.  All the .shtm files are actually
hiding calls to .asp modules - for example, the "jobs.shtm"
file is actually a call to something like this:
(munged for security):

<!-- #exec cgi="/textfile.asp?file=jobstuff.htm
      <em>Be+part+of+the+action!</em>" -->

jobs.shtm looks a lot better in the URL bar than that mess,
and I don't have to reveal the inner workings of my site.

Sorry about the long message -- I know you've got plenty of
mail to read!  Good luck, and God bless.


               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.


Ever seen "Syntax error in FROM clause" on your local copy
of CoverYourASP?

Chances are that you're appending ?SECRET=1 to the URL (see ) and there's already a
? in the URL.

Here's an example:

The correct way to append the password (or any subsequent
parameter to any QueryString) is of course like this, using
an & instead of a ?


                     F E E D B A C K

            Have something to say? Please share!



Trent Collie:

"I'm still wet behind the ears when it comes to ASP but
viewing the source code from your site has helped a lot.
The only problem that I am having is I don't have CDONTS,
instead, I'm using ASPEMAIL. My question/problem is this,
where would I put "" in the source code so that
it would recognize it?  Any help would be great. Thanks for
all the effort you've put into this for newbies like myself.  
Keep up the good work!"


My code sets the host to '' - the
'' is the sHostDomain set in include/config.asp.

But you can change the whole string to your 'smtp..' string
in utils/email.asp.


Tony O'Connell:

"Dear James, Firstly I would like to compliment you on your
brilliant website and code.

However, a friend of mine is setting up the software for me
and is running into a small problem. Our host (
specifies that only files outside the web directory are
writeable. Therefore we have to store our database in
D:\Webs\one\data whereas our webpages are stored in

Can you tell me which files to change so that we can point
to the access database in its new location?

We also have SQL setup. Is it very difficult to use SQL
instead of Access? If you have any documentation on this it
would be much appreciated."


Just change the connection string in include/config.asp.

The site will run from SQL if you change the sDBDriver in that
file too - but there are a few pages that use Jet-specific
SQL (like FIRST). But the vast majority is fine.



"Hi James, Are you still running your site on an Access
database?  If so, do you know how many active users the
Access can support before taking up so many resources that
it slows down a shared server?

I'm asking this because I was told I may need to upgrade to
SQL 7.0 due to my load, but it seems you have more people on
your site than I do.

Thanks, and continue good luck with your site.


Yes, I'm still using Access 2000. No-one knows "the limit",
but my site seems fine with ~10,000 page views a day.

Make sure you use connection pooling - see the Hero of the
Week section in this old newsletter:


         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, light weight 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 component.

                Download Version 3.1 Now.



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

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


         ===> now with new ways to say thanks! <===

Thanks Guys! Speak to you in two weeks.

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

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?

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!

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!