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
132 active users
4516 visitors today
3388 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 12 2001


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

             Welcome to the latest newsletter!


It's a Mad, Mad, Mad, Mad World!

I looked in my last newsletter and saw that last time I
wrote I was working on - a site that was trying
to get a new standard for sharing web content off the

That seems so long ago.

Almost straight away it changed to, a non-profit
organisation more fitting to a standards body. The web site
was going to go live on Monday May 14th - read later why
that's not going to happen now..


I did do some work that's directly beneficial to you too - I
finally got fed up having to enter the ID's of foreign keys
in my database admin pages. I've now improved them
dramatically by automatically showing dropdown lists when
one table has a relationship with another. Again, more below.


        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



30 Apr

- Since I've been spending so much time on STORS lately, I've
decided to make my newsletter bi-weekly so that there will
be enough content to keep it interesting! So after the one
sent out this morning it will be two weeks before the next


2 May

- For your information, is now There is
now sample code available (in JavaScript of course!) for
both publishers and directories to start supporting the
STOR standard for sharing their resources.


3 May

- I found a new directory last night - - which
had been kind enough to add my banner to their ASP pages.
Check them out!


4 May

- Dave Kawliche was kind enough to link to CYA from his new
site - but he wanted a non-animated button. So there's now a
simpler button for you to use on the link page.

You should check out Dave's site, for
lots of interesting information.


9 May

- What a waste of an evening! My wife received one of "those"
emails today in her Outlook Express, and surprisingly the
preview pane executed the script!

I'm so used to my Outlook 2000 stopping me from doing
virtually anything with attachments that I assumed Express
did the same. Wrong! If you use Express, make sure you set
Tools/Options/Security/Restricted sites zone.


10 May

- Lovely email from "Steve Anderson" (no email address given),
it made me smile:

"If you're going to be a professional writer, you should learn
to spell 'independent'"

Who said anything about professional?!! Did he pay me
anything? I've fixed the single mistake needless to say. ;-)


        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

____________________________________________________________ is dead, long live!

The last three weeks have seen a lot of changes - from FSS
to STORS, a new web site and a lot of interest from publishers
and directories alike. Now we're evolving again, this time to
use an existing XML standard, the Rich Site Summary (RSS).

Two people contacted us yesterday about RSS, and asked why
we were creating a new standard when an established one
already existed. Upon investigation we have to agree that RSS
has a lot of advantages.

RSS was originally conceived and implemented by Netscape to
provide a way for sites to create content channels - there
are literally thousands of sites that publish their content
this way.

It is apparent that there are very few ASP developers that
know about RSS, since it took three weeks for us to find out
about it, so we've decided to create an ASP-specific web site
to help the 1,000,000 ASP developers use RSS.

The new site is will transform into over the next few
weeks. Its aims remain the same - to allow publishers and
directories to share links. We will still provide sample code,
this time less generic and more optimized for ASP sites.

ASPRSS will still keep a list of ASP sites that support RSS,
and will provide a form submission service for those sites.

In fact the new site will do a lot more than was
ever planning.

To the publishers and directories that have pledged support
we hope you will continue to support ASPRSS. I'd like to thank
everyone for their enormous help in getting us this far - your
help was not wasted. Since RSS is extensible we will not lose
any of the ideas we have gathered so far.

I'd personally like to give special thanks to Steve Smith and
Pedro Pequeno for helping me get so far so quickly.


         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 !

Got to be Conan Theobald who donated a significant amount
by upgrading his membership status to Silver*

Here's an email from him, which also helped make him this
weeks hero!

"I just read in your newsletter about how many people have
upgraded memberships; I believe this makes me number two! I
hope this "lack" of interest won't discourage you from
writing great articles. I liked to contribute all the same.

Oh, and check out the current site I'm working on: . It's got a lot to thank
CoverYourASP for. There are no CYA links in the source yet,
but that should be rectified soon, there is many a feature
not yet implemented and a lot of the "visual" code is FP
but hey-ho, such is the life of a developer :)

Have fun and happy coding!

P.S. I recommend for fast hosting plus
free SSL pages!"

