Clearview Design Presents Clearview Design
Bill's ASP Newbie PagesDemos and other hopefully helpful ASP pages

Home

Demos

Contact

Links

The Demos

Zip code finder and mapper!
Allows you to enter any "home" zip code available in the (Access) database and any (reasonable) distance and then gives you a list of all zip codes within that distance from the home zip code.

In addition, it maps the FIRST NINE closest zip codes onto a map supplied by Google Maps, assigning each a number corresponding to the entry of "found" zip codes.

So use it either to learn how to do zip code searches or how to do basic manipulation of Google Maps.

For this demo, I have provided a ZIP file that you can download by clicking here. The zip includes a small sample Access DB as well as "README" instructions on how to get the full database and how to alter it for use with this page.


Demo of a popup calendar.
FIXED as of 28 July 2009 to work in XHTML transitional and changed to an SHTML page.
Shows how a calling page can add a popup calendar link so that a user can enter a date by viewing the calendar rather than typing it in. The calendar is in client-side JavaScript and works with MSIE, NS, FireFox, and Chrome, at a minimum.

Be sure to view the source code so you can see how easy it is to control the format of the date that is plunked into your text field.  In addition, you can easily control which is the first day of the week in the displayed calendar.

A Calendar of Events , preliminary version. In support of discussions held on the ASP message boards. Hopefully, more details about operation, etc., will be added soon. You should be able to download the Access database here.

A session-based shopping cart, preliminary version. In support of discussions held on the ASP message boards.

This example uses a VBScript class ("ShoppingCart") as the basis of the cart.  The info in the cart is stored to (and restored from) a one-dimensional array that is stored to a session variable.  Each element of that array is itself an array.  When the data is in memory--while the VBS code is executing--the elements are transformed into instances of another VBScript class ("ShoppingCartItem").  I've taken reasonable care to do everything via properties and methods that hide as many details as possible.  Unfortunately, VBS doesn't allow "friend" classes, so some of the item class details would be visible to calling code.  I strongly urge implementors not to use them but to use only the methods provided by the main class, instead.

Maybe someday I'll see fit to post more details about operation, etc.
You should be able to download the Access database here.
ASP (VBScript) version of a dirt simple "Tree View" control
ASP.NET (VB.Net) version of the same thing!
I finally got so tired of seeing the incredibly complex treeviews that MicroSloppy and others foist on the world that I decided to show a really, really simple version. The JavaScript code is bare bones minimal BUT IT WORKS!
The VBScript and VB.NET code is bare bones minimal. And THEY work! The VB.NET version, especially, is not the way you would build this page using Visual Studio, but I wanted to show that you don't really *NEED* all the very very complex extra levels of code that VS tosses at you when all you are after is a very simple application/page such as this.
I'll try to improve this, over time, using a multi-level tree (levels varying from 1 to, say, 5 indentations of the tree). And using pretty graphics instead of the dirt simple <INPUT TYPE=BUTTON> that I used here.
But it works! Try it! (Source code for each version is available at the bottom of the pages.)
You can download the Access database that is used, if you wish. For now, it's the same one used in the other category/subcategory demos.
Producing HTML bar graphs.
A pair of useful ASP subroutines that will accept a record set as data and then create readable bar graphs in pure HTML. Should work with almost any browser. Also shows connecting to a "text" database (a ".csv" file) without a DSN.

Dual lists in HTML
Uses client side JavaScript to allow user to transfer any number of items from one list to another.

A VBScript version of the same thing.
Remember, this is client side VBScript, so it generally works only with Internet Explorer!

Submitting several entries via a single POST to an ASP page.
Client-side JavaScript is used to build a list (array) of one or more sets of form data to be submitted to an ASP processing page via a single POST. This technique cuts down on the number of "round trips" to the server.

A table from a database query that is sorted using ASP.
ASP is used to retrieve data from a database table, and hyperlinks (that invoke a tiny JavaScript function) are used to choose the sort order. All the work is done in one page, all in ASP. All we are really doing (except for some cosmetics) is to choose the ORDER BY clause that we will pass to SQL. This is surely the easiest way to allow a user to sort a table, but it is server-side intensive. For a possibly better solution, though one that requires more care and programming work, see the next demo.

  A table from a database query that is sorted in the browser!
ASP is used to retrieve data from a database table, but then all the presentation work, including sorting and resorting columns in the resultant table, is done by client-side JavaScript. To make the result as browser friendly as possible, the actual "work" is done in a hidden frame, and the displayed data is actually written to a just-emptied frame each time the display is modified.

My version of paging through a database table.
In contrast to the SORT demo, this is all done in ASP. One of these days, I'll get around to merging the two concepts! For now, in addition to the DB and table names that show up by default, you can also choose "ClientDemo.mdb" for the database name and then choose "Employees" for the table name.

Multiple drop-down lists, subcategories via ASP.
Select a category from one list and have it cause a second list to re-populate with subcategories. Preserves other data entered on the same form, as well.  This one can be a pain to code, but it's a better choice than the JavaScript version (just below) if you have hundred and hundreds--or thousands--of subcategories that might be chosen.

Note: You can download the Access database that is used in this demo.

Multiple drop-down lists, subcategories via JavaScript.
Select a category from one list and have it cause a second list to re-populate with subcategories.  Same data and same effect as the ASP version (just above), but this is all done in the browser and so less load on the server!  This is a better choice when the totaql number of subcategories is relatively small.  Say 200 or less?  But maybe more than that depending on circumstances.

Note: You can download the Access database that is used in this demo.

Special Category and Subcategory Display Demo in support of a question in the ASPFAQs. It answers the question posed in FAQ number 154, which is:
I have a database with a table of categories and a table of subcategories. How can I easily make a display that will show each category with its related subcategories grouped under it?
Note: This demo uses the same database and tables as the Multiple drop-down lists demo, just above. You can download the Access database that is used in both of these demos, if you wish.