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