/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

ASP and Databases

Hits: 25
*****
0.0

Using SUM Function in An SQL Statement

Hits: 24
*****
4.0

DSN-less MS Access connection

Hits: 23
*****
0.0

Simple Database Class

Hits: 22
*****
0.0
The ASP data access component
Sum function can be used for
In order to connect to an
This database class handles
is one of the most powerful
to get the sum of a numeric
Acees database with ASP
Select, Insert, Update, and
features of ASP. With this
expression evaluated over a
through ODBC using a DSN
Delete. It also takes steps
component you are able to
set. This function must be
file, you'll need to have
to ensure your SQL syntax is
interface your database(s)
placed in an SQL statement.
full access to the server to
valid, and that memory leaks
directly with your
Following example will
create the DSN file,
/ errors are prevented.
webserver. Database access
return the sum of ratings in
something that can be
Tutorial comes with demo,
in ASP is, or can be, very
articles.
difficult if your site is
downloadable code, and an in
complex. This online
 
hosted somewhere. This
depth explanation.
tutorial focuses on just a
 
lesson will teach you an
 
few objects to help you get
 
alternative connecton
 
started with the basics and
 
method, a DSN-less
 
you can then move forward
 
connection. As tests has
 
from there.
 
shown, an DSN-less
 
 
 
connection to Access gives
 
 
 
you better performance. You
 
 
 
can have up to 20-30
 
 
 
simultaneous users on the db
 
 
 
without problems.
 


Date: Dec, 11 1999


Date: Apr, 01 2004


Date: Mar, 12 2000


Date: Jun, 10 2005
Learn how to add records with
This is an example code
This is a tutrial about
When faced with learning a
an SQL statement instead of
showing how to conduct
connecting an Access
new technology, it's common
a Recordset. Here are two
searches on a database to
database with ASP pages. It
to try and reproduce the
examples. One will use a
display hyperlinked
focuses on connecting Access
basic functionality you're
query string and the other
summaries that can be
with PWS 4.0 on a Win95
used to in the old one. In
gets the info from a form.
clicked on to display detail
machine. You can use the
doing that with ADO.NET and
Both examples include an
data.
same procedure on Win98. It
trying to reproduce the
example of a DSN-LESS
 
also shows you how to create
basics or the recordset
connection.
 
a database table in Access
object, this article
 
 
and how to retrieve it's
discusses the new and many
 
 
content and display it
uses of ADO.NET's DataView
 
 
through ASP.
object.


Date: Aug, 05 2002


Date: May, 21 2001


Date: Feb, 25 2000


Date: Aug, 27 2003
{ Copyright } ©2006 NuclearScripts.com