You all must have seen and
To database or not to
This writing will discuss
Dropdowns or combo boxes are
done stuff with the
database? Test of consumed
several things to do to
an excellent way to get
RecordSet object, infact
resources (processor,
ensure the application
input from a user. One of
everything is done with the
memory) and results with
migration carried on in a
the biggest problems with
RecordSet object. Now, this
file upload to database or
good way, particularly for
user input is spelling and
acticle explains how to use
file system. Test of JetOLEB
ASP Database applications
formatting. Here is how to
GetRows to page through the
connection to MDB, test of
and to overcome possible
use and populate dropdowns
records that you recieve
MSSQL 2000 and AppendChunk
problems might occurred.
from a database.
from the SELECT. It's much
method and UPDATE text SQL
Basically, migrating ASP to
faster than MoveNext,
command.
Linux means you have to
because it closes the
convert to database
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: May, 06 2002 Date: Feb, 01 2006 Date: Aug, 05 2002 |
This article shows you how to
Explains everything in detail
Allowing multiple choices of
Ever wondered how to create a
use SQL-DMO to create an
you'll ever need to know
data elements enables people
table, view or procedure
Active Server Pages
about creating Stored
to customize views of your
with MS Access? This article
application to backup and
Procedures in Access
data and adds value to your
shows us how to create all
verify a SQL Server
Database and then calling
applications. In this sample
three and work with them
database. The SQL
from within ASP. Select,
code, user inputted
from an ASP script.
Distributed Management
Update, Insert and Delete
choice(s) are added to the
Objects (SQL-DMO) extend the
Stored Procedures are
basic sql statement to draw
functionality of SQL Server
described. Sample code and
them from the db. Since the
by providing developers a
database available for
input from the dropdown menu
way to execute common tasks.
download.
comes through comma
delimited it is simply
written into the statement
without modification. Two
simple for next loops
determine which elements are
part of the record set and
displays them accordingly.
Date: May, 29 2001 Date: Jan, 07 2001 Date: Aug, 06 2000 Date: Aug, 27 2003 |