 |
|
|
|
|
|
|
|
|
|
 |
|
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.
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, and FireFox, 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.
|
|
