|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 26 2001____________________________________________________________
C o v e r Y o u r A S P . c o m
Welcome to the latest newsletter!
For the past five weeks I have been getting the site to send
me an email whenever someone fails to find anything with my
I did this mainly to see if there was something new that I
should write about, and to prioritize new articles.
Surprisingly though, no subjects stand out, although the
sheer volume of failed searches was alarming at first! So
far 1221 searches have failed. Many were typos.
I'll work through the list whenever there's a spare moment
and resolve some of them to existing pages.
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
- Check out the improved database administration - now you
automatically get dropdown lists from foreign keys!
- I apologize but I failed to update every file in the
download - so the include/config.asp was missing the new
bDisplayAllianceBanners variable. You would have seen an
error about this when running the site. The download is
- As a follow-up to my "Accepting credit cards on your site"
article, I'd like to say how pleased I've been with
Charge.com. Just as I hoped, they have been remarkably
helpful and efficient.
I'd also like to thank those sites that have signed up
through my link - a cool $200 check turned up today for
two successful referrals!
- ActiveServerPages.ca has had a major re-write, and very
kindly included a special "CoverYourASP" section
dedicated to my articles. Check them out!
- It's moving day in the Shaw household, so I won't be
responding to any emails until Friday 18th - wish us luck!
- OK, I'm back. The new house is beautiful and there's even
something for you too - there is a new item on the
navigation bar above. "Directory" takes you to a huge list
of resources provided by Aspin.com!
- The Cable Guy gave me some bad news today - there is too
much signal drop over my 600 foot drive to get a cable
modem. So I have to use a dial-up connection for 2-4 weeks
while they prepare to dig up my drive.
Anyway, the good news for you is that I can now tell you
how to run my site with a dial up (I could never test it
When asked to "Connect" or "Stay offline", choose
"Connect". Then, when prompted to dial-up, choose
It's a pain, but that's the only way to run ASP with a
dial-up. Or, of course, you could just stay online... ;-)
- Check out the new easy access to all of Aspin.com's
resources at the bottom of the front page. I've moved over
the ASPWire content to make room.
Now you never have to leave my site... ;-)
- Do you have the Alexa toolbar installed? If you do,
beware. I did until recently but there is a side-effect
you should be aware of if you are a web developer.
If you upload pages to your server to test them and think
it's safe because they aren't linked to from anywhere -
The Alexa toolbar is listening, and will happily cache
your "private" file and crawl it whenever it fancies...
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
R E C O M M E N D T H E S I T E !
Please recommend my site to your colleagues
As promised, I wrote a new article about foreign keys.
"Displaying foreign keys in your database as list boxes"
My original database administration tool didn't look for
foreign keys, and just displayed a confusing list of
primary key values. Now, it's been improved with
automatically generated list boxes...
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 ActionJackson.com 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 !
Robert Brooks is this weeks Hero of the Week. Robert sent me
an email related to calling Server Side Includes from a HTML
page, or more accurately a .shtm page. Following my reply to
David in the last newsletter, Robert prompted me again to
give the correct answer!
"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?"
"Actually, that's exactly the situation I was describing in
the note I sent about the obscure configuration option that
prevents duplicate headers from being output from .shtm
files. In case you (or he) is still interested, here's the
original message. Feel free to forward it to him... with the
note that he must use a .shtm (server-parsed html) file.
- - - - -
I was going crazy trying to find the fix for this problem!
Now that I've (or more accurately, my host has) found it, I
want to share it with you.
I got into ASP by hacking around the existing code for
KHYI.com. The site was primarily HTML with #exec calls to
ASP routines. So most of the files had .shtm extensions,
and had calls like this:
<!-- #exec cgi="/common/ad.asp?station=khyi&site=1021" -->
Everything was fine until we went to move to a new host. It
was crazy - everything worked fine except that every .shtm
file with a server side include had the HTTP headers
repeated in the text sent to the browser!
The new host (www.neologism.com) was a Linux house trying
Windows for the first time, so they were as stumped as I
was. And worse still, nothing on the 'net pointed to a
The most detailed fix was to find a way to wrap a meta-tag
around the unexpected text data - a most unsatisfactory
To make things worse, the problem prevented "default.shtm"
from being the default page. This made no sense at all.
Finally, after poring over the IIS settings and manuals, the
new host's webmaster found the solution. Here's the note he
>Believe it or not, a checkbox labeled "buffering enable"
>needed to be unchecked to get rid of both the can't get
>default.shtm and the wonderful header message across the
>top of the screen. So we've overcome that now.
So there you have it -- my contribution to the world of ASP.
To enable SSI in .shtm files, you have to find an obscure
checkbox and uncheck it. I hope you find this info helpful!
Feel free to direct folks to http://www.khyi.com to see my
100% ASP site in action. All the .shtm files are actually
hiding calls to .asp modules - for example, the "jobs.shtm"
file is actually a call to something like this:
(munged for security):
<!-- #exec cgi="/textfile.asp?file=jobstuff.htm
jobs.shtm looks a lot better in the URL bar than that mess,
and I don't have to reveal the inner workings of my site.
Sorry about the long message -- I know you've got plenty of
mail to read! Good luck, and God bless.
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.
Ever seen "Syntax error in FROM clause" on your local copy
Chances are that you're appending ?SECRET=1 to the URL (see
http://CoverYourASP.com/Security.asp ) and there's already a
? in the URL.
Here's an example:
The correct way to append the password (or any subsequent
parameter to any QueryString) is of course like this, using
an & instead of a ?
F E E D B A C K
Have something to say? Please share!
"I'm still wet behind the ears when it comes to ASP but
viewing the source code from your site has helped a lot.
The only problem that I am having is I don't have CDONTS,
instead, I'm using ASPEMAIL. My question/problem is this,
where would I put "smtp.host.com" in the source code so that
it would recognize it? Any help would be great. Thanks for
all the effort you've put into this for newbies like myself.
Keep up the good work!"
My code sets the host to 'mail.yourdomain.com' - the
'yourdomain.com' is the sHostDomain set in include/config.asp.
But you can change the whole string to your 'smtp..' string
"Dear James, Firstly I would like to compliment you on your
brilliant website and code.
However, a friend of mine is setting up the software for me
and is running into a small problem. Our host (innerhost.com)
specifies that only files outside the web directory are
writeable. Therefore we have to store our database in
D:\Webs\one\data whereas our webpages are stored in
Can you tell me which files to change so that we can point
to the access database in its new location?
We also have SQL setup. Is it very difficult to use SQL
instead of Access? If you have any documentation on this it
would be much appreciated."
Just change the connection string in include/config.asp.
The site will run from SQL if you change the sDBDriver in that
file too - but there are a few pages that use Jet-specific
SQL (like FIRST). But the vast majority is fine.
"Hi James, Are you still running your site on an Access
database? If so, do you know how many active users the
Access can support before taking up so many resources that
it slows down a shared server?
I'm asking this because I was told I may need to upgrade to
SQL 7.0 due to my load, but it seems you have more people on
your site than I do.
Thanks, and continue good luck with your site.
Yes, I'm still using Access 2000. No-one knows "the limit",
but my site seems fine with ~10,000 page views a day.
Make sure you use connection pooling - see the Hero of the
Week section in this old newsletter:
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! <===
Thanks Guys! Speak to you in two weeks.
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?