/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Multiple level select boxes
This hands-on tutorial
Allowing multiple choices of
In depth article on showing
tackled with hierarchical
explains how to develop a
data observations enables
records in a page by page
data! This sample
simple SQL-driven web site
people to customize views of
fashion with 'first
illustrates the concept
in just minutes. Topics
your data and adds value to
page','next','back' and
using a hierarchy consisting
include: Our Database
your applications. This
'last page' links at the
of geographical region,
Design, Creating a Data
example utilizes our db on
bottom to navigate through
country, and state data. The
Source, Inserting A Tip Into
the career statistics of
the records. Sample code and
code expects a system DSN by
Our Database, Displaying and
Hammerin’ Hank Greenberg.
database available for
name "Hierarchy"
Deleting Tips, Searching the
The years he played are
download. Online demo also
and accesses the database
Database, and Displaying the
available to select from in
available.
using the user id
Tips.
a dropdown menu. When
"sa" with a blank
multiple years are selected
password. The database is
they are passed comma
created in SQL Server 7.0.
delimited. Utilizing the
where in statement in our
sql the comma delimited
selections are appended to
our sql statement to display
only those years selected.
Date: Jun, 13 2000 Date: Aug, 30 2000 Date: Oct, 04 2000 Date: Jul, 10 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 |
{ Copyright } ©2019 NuclearScripts.com