|  | 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!
 
 http://CoverYourASP.com/
 ____________________________________________________________
 
 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
 
 http://www.codecharge.com
 ____________________________________________________________
 
 
 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.
 
 Visit http://www.codecharge.com
 
 ____________________________________________________________
 
 T H E   D I A R Y
 
 The events of the last week
 
 http://CoverYourASP.com/ShowDiary.asp
 ____________________________________________________________
 
 ______
 
 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
 
 http://www.developersdex.com
 ____________________________________________________________
 
 
 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 ActionJackson.com just to name a few.
 
 If it's on the NET it's on Devdex!
 
 http://www.developersdex.com
 
 ____________________________________________________________
 
 R E C O M M E N D   T H E   S I T E !
 
 Please recommend my site to your colleagues
 
 http://CoverYourASP.com/Recommend.asp
 ____________________________________________________________
 
 
 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 4GuysFromRolla.com 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
 site: http://marketplace.devx.com/upload/excerpts/mitchell/
 
 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.
 
 http://EverPlanet.com/
 ____________________________________________________________
 
 ____________________________________________________________
 
 A   W O R D   F R O M   M Y   S P O N S O R S
 
 http://www.hexillion.com/refer.asp?id=cya7&dest=%2F
 ____________________________________________________________
 
 
 Get FREE sample code, online utilities, and articles at
 Hexillion.
 
 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.
 
 http://www.hexillion.com/refer.asp?id=cya7&dest=%2F
 
 ____________________________________________________________
 
 F E E D B A C K
 
 Have something to say? Please share!
 
 http://CoverYourASP.com/Contact.asp
 
 ____________________________________________________________
 
 
 Dano:
 
 "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();
 }"
 
 Me:
 
 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:
 
 http://registry.winguides.com/display.php/793/
 
 ______
 
 
 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."
 
 Me:
 
 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
 way.
 
 ______
 
 
 Anon:
 
 "The example that you have for implementing forms does not work.
 You might want to recheck. There are numerous errors contained
 with it."
 
 Me:
 
 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
 information!
 
 ______
 
 
 Steve Moore:
 
 "Have you written anything that automates Microsoft
 Access database compactions? With ASP?"
 
 Me:
 
 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!
 
 http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP
 
 http://support.microsoft.com/support/kb/articles/Q230/4/96.ASP
 http://msdn.microsoft.com/library/psdk/dasdk/jolt29pv.htm
 
 ______
 
 
 Bob:
 
 "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?"
 
 Me:
 
 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
 http://msdn.microsoft.com/scripting/jscript/doc/sgfsosample.htm
 
 The File object has DateCreated, DataLastAccessed and
 DateLastModified properties that should do what you want.
 
 ______
 
 Abdel:
 
 "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 educinternet.com
 if you want (sites based on yours)"
 
 Me:
 
 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
 http://coveryourasp.com/Wider.asp 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
 
 http://www.visualasp.com/
 ____________________________________________________________
 
 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.
 
 http://www.visualasp.com
 
 ____________________________________________________________
 
 H A V E   I   H E L P E D   Y O U ?
 
 If I've helped you, help me help others!
 
 http://CoverYourASP.com/Donate.asp
 ____________________________________________________________
 
 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 CoverYourASP.com)
 
 http://www.aspguild.org/group/~12/asp/voteasp2001.asp?a=171
 ____________________________________________________________
 ____________________________________________________________
 
 S U B S C R I P T I O N S
 
 Do you want to subscribe or unsubscribe?
 
 http://CoverYourASP.com/Subscribe.asp
 ____________________________________________________________
 
 
 | 
 |  |