/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
SQL, Structured Query
You all must have seen and
Sometimes, we would have
This is a quick sample code
Language, is the most
done stuff with the
chance to convert our
which combines a number of
powerful tool to connect to
RecordSet object, infact
existing database or create
database functions into one
a database regardless of the
everything is done with the
a new database. Some
script. Includes functions
form of the database.
RecordSet object. Now, this
decisions IT professionals
to add, delete, and edit
However, building a perfect
acticle explains how to use
need to make are scary, and
records in a database table.
SQL statement can be very
GetRows to page through the
choosing database software
It illustrates a number of
frustrating. Especially
records that you recieve
is one of them. This
useful techniques for
debugging -- the error
from the SELECT. It's much
overview aims to describe
database manipulation.
message simply didn't tell
faster than MoveNext,
how to set database
you where the error is. This
because it closes the
connections with some common
tutorial provides a nice
database connection
database software (Oracle,
summary of SQL statements.
immediately whereas MoveNext
MySQL, MS Access,MS SQL
loops through the records
Server).
with the overhead of the
database connection. Plus
GetRows let's you count the
records correctly!
Date: Feb, 15 2000 Date: Oct, 04 2003 Date: Sep, 01 2003 Date: Jun, 12 2001 |
|
Many a time, you are
This writing will discuss
Connections, Commands and
This article describes how to
confronted with creating a
several things to do to
Procedures is a sample
use Microsoft SQL Server
system DSN for use with ASP.
ensure the application
chapter from Professional
triggers to automatically
If you have an ISP account,
migration carried on in a
Active Server Pages which
record all updates and
this might take time and
good way, particularly for
discuss in depth all the
inserts for a particular
more than sometimes - money.
ASP Database applications
issues related with
database table in a
This article describes how
and to overcome possible
establishing connection to a
customized history table.
to use File DSNs and save
problems might occurred.
database to the carrying out
time and money. Also, you
Basically, migrating ASP to
of commands and procedures.
can reuse these DSNs and
Linux means you have to
thus, with some
convert to database
modifications, use the same
supported by Linux
DSN for as many database
platforms. Currently,
connections.
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: Jan, 25 2000 Date: Feb, 01 2006 Date: Mar, 20 2000 Date: Sep, 20 2001 |
{ Copyright } ©2019 NuclearScripts.com