/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Connections And Server Database Permissions

Hits: 679
*****
0.0

Compact & Repair Access Database

Hits: 669
*****
0.0

Populate dropdowns from your database

Hits: 667
*****
0.0

Multiple Form Selection

Hits: 663
*****
4.0
This is an overview of SYSTEM
Compact and repair your
Dropdowns or combo boxes are
Allowing multiple choices of
DSN's, DSN-LESS Connections,
access database online from
an excellent way to get
data elements enables people
and any database permissions
ASP code. This is example
input from a user. One of
to customize views of your
that may need to be set on
code of how this can be done.
the biggest problems with
data and adds value to your
the server. Helpful for
 
user input is spelling and
applications. In this sample
people just learning ASP as
 
formatting. Here is how to
code, user inputted
well as people with some
 
use and populate dropdowns
choice(s) are added to the
experience.
 
from a database.
basic sql statement to draw
 
 
 
them from the db. Since the
 
 
 
input from the dropdown menu
 
 
 
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: Mar, 22 2001


Date: Jan, 23 2002


Date: Aug, 05 2002


Date: Aug, 06 2000
The purpose of this article
Storing frequently used
An article on connecting to
Multiple level select boxes
is to show how to get
lookup data in a database is
database via ASP using both
tackled with hierarchical
records from an html form
a great idea (e.g. order
DSN and DSN less
data! This sample
and submit that form to an
status codes, state names,
connections. Explains uses
illustrates the concept
ASP page. This ASP page will
etc.) that saves tremendous
of each. Learn using
using a hierarchy consisting
then use SQL to enter the
amounts of time in design
connection strings.
of geographical region,
records into the database.
and maintenance. However,
 
country, and state data. The
 
retrieving that data from
 
code expects a system DSN by
 
the database every time it
 
name "Hierarchy"
 
is needed is very
 
and accesses the database
 
inefficient. This article
 
using the user id
 
describes how to use
 
"sa" with a blank
 
Application variables to
 
password. The database is
 
cache frequently used lookup
 
created in SQL Server 7.0.
 
data in memory to achieve
 
 
 
lightning fast access times.
 
 


Date: Jun, 11 2000


Date: Jun, 28 2000


Date: Dec, 03 2000


Date: Jun, 13 2000
{ Copyright } ©2019 NuclearScripts.com