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