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
137 active users
4527 visitors today
3399 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 6 2001


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

             Welcome to the latest newsletter!


If you thought I was surprised when I got my first advertiser
you should have seen me when CoverYourASP took first place
this week in the contest for the ASP Guild's 2001 English
Language Help Site Award!

Considering my site has a 50th of the traffic that some of
the big ASP sites have, I realize that it won't last. But
it's fun while it lasts.

If you haven't voted yet, I'd appreciate one from you!

P.S. Get you mother,aunts and old school friends to vote too.


         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!



                    T H E   D I A R Y

               The events of the last week


30 Dec

- Found another spider crawling the site this morning -
HTTrack has now been added to the list of user agents shown
the JustDownload.htm file..


31 Dec

- Happy New Year and best wishes for a successful and
prosperous 2001!


2 Jan

- Fixed two errors in BannerReports.asp - asking to view a
Banner By Day report for dates where no data was available
would cause an ADO error, and the date/month were backwards!

It worked where it was obvious, say 29/12/00, but not when
it wasn't, like today, 1/2/01!!

- The silver members only content is now up to 20 pages,
and is being proof-read before the new area is launched.
Watch this space...

- It doesn't look like much has been updated recently, but
a lot of pages have been improved in little ways. For
example BannerReports.asp got a link to the article that
explains how multiple clickthroughs are ignored. No changes
big enough to mention on their own, but things are changing!


3 Jan

- Another milestone reached today - my 100,000th visitor!


5 Jan

- The new HTTP 500 handler installed this week (see below)
has found numerous errors that you guys have been getting,
but not telling me about (tut,tut)!

The latest required changes to DBEditTable.asp, since it
didn't even allow you to view any records in the
BannerStats table. Now fixed!


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

        Please recommend my site to your colleagues


One new article this week:

"Trapping HTTP 500.100 ASP errors in your pages"

Learn how to replace the infamous "Page cannot be displayed"
with profuse apologies and an email moaning to the

I've used this code for some time on my IIS 5 development
machine, but until recently my ISP had me running on NT 4,
where the error handling didn't seem available for 500.100

I suddenly realised on Monday that my ISP was now IIS 5, so
I set it up, and then wrote about it.

So far it (you?) have found numerous errors in the site, all
of which have now been fixed. The importance of handling this
error can't be over-emphasized.

It also showed up something I wasn't expecting - users
trying to load the SSI files in the utils folder directly.

I may improve the Handle500100.asp file so it tells the user
what they've done wrong - I can tell because they'll be
getting a VBScript error (shock, horror).

     Microsoft VBScript compilation
     Invalid character
     /utils/init.asp, line 21

VBScript? Well, the SSI's don't have a @language in them
because they rely on being included in a "real" page, and
the default language is VBScript...


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

Steve Moore and I had a conversation this week. Steve has
offered some excellent advice to me in the past - this week
Steve asked this question:

"Talking about using access databases, are you using
connection pooling?"

The short answer is No, but the theory is easily understood.
A pool of connections to the database is shared across ASP
sessions, like a cache. Calling DBReleaseConnection as soon
as possible after using the recordset is crucial, since that
is when the connection is given back to the pool.

What I didn't know, or even investigated, was how to set it
up. I was saving all this "tuning" for when I moved to SQL...

Anyway, Steve gave me the push and the instructions I needed:

- Open the registry editor by running the regedit tool
  (Run regedit.exe).
  Microsoft Access Driver (*.mdb) registry key.
- Check if CPTimeout string exists.
- If the CPTimeout string does not exist add the Key string
  via the Edit, New, String Value
- The CPTimeout Key string should be set to 60 (60 seconds)

As always, whenever the registry is mentioned, you see a

Of course EverPlanet, my ISP, implemented this within 15
minutes of being asked.


               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.


Thanks to Charlie Bass too, of the ASP Guild. He helped me
by fixing up the mess I made of signing in and updating my
affiliate details. Also by adding me to the Award list in
record time!


                     F E E D B A C K

            Have something to say? Please share!



Arthur Flintoff:

Have you any idea's for creating a search of LongDescr by
keyword? or range searching numerical values?  As you can see
I'm wondering if some of your codes can be used to create
a Search.asp.


I guess I’d just use SQL to do the search, i.e. if “hello”
entered, I’d search for  

SELECT * FROM SearchTable WHERE LongDescr LIKE “%hello%”

Tip: % means "anything", like *, but it works in Access and
SQL. From my limited testing it seemed that SQL didn't
understand *


Prabhvir Sahmey:

Hello, your survey app is a good example, but 1 question...
what happens when we have 2 questions of the same type or
with the same name, considering that each user can create a
seperate question...?, as defined in your db structure, the
table "SurveyQuestions" cannot have similar questions, is
there a way out for this?

Secondly, I am using Access for this project and will later
use the "Upsizing Wizard" to use SQL Server, I need to know
would there be any changes in my SQL Querys?


You're right, I hadn't noticed that because I never did a
second survey! I should have either:

a) add a AutoNumber QuestionID field, and modify the queries
to use that, or
b) add the survey name to the primary key.

I'd pick a) - I'll add that to my list. Thanks for pointing
that out.

The same queries will run in Access and SQL if you're
careful, but since I'd recommend moving to stored procedures
during the upsizing it isn't that relevant.

There were some issues with syntax, like using % as the
wildcard, not *, and using ' not " to wrap field data, but
unless you have hundreds of queries it won't take long to
change them. The upsizing wizard may even help for all I



Hi, I noticed you said that you can convert normal HTML pages
written in FrontPage... which is exactly the same program I
use... convert them into ASP pages.

Could you tell me exactly how you do this?


I don't remember saying that, but simplistically, just
renaming them to .asp makes them an asp file.

What I mean by that is that the file will be processed by IIS
as an asp file, it just won't find any script in there to

To add some script, add a line at the top specifying the

<% @language=javascript %>

Anything inside <% %> is interpreted as asp, so as an
experiment you could add this next line in the middle of
your body:

    This is just some html text, this page is called

That's a simple start. Now look at files like my Date.asp
to see how to progress...Have fun!


Joseph Anderson:

[Inside a 404 error handler..] when I do VBSCRIPT

    mylocation = Request.ServerVariables("SCRIPT_NAME")  

I get "/404.html" instead of whatever I typed in to screw up.
(like //, testing - you know)


When a 404 page gets called, it's in this form:


The querystring contains a "404;" followed by the name that
couldn't be resolved. Using QueryString without a variable
returns the whole thing rather than one part, which is why
I do this:

    var sMissingPath = '' + Request.QueryString ( );



A few days ago, I was having problems logging out of your
site.  You suggested deleting the cookie manually, and
that worked.  Thanks!


I don't know why, but 2 or 3 people have had problems
signing out. The cookie keeps signing them back in, i.e.
it's not being deleted as it should.

If anyone could shed some light on this...


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

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


Continuing thanks to all of you who wade through my site
and this newsletter each week.

If you're in Atlanta come and visit at the Atlanta ASP User
Group, next meeting on January 16th.

Check it out at

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

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

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?