/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Now everybody can connect to
In this short ASP source
Sometimes we worry about
Sum function can be used for
a database. Simple database
code, we will pull some data
limits of database table and
to get the sum of a numeric
access is a huge feature of
from a database and fill it
we need to know how manay
expression evaluated over a
ASP and one of the most
into a select list. We will
recods we have. In ASP we
set. This function must be
widely used by developers
create a custom and dynamic
could count all recods using
placed in an SQL statement.
but when you are first
output.
a loop. But if we have a
Following example will
learning, it‘s hard to
small piece of knowledge
return the sum of ratings in
separate the database stuff
about SQL script, our
articles.
from the rest of the code so
script works better and
I made this example. I even
faster.
removed the includes and
everything.
Date: May, 22 2000 Date: Mar, 22 2006 Date: Sep, 06 2006 Date: Apr, 01 2004 |
|
You can use transactions in
This example shows how to
This source code displays
In this example, we will edit
ASP as a kind of insurance
perform a variety of
results dividing to pages.
some records from a
policy for your database
statistics on your data
Code provides Next Previous
database. This source code
activities, making them
using simple SQL such as
page links with numeric page
helps us to edit records to
safer and providing better
Sum, Average, Max, Min, and
numbers. You may modify
database without slowing
error recovery. Transactions
Count. It uses stock trading
source code to use with MS
down database
are most useful when doing
performance of EPOS as an
SQL or MS Access database.
multiple actions on multiple
example.
For this example, we have
tables. The example below
used MS SQL Server using
shows just how easy it is to
sample database Northwind.
use transactions from ASP,
inserting a record into a
table and doing a
"rollback" if
there's a problem.
Date: Jan, 08 2007 Date: Apr, 20 2001 Date: Nov, 12 2003 Date: Dec, 18 2003 |
{ Copyright } ©2019 NuclearScripts.com