/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
MySQL is the most popular
This is an overview of SYSTEM
Ever wondered how to create a
Outputting data from two
open source database system
DSN's, DSN-LESS Connections,
table, view or procedure
tables is almost as easy as
available today, and is
and any database permissions
with MS Access? This article
displaying from one. This
currently installed on over
that may need to be set on
shows us how to create all
example utilizes two
tables
two million servers
the server. Helpful for
three and work with them
with state information on
worldwide. This article
people just learning ASP as
from an ASP script.
them. The first table
takes a look at using the
well as people with some
(state_order) contains state
free MyODBC driver to talk
experience.
abbreviations (state), state
to a MySQL database from an
names (statename) the year
ASP script.
each state was admitted into
the union (year) and the
numeric order they entered
in (entered). The second
table (state_capitals)
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: Jan, 17 2002 Date: Mar, 22 2001 Date: Aug, 27 2003 Date: Jun, 26 2000 |
|
An article on connecting to
The purpose of this article
Storing frequently used
Multiple level select boxes
database via ASP using both
is to show how to get
lookup data in a database is
tackled with hierarchical
DSN and DSN less
records from an html form
a great idea (e.g. order
data! This sample
connections. Explains uses
and submit that form to an
status codes, state names,
illustrates the concept
of each. Learn using
ASP page. This ASP page will
etc.) that saves tremendous
using a hierarchy consisting
connection strings.
then use SQL to enter the
amounts of time in design
of geographical region,
records into the database.
and maintenance. However,
country, and state data. The
retrieving that data from
code expects a system DSN by
the database every time it
name "Hierarchy"
is needed is very
and accesses the database
inefficient. This article
using the user id
describes how to use
"sa" with a blank
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, 11 2000 Date: Jun, 28 2000 Date: Jun, 13 2000 |
{ Copyright } ©2019 NuclearScripts.com