/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
This is an overview of SYSTEM
Compact and repair your
The purpose of this article
Dropdowns or combo boxes are
DSN's, DSN-LESS Connections,
access database online from
is to show how to get
an excellent way to get
and any database permissions
ASP code. This is example
records from an html form
input from a user. One of
that may need to be set on
code of how this can be done.
and submit that form to an
the biggest problems with
the server. Helpful for
ASP page. This ASP page will
user input is spelling and
people just learning ASP as
then use SQL to enter the
formatting. Here is how to
well as people with some
records into the database.
use and populate dropdowns
experience.
from a database.
Date: Mar, 22 2001 Date: Jan, 23 2002 Date: Jun, 11 2000 Date: Aug, 05 2002 |
|
Allowing multiple choices of
Storing frequently used
An article on connecting to
The author writes
data elements enables people
lookup data in a database is
database via ASP using both
"Recently I was asked
to customize views of your
a great idea (e.g. order
DSN and DSN less
to develop a web based
data and adds value to your
status codes, state names,
connections. Explains uses
report that would collect
applications. In this sample
etc.) that saves tremendous
of each. Learn using
data from a database, format
code, user inputted
amounts of time in design
connection strings.
it in an HTML page and then
choice(s) are added to the
and maintenance. However,
print a certain number of
basic sql statement to draw
retrieving that data from
rows on each page with a
them from the db. Since the
the database every time it
column header on each page.
input from the dropdown menu
is needed is very
This solution solves the
comes through comma
inefficient. This article
problem." Source code
delimited it is simply
describes how to use
available for download.
written into the statement
Application variables to
without modification. Two
cache frequently used lookup
simple for next loops
data in memory to achieve
determine which elements are
lightning fast access times.
part of the record set and
displays them accordingly.
Date: Aug, 06 2000 Date: Jun, 28 2000 Date: Dec, 03 2000 Date: Jul, 20 2001 |
{ Copyright } ©2019 NuclearScripts.com