/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Compact and repair your
The purpose of this article
Storing frequently used
An article on connecting to
access database online from
is to show how to get
lookup data in a database is
database via ASP using both
ASP code. This is example
records from an html form
a great idea (e.g. order
DSN and DSN less
code of how this can be done.
and submit that form to an
status codes, state names,
connections. Explains uses
ASP page. This ASP page will
etc.) that saves tremendous
of each. Learn using
then use SQL to enter the
amounts of time in design
connection strings.
records into the database.
and maintenance. However,
retrieving that data from
the database every time it
is needed is very
inefficient. This article
describes how to use
Application variables to
cache frequently used lookup
data in memory to achieve
lightning fast access times.
Date: Jan, 23 2002 Date: Jun, 11 2000 Date: Jun, 28 2000 Date: Dec, 03 2000 |
|
Multiple level select boxes
The author writes
To database or not to
This hands-on tutorial
tackled with hierarchical
"Recently I was asked
database? Test of consumed
explains how to develop a
data! This sample
to develop a web based
resources (processor,
simple SQL-driven web site
illustrates the concept
report that would collect
memory) and results with
in just minutes. Topics
using a hierarchy consisting
data from a database, format
file upload to database or
include: Our Database
of geographical region,
it in an HTML page and then
file system. Test of JetOLEB
Design, Creating a Data
country, and state data. The
print a certain number of
connection to MDB, test of
Source, Inserting A Tip Into
code expects a system DSN by
rows on each page with a
MSSQL 2000 and AppendChunk
Our Database, Displaying and
name "Hierarchy"
column header on each page.
method and UPDATE text SQL
Deleting Tips, Searching the
and accesses the database
This solution solves the
command.
Database, and Displaying the
using the user id
problem." Source code
Tips.
"sa" with a blank
available for download.
password. The database is
created in SQL Server 7.0.
Date: Jun, 13 2000 Date: Jul, 20 2001 Date: May, 06 2002 Date: Aug, 30 2000 |
{ Copyright } ©2019 NuclearScripts.com