/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Learn how to search and sort
In depth article on showing
Storing frequently used
Providing search capabilities
the records through the
records in a page by page
lookup data in a database is
to a db enables users to
database. Step by step
fashion with 'first
a great idea (e.g. order
query on whichever element
tutorial with Sample code
page','next','back' and
status codes, state names,
you target them to. However
and database available for
'last page' links at the
etc.) that saves tremendous
allowing users to target
download. Online demo also
bottom to navigate through
amounts of time in design
which portion of the db they
available.
the records. Sample code and
and maintenance. However,
would like to query gives
database available for
retrieving that data from
extra value. In this
download. Online demo also
the database every time it
example, utilizing our db of
available.
is needed is very
US States (state, statename,
inefficient. This article
and capital) the user can
describes how to use
search in any of three
Application variables to
fields (by dropdown menu
cache frequently used lookup
input) rather than the
data in memory to achieve
application targeting one
lightning fast access times.
specific table element.
Note: The db only has 50
observations in it, so it is
better to search on single
or double letter
combinations.
Date: Jul, 10 2000 Date: Jul, 10 2000 Date: Jun, 28 2000 Date: Jun, 26 2000 |
|
Outputting data from two
You can connect to an Access
Multiple level select boxes
The purpose of this article
tables is almost as easy as
database within an ASP page
tackled with hierarchical
is to show how to get
displaying from one. This
with different methods. This
data! This sample
records from an html form
example utilizes two
tables
article will help you to
illustrates the concept
and submit that form to an
with state information on
create a System Data Source
using a hierarchy consisting
ASP page. This ASP page will
them. The first table
Name (DSN) for an Access
of geographical region,
then use SQL to enter the
(state_order) contains state
database on your local
country, and state data. The
records into the database.
abbreviations (state), state
machine.
code expects a system DSN by
names (statename) the year
name "Hierarchy"
each state was admitted into
and accesses the database
the union (year) and the
using the user id
numeric order they entered
"sa" with a blank
in (entered). The second
password. The database is
table (state_capitals)
created in SQL Server 7.0.
contains state abbreviations
(state), state names (state)
and state capitals
(capital). The where
statement looks to make a
match on the field that each
table has in common to
ouput the correct capital
with all the info from the
state_order table.
Date: Jun, 26 2000 Date: Jun, 14 2000 Date: Jun, 13 2000 Date: Jun, 11 2000 |
{ Copyright } ©2019 NuclearScripts.com