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