In depth article on showing
Multiple level select boxes
The author writes
This hands-on tutorial
records in a page by page
tackled with hierarchical
"Recently I was asked
explains how to develop a
fashion with 'first
data! This sample
to develop a web based
simple SQL-driven web site
page','next','back' and
illustrates the concept
report that would collect
in just minutes. Topics
'last page' links at the
using a hierarchy consisting
data from a database, format
include: Our Database
bottom to navigate through
of geographical region,
it in an HTML page and then
Design, Creating a Data
the records. Sample code and
country, and state data. The
print a certain number of
Source, Inserting A Tip Into
database available for
code expects a system DSN by
rows on each page with a
Our Database, Displaying and
download. Online demo also
name "Hierarchy"
column header on each page.
Deleting Tips, Searching the
available.
and accesses the database
This solution solves the
Database, and Displaying the
using the user id
problem." Source code
Tips.
"sa" with a blank
available for download.
password. The database is
created in SQL Server 7.0.
Date: Jul, 10 2000 Date: Jun, 13 2000 Date: Jul, 20 2001 Date: Aug, 30 2000 |
This is a quick sample code
This article covers two
Learn how to add records with
Want to add value to your
which combines a number of
advanced ADO topics:
an SQL statement instead of
current search? Allow your
database functions into one
creating hierarchical
a Recordset. Here are two
users to search from within
script. Includes functions
Recordsets (via data
examples. One will use a
search results. As databases
to add, delete, and edit
shaping) and creating custom
query string and the other
grow the necessity for the
records in a database table.
Recordsets. Specifically,
gets the info from a form.
user to continually narrow a
It illustrates a number of
this article looks at how to
Both examples include an
search to the item that they
useful techniques for
create custom hierarchical
example of a DSN-LESS
truly want will grow also.
database manipulation.
Recordsets. The reader is
connection.
The following example
required to have a fluid
utilizes a db on U.S. State
understanding of both data
capitals. Upon the first
shaping and custom
search two radio buttons
Recordsets.
will appear indicating a
search (default) or a search
within the current results.
Searching within the current
results will take the first
search and add it to the new
search and so on.
Date: Jun, 12 2001 Date: Jun, 05 2001 Date: Aug, 05 2002 Date: Aug, 12 2000 |