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
279 active users
2285 visitors today
1690 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

Feb 17 2001


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

             Welcome to the latest newsletter!


I got approved to accept credit cards this week - quite
surprising since I have the credit rating of a 16 year old.

One thing to remember when moving countries like I did when
I moved to America 3 years ago, your credit rating doesn't
come too!

So, it'll be the subject of an upcoming article which should
be quite useful. To start with I'll use the forms on the
Authorize.Net server, but I'm planning to get my own
security certificate so you can see how to implement
everything in-house with full SSL security.

Should be fun!


        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.



                    T H E   D I A R Y

               The events of the last week



11 Feb

- As the site's popularity continues to accelerate, I passed
the 1,000 subscriber to the newsletter today. Thanks to
everyone for wanting to stay in touch!


13 Feb

- Last night I made a simple change that dramatically improved
the speed that my pages loaded. Should have thought of it
before really. The SiteMeter counter that I use was inside
the <table> that my page displays in, so browsers couldn't
render the table until the image was generated. Just by
moving it outside the table the whole page still appears
instantly even when SiteMeter are down. Changed utils/Footer.asp

- Remember to go out at lunch time or leave work early tonight.
I don't want to get blamed if you forget your valentines gift!
You can read my articles tomorrow... ;-)


14 Feb

- I've added another page in the troubleshooting section, this
time explaining what to do when you get a JScript compilation
error '800a03ea'...

- Thanks in part to 4GuysFromRolla, who kindly put me on their
front page yesterday, I had the best day ever. Over 12,000 page
views, with peaks of more than 1,000 an hour mid afternoon. All
on my ISP's cheapest shared hosting plan and an Access database!


15 Feb

- People have asked about the server the site runs on - it's a
dual Pentium III 600, 1 GB ram, Raid 5 10K rpm drives with 4MB
cache on each drive. Raid controller has 32MB cache. It runs
Windows 2000, IIS 5 and I share the server with 120 other sites.
It uses ASPMail for email and Access 2000 for database.


16 Feb

- Had a little re-design last night - I made the site 800 wide
rather than 640. Very, very few of you are using 640 resolution,
and I need the right column bigger for 130 pixel banners for my
advertisers! Hopefully everyone agrees this is a better use of
your screen though... please let me know if you see something
that doesn't "look right" now.


         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!



           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'm not sure where the week went.

Perhaps it was all that time spent searching for Valentines
presents! Sorry, but have you heard the English saying:

"It's like Number 10 buses. None come for an hour, then 3
come at once."

I don't even remember if "buses" means anything to Americans.
I have a sneaking suspicion that it might have another
meaning here!


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

Scott Mitchell - the only one remaining from the original
4GuysFromRolla - is this weeks hero.

Scott did me a favor by linking to my PWS article from the
front page of the hugely popular web site
and traffic increased because of it.

It was a nice surprise because I hadn't asked for the link!

Thanks Scott.

You know how you imagine someone, then you see a picture of
them and it's completely different? Take a look at this, and
tell me you're not surprised!

Remember that this guy has created a *very* successful web

Suddenly I feel very old.


               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.



        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!




"DBEditTable erroneously shows null dates as 12/31/69 (which
is probably the minimum date) when calling FormatDateDMY
(or FormatDateDM). The following is a fix:

function FormatDateDMY ( dateSeed )
     var dt = '' + dateSeed;

     if ( -1 != dt.indexOf('undefined') ||
               -1 != dt.indexOf('null') )
          return '';

     var date = new Date ( dt );

     return '' + (date.getMonth() + 1) + '/' + date.getDate()
          + '/' + date.getFullYear();


Thanks Dano!


Ken Reed sent me an interesting link this week. I've mentioned
before that my email client, Outlook, is very strict on what
attachments it allows me to open. For example, you can't send
me an Access mdb database. If you do, I'll see the paperclip
symbol, but won't be able to even save the attachment to disc!

I could find nowhere in Outlook or Control Panel to disable
this feature, so I have to keep asking people to send files
in zips.

Ken pointed me to a link that explains how to add or remove
file extensions to this "dangerous" list:


Liam Cassidy:

"My name is Liam, I just applied to join your site - it's
INCREDIBLE, and I am in awe!  Congratulations, and many
thanks for making it so wonderfully accessible to the public.

I have been asked to relaunch my site - I'm doing this using
ASP to deliver dynamic content from a database.

I'm using Macromedia DreamWeaver Ultradeveloper to create the
recordsets for connecting to the dbase.  Accessing the
database tables and migrating text into a web page is easy -
I can do that.  But UltraDev doesn't support binary images -
so cannot build recordsets capable of uploading or
downloading images to/from the database.

I hope you don't mind me asking you for advice - it's hard to
find anyone (or any material) that helps, and that DOESN'T
cost the  earth!  (I certainly can't afford the #500
consultation fee I was quoted by an "expert" last week!)

Of course, any help that you can give us would be greatly
appreciated - and we would be happy to link to your site from
a new site when it launches."


I think you may be going down the wrong track to look to store
images in the database. I'd strongly recommend storing the
images in a dedicated folder, and keeping the URL to the image
in the database. Your database will be much more efficient that



"The example that you have for implementing forms does not work.
You might want to recheck. There are numerous errors contained
with it."


What can I say? It *is* my code, in use many times a day at my
site. I can only assume that this person tried to copy/paste
into a new asp file which on their system probably uses VBScript
by default. If they're listening, I'd be interested in more


Steve Moore:

"Have you written anything that automates Microsoft
Access database compactions? With ASP?"


Here are a few links to read. On second glance it looks
like it may be possible to do this to databases on your
web site!



"I really like your site.  I am trying to add a lastupdate
part to the site. It is based on your site. I keep getting
object not found when I am trying to do a document.lastModified.
How do you add that to the site?"


I'm assuming you're talking about the date the page was last
modified? If so, you can't use document - that's client-side.

Look at the online FileSystemObject documentation at

The File object has DateCreated, DataLastAccessed and
DateLastModified properties that should do what you want.



"Hi James, Just wondering how easy and quick it was for you
to re-design all your site's page? In which file is this
code stored?"

By the way, you may activate the link to
if you want (sites based on yours)"


To make the change to increase the width to 800 pixels it
took just a change to a single byte!

Go to utils/Header.asp - there's a line that used to say:

      var nCurrentWidth = 0;

It now says:

      var nCurrentWidth = 1;

Quite an easy change! Because I had to support resizing of
the tables on the client-side in my article at I have an array that
contains the screen widths to resize to. By changing the
line above I've just changed the default width to fit 800
rather than 640.


         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!


Have a nice long weekend break, I will!

For the first time I get Presidents Day off from my "day job",
there's a beautiful sunrise outside, and my kids are being
quiet. Just need an advertisers check in the mail, and it'll
be perfect!

Thanks Guys! Speak to you next week.

Warmest Regards,

James Shaw

[email protected]

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

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

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!

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

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