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
61 active users
3606 visitors today
2644 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 3 2001


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

             Welcome to the latest newsletter!


I have been pleasantly surprised to see sites springing up
based on my code. I won't mention the sites by name, yet,
but I'd like to start compiling an online list of them on
the site.

They are very impressive web sites in their own right - but
I can recognise parts of forms, or odd words here and there!

Of course, these guys have my full support. As my Legal page
attempts to make clear, these sites are using my code
exactly how I intended.

If any of these guys are listening, I'd love to give them
some free publicity, so please contact me:

"tractor guy", "biz guy", "connect guy", "education guy" and
"south pacific guy"...


        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



27 Jan

- Apologies to the newsletter subscribers - I got two copies
this morning, so I assume you did too! Since I only sent it
once this time, I'll have to do some investigation...


29 Jan

- Just so that you know, I'm busy reviewing every page of
every article on the site and typing in keywords for the
search functionality due out by the end of the week. I may
still implement the HTML search too (see my survey), but
the keywords will come first. And, I want you to know that
it's hard work...;-)


30 Jan

- I improved the DBEditTable.asp page today - just two small
changes, but they make a lot of difference! First, You can
now sort the table by any field by clicking on the field
name. Clicking again will toggle between ascending and
descending. The second change was just to wrap the code
with a try...catch to trap errors caused by the query.


31 Jan

- Seems quiet this week, but I've been beavering away behind
the scenes! Tonight I will finish the manual indexing of all
the keywords in my articles, and tomorrow you will finally
be able to search the site!


1 Feb

- A few of you have noticed that you cannot sort the
BannerStats table by the BannerID field. That's because I
use an INNER JOIN to another table with that field also, so
my generic ORDER BY generates an error: "The specified field
'BannerID' could refer to more than one table listed in the
FROM clause of your SQL statement". Since this error is only
caused by the way I hide the real content of that table, I
now simply ignore your request to sort by that field.

- Here's a question - why are 6 out of the 20 prospective
members (those that haven't yet confirmed their membership)
using email addresses? Is it coincidence?
Certainly it is a domain where the majority of people ask to
sign up, then 10 days later the account gets automatically

- Search away! - an article on how I implemented the keyword
search is coming soon...the source code is already in the
download though.


2 Feb

- Come on everybody, get voting! Click on my new catchy random
rotating incentives on the right. What I really need are some
cheerleaders up any spare?


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

        Please recommend my site to your colleagues


Only one new article this week, but it was a doozy:

"Adding search capability to CoverYourASP"

See how a single Server Side Include containing a single
function is all you need..

More on search coming soon though...


         A   W O R D   F R O M   M Y   S P O N S O R S


Thanks for welcoming aboard Neil from, my
latest advertiser. Many of you have been visiting his site
since the banner went live on Thursday - so many that his
banner won't last long!

I seriously love his components. To be honest I hadn't
seen them before, but they are sooooooo cool.

I am amazed that they are all pure server-side components -
you can make your web site look like a Windows Application
without anything but HTML being sent to the client.


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

Bob Spellmann takes the honor this week.

Bob has regularly sent in helpful tips and suggestions, all
explained in great detail and clarity.

Thanks Bob.

The only slightly odd thing I've noticed is that he's one of
the 3% of visitors that use that old Netscape thingy... ;-)


               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 have to say a quick hi to a new subscriber before I forget.

They said later that they read the whole thing from top to
bottom, and it was "very nice".

So, this is a test.                                  Hi Mum.


         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!



                     F E E D B A C K

            Have something to say? Please share!




Subject: Showsource.asp?page=contact

Message: "Hi James, As the subject of this message puts it,
I'm interested in the way you display some of your pages,
(also commonly used on web sites) using the URL stated as
the subject. Are u documenting this anywhere ?


I'm surprised to find that I don't!

You can pass parameters into a page using this syntax:
(by the way, this is how forms with an action of GET send
their data to the server)

Then use Request.QueryString ( 'a' ) to return 1, etc.

To "cast" them into numbers or strings use this syntax:

var sString = '' + Request.QueryString ( 'c' );
var nNumber = Request.QueryString ( 'a' ) - 0;


The Mad Hacker, aka Hakan Eskici, aka "TableEditor man":

"I've found a potential security flaw in.."


"I've tried something that all of us usually forget..."


Hakan, what would I do without you? I won't publish your
emails, or my responses until I've fixed the second one -
your email only came in after I'd started writing this



Hi James! I found error when ran your code on my NT4
wstation using the downloaded PWS from MS. The error
found as follows :

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/cya/utils/Email.asp, line 28

Invalid class string

What does it mean James?


It means that you don't have an entry in your registry
for the ProgID you used in the Server.CreateObject call.

In your case, the SMTP service isn't installed, so there
is no registered COM component called "CDONTS.NewMail".

Haven't got an NT4 box to hand, but look in Control Panel,
Add/Remove Programs for an SMTP entry.


Randy had a number of problems connecting to his database,
and many emails were exchanged. It turns out that his ISP
*insists* that everybody's databases are placed in the same
single folder on the server.

That makes it almost impossible to reference with a DSN-less
connection since it requires the path of the database. Why
"almost" impossible?

Normally you don't know, or want to know, the absolute path
of your web site on the server. Everything is relative to
the root of the site. The database in my download is in the
folder "DBPATH/DB.MDB".

That relative path is turned into the absolute path that the
connection needs by calling Server.MapPath( ).

The problem with Randy's ISP is that Server.MapPath won't
return an absolute path if the relative path is outside your
web site, i.e. you can't do this:

  sAbsPath = Server.MapPath ( '../../../JimsSite/DB.mdb' )

Remember, is an ISP insists on this scheme it's because he
wants to charge you for a DSN connection - most do, and make
his life easier, not yours.

Which means that you should visit


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

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


Following the hassle that the latest advertiser went through
to send payment I shall be investigating accepting credit
cards and checks online next week.

Hopefully that'll go through ok, and you can see how all that
is implemented. And those of you that are lined up to send in
donations, but can't use PayPal, can use that instead. ;-)

I joke about it, but did you know only 6 people have ever
done so? Now that's an exclusive club to join!

One last thing - I'm still hanging on to the lead in the
ASP Guild competition (see below), but the traffic that "the
other site" gets is finally taking it's toll.

With them having almost exactly 10 times the page views in
January that I got, I'm still proud that we kept the lead
for the whole month.

I bet they didn't get emails from their readers saying they
had dynamic IP's and could vote every time they dialed up...

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

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!

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?

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