MySQL is the most popular
Here is a quick sample of
This is an overview of SYSTEM
Allowing multiple choices of
open source database system
searching a DB for certain
DSN's, DSN-LESS Connections,
data observations enables
available today, and is
records. It's really no
and any database permissions
people to customize views of
currently installed on over
different then doing any
that may need to be set on
your data and adds value to
two million servers
other query except that you
the server. Helpful for
your applications. This
worldwide. This article
need to use wildcards. In
people just learning ASP as
example utilizes our db on
takes a look at using the
ASP / ADO the wildcard
well as people with some
the career statistics of
free MyODBC driver to talk
character is %. It works the
experience.
Hammerin’ Hank Greenberg.
to a MySQL database from an
way most of us have come to
The years he played are
ASP script.
expect * to work. Why is it
available to select from in
%? I have no idea, but it
a dropdown menu. When
is. An Access 97 version of
multiple years are selected
the database is available
they are passed comma
for download.
delimited. Utilizing the
where in statement in our
sql the comma delimited
selections are appended to
our sql statement to display
only those years selected.
Date: Jan, 17 2002 Date: Feb, 20 2001 Date: Mar, 22 2001 Date: Oct, 04 2000 |
Compact and repair your
The purpose of this article
An article on connecting to
Storing frequently used
access database online from
is to show how to get
database via ASP using both
lookup data in a database is
ASP code. This is example
records from an html form
DSN and DSN less
a great idea (e.g. order
code of how this can be done.
and submit that form to an
connections. Explains uses
status codes, state names,
ASP page. This ASP page will
of each. Learn using
etc.) that saves tremendous
then use SQL to enter the
connection strings.
amounts of time in design
records into the database.
and maintenance. However,
retrieving that data from
the database every time it
is needed is very
inefficient. This article
describes how to use
Application variables to
cache frequently used lookup
data in memory to achieve
lightning fast access times.
Date: Jan, 23 2002 Date: Jun, 11 2000 Date: Dec, 03 2000 Date: Jun, 28 2000 |