/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Compact & Repair Access Database

Hits: 712
*****
0.0

Adding Records to a Database using SQL

Hits: 703
*****
0.0

Get Your Data Faster with a Data Cache

Hits: 702
*****
0.0

Connecting to Database using DSN/DSN less Connections

Hits: 697
*****
0.0
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