Allowing multiple choices of
MySQL is the most popular
This is an overview of SYSTEM
Compact and repair your
data elements enables people
open source database system
DSN's, DSN-LESS Connections,
access database online from
to customize views of your
available today, and is
and any database permissions
ASP code. This is example
data and adds value to your
currently installed on over
that may need to be set on
code of how this can be done.
applications. In this sample
two million servers
the server. Helpful for
code, user inputted
worldwide. This article
people just learning ASP as
choice(s) are added to the
takes a look at using the
well as people with some
basic sql statement to draw
free MyODBC driver to talk
experience.
them from the db. Since the
to a MySQL database from an
input from the dropdown menu
ASP script.
comes through comma
delimited it is simply
written into the statement
without modification. Two
simple for next loops
determine which elements are
part of the record set and
displays them accordingly.
Date: Aug, 06 2000 Date: Jan, 17 2002 Date: Mar, 22 2001 Date: Jan, 23 2002 |
The purpose of this article
Storing frequently used
An article on connecting to
Allowing multiple choices of
is to show how to get
lookup data in a database is
database via ASP using both
data observations enables
records from an html form
a great idea (e.g. order
DSN and DSN less
people to customize views of
and submit that form to an
status codes, state names,
connections. Explains uses
your data and adds value to
ASP page. This ASP page will
etc.) that saves tremendous
of each. Learn using
your applications. This
then use SQL to enter the
amounts of time in design
connection strings.
example utilizes our db on
records into the database.
and maintenance. However,
the career statistics of
retrieving that data from
Hammerin’ Hank Greenberg.
the database every time it
The years he played are
is needed is very
available to select from in
inefficient. This article
a dropdown menu. When
describes how to use
multiple years are selected
Application variables to
they are passed comma
cache frequently used lookup
delimited. Utilizing the
data in memory to achieve
where in statement in our
lightning fast access times.
sql the comma delimited
selections are appended to
our sql statement to display
only those years selected.
Date: Jun, 11 2000 Date: Jun, 28 2000 Date: Dec, 03 2000 Date: Oct, 04 2000 |