You all must have seen and
This writing will discuss
To database or not to
This article shows you how to
done stuff with the
several things to do to
database? Test of consumed
use SQL-DMO to create an
RecordSet object, infact
ensure the application
resources (processor,
Active Server Pages
everything is done with the
migration carried on in a
memory) and results with
application to backup and
RecordSet object. Now, this
good way, particularly for
file upload to database or
verify a SQL Server
acticle explains how to use
ASP Database applications
file system. Test of JetOLEB
database. The SQL
GetRows to page through the
and to overcome possible
connection to MDB, test of
Distributed Management
records that you recieve
problems might occurred.
MSSQL 2000 and AppendChunk
Objects (SQL-DMO) extend the
from the SELECT. It's much
Basically, migrating ASP to
method and UPDATE text SQL
functionality of SQL Server
faster than MoveNext,
Linux means you have to
command.
by providing developers a
because it closes the
convert to database
way to execute common tasks.
database connection
supported by Linux
immediately whereas MoveNext
platforms. Currently,
loops through the records
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: Feb, 01 2006 Date: May, 06 2002 Date: May, 29 2001 |
Explains everything in detail
Dropdowns or combo boxes are
Ever wondered how to create a
Here is a quick sample of
you'll ever need to know
an excellent way to get
table, view or procedure
searching a DB for certain
about creating Stored
input from a user. One of
with MS Access? This article
records. It's really no
Procedures in Access
the biggest problems with
shows us how to create all
different then doing any
Database and then calling
user input is spelling and
three and work with them
other query except that you
from within ASP. Select,
formatting. Here is how to
from an ASP script.
need to use wildcards. In
Update, Insert and Delete
use and populate dropdowns
ASP / ADO the wildcard
Stored Procedures are
from a database.
character is %. It works the
described. Sample code and
way most of us have come to
database available for
expect * to work. Why is it
download.
%? I have no idea, but it
is. An Access 97 version of
the database is available
for download.
Date: Jan, 07 2001 Date: Aug, 05 2002 Date: Aug, 27 2003 Date: Feb, 20 2001 |