Thanks Conan!

*Note that there is nothing extra for silver members right
now, apart from my gratitude!

               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.


Do you use my database adminstration pages? If so, you'll
want to get the latest version from the download at

I added code to store the foreign keys in Application
variables and display dropdown lists when viewing or editing
the relevant tables. It's very cool.

Ironically, it doesn't work at all on the CYA database,
because  of the assumptions it makes and my original bad
design of some of the tables!

So instead I've added three new tables: Cars, CarMakes and
CarColors to demonstrate the new code.

If you want to jump straight to the demo, go to

I haven't had time to document the changes yet, so I'll just
briefly describe them here.

First, a new function in utils/database.asp is called.
DBGatherForeignKeys( ) gets the foreign keys from the
database, looks up the data from the referenced table and
creates the HTML for a dropdown list. This HTML is stored in
an Application variable for later use.

Note: the dropdown list is populated with the second column
from the referenced table, so plan your tables accordingly.

There are two more new functions, DBDisplayValue( ) and
DBEditValue( ) that can be used to format the column for
display or editing, depending on the field type.

If the column has a corresponding dropdown list, then that
is displayed, otherwise the value is formatted into a date
or string format. Obviously these functions can easily be
modified to support other types.


                     F E E D B A C K

            Have something to say? Please share!




"Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/cya/include/Startup.asp, line 20"

The Include file '/include/Config.html' cannot contain '..'
to indicate the parent directory. One other question - does
the global.asa have to be in the root directory?"


Here's your answer:

And, yes, the global.asa has to be in the root, or I should
say, I haven't ever seen it anywhere else...



"Can you help me with this strange error?

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

  INSERT INTO eMsg (Name,MONTH,Message)
  VALUES ("' + Name + '","' + MNTH + '","' + Msg + '")

The form field message is a textarea (i'm trying to add a
message board to my page)"


(I've tried hard to get hold of Jason, but his email address
keeps bouncing...)

Try wrapping the field names in [ ] - month may be a
reserved name. Wrapping in [ ] allows you to use it.

Other possibilities include the fact that the values may
contain invalid characters such as ' - you should replace
any single ' with two of them.


Koh Sing: Can you do me a favour?

"Can you please teach me how to code an ASP vote poll
which users are NOT allow to vote it TWICE?"


Unless you have a membership system, you can't stop them
voting twice. You can make it hard, but never impossible.

Simplest is to use cookies, but they can be deleted. You
could use IP address, but many people will have the same
one if they go through a proxy or have dynamic IP.

Luckily I have a membership system you can use ;-)


David Kennedy:

"My domain is hosted at an ISP When you connect to the
site you are forwarded to my Linux server. This forwarding
only works for the domain name.

I need a script that will forward addresses like, i.e. strip out the domain name and
append the rest of the URL to the address of  the Linux

Is this possible to do from my home page or do I need
access to the Web server?"


Did you read and ?

The latter especially deals with exactly your situation.


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?


Sorry, you can't. You have to have a default.asp - just
rename your default.htm file, and add the function call
wrapped in <% %>


John Salonich:

"I'm responding to your article about render blocks. I
never realized how much of pain moving form ColfdFusion to
ASP would be. Tossing a <cfoutput></cfoutput> tag around
variables, the equivilant of <% %> is the norm, anywhere on
the page.

Of course there are always best practices and better ways
to build a widget, but I am truely blown away by all of the
hoops one needs to jump through to get similar functionality
to CF.

Don't take this as a Holy War, I think ASP is great, and I
thank you for maintaining this great web resource. I would
never have even explored ASP if I hadn't found your site.


Whoa - don't take my code as anything close to normal ASP!

No-one else I know does the same thing - everyone else has
HTML with lots of <% %>. So perhaps it's not so different
after all. I code like a C++ coder, not your typical web


         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! <===

Think of me next week. I'm moving house and will have to
disconnect my valued cable modem for up to 4 weeks!

I may switch to ADSL, but even that is a 7-10 day hookup.

So, I've dug out my old 56k modem and will install that this
weekend. I'm not looking forward to it!

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

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!

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!

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