/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Many a time, you are
Sometimes, we would have
You all must have seen and
Connections, Commands and
confronted with creating a
chance to convert our
done stuff with the
Procedures is a sample
system DSN for use with ASP.
existing database or create
RecordSet object, infact
chapter from Professional
If you have an ISP account,
a new database. Some
everything is done with the
Active Server Pages which
this might take time and
decisions IT professionals
RecordSet object. Now, this
discuss in depth all the
more than sometimes - money.
need to make are scary, and
acticle explains how to use
issues related with
This article describes how
choosing database software
GetRows to page through the
establishing connection to a
to use File DSNs and save
is one of them. This
records that you recieve
database to the carrying out
time and money. Also, you
overview aims to describe
from the SELECT. It's much
of commands and procedures.
can reuse these DSNs and
how to set database
faster than MoveNext,
thus, with some
connections with some common
because it closes the
modifications, use the same
database software (Oracle,
database connection
DSN for as many database
MySQL, MS Access,MS SQL
immediately whereas MoveNext
connections.
Server).
loops through the records
with the overhead of the
database connection. Plus
GetRows let's you count the
records correctly!
Date: Jan, 25 2000 Date: Sep, 01 2003 Date: Oct, 04 2003 Date: Mar, 20 2000 |
|
This writing will discuss
This article describes how to
In depth article on showing
Explains everything in detail
several things to do to
use Microsoft SQL Server
records in a page by page
you'll ever need to know
ensure the application
triggers to automatically
fashion with 'first
about creating Stored
migration carried on in a
record all updates and
page','next','back' and
Procedures in Access
good way, particularly for
inserts for a particular
'last page' links at the
Database and then calling
ASP Database applications
database table in a
bottom to navigate through
from within ASP. Select,
and to overcome possible
customized history table.
the records. Sample code and
Update, Insert and Delete
problems might occurred.
database available for
Stored Procedures are
Basically, migrating ASP to
download. Online demo also
described. Sample code and
Linux means you have to
available.
database available for
convert to database
download.
supported by Linux
platforms. Currently,
Chili!Soft ASP is already
supporting MS Access but not
all web hosting companies
install this feature. They
prefer to use more common
database in Linux such as
MySQL and PostgreSQL. Pay
attention to some Chili!Soft
specific ADO methods and
properties, since there are
slight differences with IIS
ASP. You might need to
convert some codes in your
applications to make it run
in Chili!Soft ASP.
Date: Feb, 01 2006 Date: Sep, 20 2001 Date: Jul, 10 2000 Date: Jan, 07 2001 |
{ Copyright } ©2019 NuclearScripts.com