/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Paging Records With GetRows

Hits: 606
*****
3.5

File DSNs - Use and Reuse

Hits: 605
*****
0.0
You all must have seen and
In depth article on showing
Many a time, you are
This writing will discuss
done stuff with the
records in a page by page
confronted with creating a
several things to do to
RecordSet object, infact
fashion with 'first
system DSN for use with ASP.
ensure the application
everything is done with the
page','next','back' and
If you have an ISP account,
migration carried on in a
RecordSet object. Now, this
'last page' links at the
this might take time and
good way, particularly for
acticle explains how to use
bottom to navigate through
more than sometimes - money.
ASP Database applications
GetRows to page through the
the records. Sample code and
This article describes how
and to overcome possible
records that you recieve
database available for
to use File DSNs and save
problems might occurred.
from the SELECT. It's much
download. Online demo also
time and money. Also, you
Basically, migrating ASP to
faster than MoveNext,
available.
can reuse these DSNs and
Linux means you have to
because it closes the
 
thus, with some
convert to database
database connection
 
modifications, use the same
supported by Linux
immediately whereas MoveNext
 
DSN for as many database
platforms. Currently,
loops through the records
 
connections.
Chili!Soft ASP is already
with the overhead of the
 
 
supporting MS Access but not
database connection. Plus
 
 
all web hosting companies
GetRows let's you count the
 
 
install this feature. They
records correctly!
 
 
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: Oct, 04 2003


Date: Jul, 10 2000


Date: Jan, 25 2000


Date: Feb, 01 2006
Sometimes, we would have
Connections, Commands and
This article describes how to
This is a quick sample code
chance to convert our
Procedures is a sample
use Microsoft SQL Server
which combines a number of
existing database or create
chapter from Professional
triggers to automatically
database functions into one
a new database. Some
Active Server Pages which
record all updates and
script. Includes functions
decisions IT professionals
discuss in depth all the
inserts for a particular
to add, delete, and edit
need to make are scary, and
issues related with
database table in a
records in a database table.
choosing database software
establishing connection to a
customized history table.
It illustrates a number of
is one of them. This
database to the carrying out
 
useful techniques for
overview aims to describe
of commands and procedures.
 
database manipulation.
how to set database
 
 
 
connections with some common
 
 
 
database software (Oracle,
 
 
 
MySQL, MS Access,MS SQL
 
 
 
Server).
 
 
 


Date: Sep, 01 2003


Date: Mar, 20 2000


Date: Sep, 20 2001


Date: Jun, 12 2001
{ Copyright } ©2019 NuclearScripts.com