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
102 active users
4284 visitors today
3193 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

Apr 8 2001


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

             Welcome to the latest newsletter!


Normal service will now resume! I've had a nice vacation,
read and/or answered the 600 emails waiting for me, and now
it's time for this, my last item of the to-do list.

Then I can do some work!


        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



6 Apr

- I'm back! I had an excellent time, but response time may
still be a little slow to your emails - I have over 600 to
sift through... ;-)


7 Apr

- Thanks to the anonymous user who pointed out that the link
to the source code of utils/database.asp was broken on the
Server Side Includes page.

That's now fixed, and I now get emails when similar things
happen - my ShowSource.asp page doesn't show files that
don't appear in its switch statement just to give me the
option of hiding some files on my site!


         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!



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

        Please recommend my site to your colleagues


Of course, no new articles this week, but I have improved
the Server Side Include page - there's now a "View the source"
link next to each SSI.

This will allow you to see the source for particular files
without downloading the whole source code. You could always
copy/paste the code into a new file if you wanted to get the


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

Since I've been on vacation, I haven't prepared anything or
been able to get a decent biography from a real hero, so
I'll take the easy route (no change there) and nominate my
wife Tara.

She's sitting in the room with our 20 month old son Jesse
fast asleep on her lap, knowing that she can't talk to me
(well, she can, but she knows she only gets grunts back).

I sit in front of this beige box quite a lot as you can
imagine (try every minute that I'm not doing odd-jobs), but
strangely I don't get any grief for it.

I think it's because she's amazed that one of my
hair-brained ideas actually became successful.

I've had quite a few attempts at doing something
(anything?) from selling craft-fare trinkets mail order
(I sold 11) to investing in rare coins (he was a conman) to
spending 12 months with 3 partners writing a huge web site
that never got launched, and now sits on my "maybe-next-year"

I should have asked previous heroes, but I wonder if that's
a common theme - behind every successful web site there's a
very, *very* patient wife... ;-)


               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.


                     F E E D B A C K

            Have something to say? Please share!



Percival Bragg:

"I would like to allow some friends to view my ASP code for
the pages on my site. I copied the ASP pages and changed
their extensions to .txt expecting that when I linked to
these files notepad, or some other application, would open
up and display their contents. This does not happen."


That's what is supposed to happen I'm afraid. A browser
cannot open another application for security reasons. You
obviously see the text file inside the browser, but Notepad
won't be used.



"I got most of the search working while you were away.
Funny thing though I had to put a space in front of the
fields in the database and then the search worked. Hmmmm.
Any way the only part I have not figured out is how to
print a group heading for the fields. Welcome back. Hope
you and your family enjoyed the time away."


We had a great time thanks.

I do a word search, hence I search for space followed by
the word you search for. So you need a space at the front
of each field, exactly as you found, or the first word
in the field won't ever be found.


Paul P-W:

"Your site looks great - I'm just getting into this ASP
game & was in need of some friendly advice, so thanks! :>)

Here is a problem that you *might* not be aware of, might
have a fix for & also may want to refer to on your site:

I have installed PWS (from a Win98 CD) onto my laptop which
came with WinME (it is not included with WinME - see
Microsoft knowledge base Q266456).

It installed okay (apart from a problem with MTS, documented
in Microsoft knowledge base Q246081). PWM then seemed to run
okay, but I could not get Frontpage2000 to publish to my PWS
directory - it gave an error and suggested I try ftp instead.

I also could not run the server extension manager that
installed with PWS - it told me there was a more recent
version of the server extensions on my PC.

I have downloaded the Windows NT 4.0 Option Pack which has
another version of PWS, so I will try that next.

Thanks for your time."


Thanks Paul! I knew about the first two issues, but not
about FP. FP is of course the devils spawn - see


Indira Bhat:

"What is the best way to walk through the folders
recursively and list them ORDER BY LAST MODIFIED DATE?"


Store the file dates in an array, like I store the names in
an array in, and
then sort the array afterwards.

Using my code as a basis, the oFile object has a property
that you can query to get the date - oFile.DateLastModified.


David Davtian:

"Hi James, first of all great-great website, I've learned
a lot from your work and I'm glad that there are people
like you in this world.

So I have an ASP driven membership website and I'm running
an SQL server for the back end, and I'm trying to find a
script that will show which member is online, perhaps
showing a list with all members and those folks who are
connected to the server, a red star or something next to
their name and those offline will have no star.

Do you know where I can start?..where/what I can research?"


I've been asked that a few times, but I've never needed it
myself. Maybe in the future when I have a real members area
or forum it'll be useful.

I'd suggest setting the members status to "online" by adding
code to update the database in utils/login.asp, ValidateLogin,
just below where the session variables are set up.


To keep note of logged out users, update the database in
global.asa's Session_OnEnd.


Kurt Meyers:

"I use to have something in VBScript that took a 9 digit SSN
and split it so I could put in the '-''s. But after looking
at your code I have grown fond of JScript. I was just
wondering how can I do that in JScript?

Here is what is looked like in VBScript :

Left(SSN,3) & " - " & Mid(SSN,4,2) & " - " & Right(SSN,4)

Any help would be greatly helpful"


JavaScript's string object has a slice method (amongst
many other useful ones) but no left/mid/right- but see


Carl Revell:

"Just a simple one, I found that by doing a refresh on the
SurveyResults page I was able to increment the option I'd
voted for with every page refresh. I noticed the code uses
a Cookie to prevent this and I have cookies enabled but was
still able to increment the count.

I refreshed 3 times if you want to reduce the value for an
accurate count!


Thanks! If you look closely, you'll see that I set the
cookie, but never test for it! I must have been interrupted
while I was writing that bit!

Thanks for letting me know!



"Reading through your ad-system and how it manages user
clickthroughs, I noticed a little "flaw" (or "feature", in
case you already knew about it).

It's not a flaw that is bad for your advertisers. Far from
it; it could be losing you money!

Lets see... Only one application variable for storing used
IP addresses? Shouldn't you set up a variable for EACH

This would mean that someone could hit your site, click an
ad and that would be it. If he came back to your site again
and clicked a different ad, the clickthrough would not be
registered and you would have given away a free clickthrough!

P.S. Love the new-look site - looks like the best just got
better.You should definitely use JScript.NET not C# for
CoverYourASP.NET ;-)

Oh, and I hope you enjoyed Florida!"


What led me to that decision were spiders. I wanted to play
it safe for my advertisers, and if a spider hit the site
"clicking" on every banner I wanted to minimize the damage.
I still think that keeping advertisers happy is worth a lot!

P.S. You're losing the fight for Jscript.NET - everyone
else wants C#. :-(


        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.


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

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


Looks like you might get to meet me if you go to Web DevCon
2001 in Denver on June 12-15. I've been invited, and might
just try and go - the company I *really* work for has an
office there.

Now, I just have to arrange a business meeting for the same
time period... ;-)

Check it out:

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

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!

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?