/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Storing frequently used
The purpose of this article
This article covers two
The author writes
lookup data in a database is
is to show how to get
advanced ADO topics:
"Recently I was asked
a great idea (e.g. order
records from an html form
creating hierarchical
to develop a web based
status codes, state names,
and submit that form to an
Recordsets (via data
report that would collect
etc.) that saves tremendous
ASP page. This ASP page will
shaping) and creating custom
data from a database, format
amounts of time in design
then use SQL to enter the
Recordsets. Specifically,
it in an HTML page and then
and maintenance. However,
records into the database.
this article looks at how to
print a certain number of
retrieving that data from
create custom hierarchical
rows on each page with a
the database every time it
Recordsets. The reader is
column header on each page.
is needed is very
required to have a fluid
This solution solves the
inefficient. This article
understanding of both data
problem." Source code
describes how to use
shaping and custom
available for download.
Application variables to
Recordsets.
cache frequently used lookup
data in memory to achieve
lightning fast access times.
Date: Jun, 28 2000 Date: Jun, 11 2000 Date: Jun, 05 2001 Date: Jul, 20 2001 |
|
Multiple level select boxes
This hands-on tutorial
Learn how to add records with
Want to add value to your
tackled with hierarchical
explains how to develop a
an SQL statement instead of
current search? Allow your
data! This sample
simple SQL-driven web site
a Recordset. Here are two
users to search from within
illustrates the concept
in just minutes. Topics
examples. One will use a
search results. As databases
using a hierarchy consisting
include: Our Database
query string and the other
grow the necessity for the
of geographical region,
Design, Creating a Data
gets the info from a form.
user to continually narrow a
country, and state data. The
Source, Inserting A Tip Into
Both examples include an
search to the item that they
code expects a system DSN by
Our Database, Displaying and
example of a DSN-LESS
truly want will grow also.
name "Hierarchy"
Deleting Tips, Searching the
connection.
The following example
and accesses the database
Database, and Displaying the
utilizes a db on U.S. State
using the user id
Tips.
capitals. Upon the first
"sa" with a blank
search two radio buttons
password. The database is
will appear indicating a
created in SQL Server 7.0.
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, 13 2000 Date: Aug, 30 2000 Date: Aug, 05 2002 Date: Aug, 12 2000 |
{ Copyright } ©2019 NuclearScripts.com