/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Compact and repair your
The purpose of this article
To database or not to
An article on connecting to
access database online from
is to show how to get
database? Test of consumed
database via ASP using both
ASP code. This is example
records from an html form
resources (processor,
DSN and DSN less
code of how this can be done.
and submit that form to an
memory) and results with
connections. Explains uses
ASP page. This ASP page will
file upload to database or
of each. Learn using
then use SQL to enter the
file system. Test of JetOLEB
connection strings.
records into the database.
connection to MDB, test of
MSSQL 2000 and AppendChunk
method and UPDATE text SQL
command.
Date: Jan, 23 2002 Date: Jun, 11 2000 Date: May, 06 2002 Date: Dec, 03 2000 |
|
Storing frequently used
The author writes
Multiple level select boxes
Dropdowns or combo boxes are
lookup data in a database is
"Recently I was asked
tackled with hierarchical
an excellent way to get
a great idea (e.g. order
to develop a web based
data! This sample
input from a user. One of
status codes, state names,
report that would collect
illustrates the concept
the biggest problems with
etc.) that saves tremendous
data from a database, format
using a hierarchy consisting
user input is spelling and
amounts of time in design
it in an HTML page and then
of geographical region,
formatting. Here is how to
and maintenance. However,
print a certain number of
country, and state data. The
use and populate dropdowns
retrieving that data from
rows on each page with a
code expects a system DSN by
from a database.
the database every time it
column header on each page.
name "Hierarchy"
is needed is very
This solution solves the
and accesses the database
inefficient. This article
problem." Source code
using the user id
describes how to use
available for download.
"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, 28 2000 Date: Jul, 20 2001 Date: Jun, 13 2000 Date: Aug, 05 2002 |
{ Copyright } ©2019 NuclearScripts.com