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