/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Multiple Form Selection

Hits: 663
*****
4.0
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
{ Copyright } ©2019 NuclearScripts.com