/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
This hands-on tutorial
This article shows how to
This is an article on
This is an article on using
explains how to develop a
generate random records from
executing all or none
Recordset. It uses GetRows
simple SQL-driven web site
the database. Also explains
database queries using
method to speedup database
in just minutes. Topics
how to generate random
ASP-Database transactions.
access. One of the fastest
include: Our Database
numbers. Sample Database and
Must read for ASP-Database
ways of displaying database
Design, Creating a Data
Code available for download.
developers. Sample Database
records with ASP. Sample
Source, Inserting A Tip Into
and Code available for
Database and Code available
Our Database, Displaying and
download.
for download.
Deleting Tips, Searching the
Database, and Displaying the
Tips.
Date: Aug, 30 2000 Date: Aug, 30 2000 Date: Aug, 28 2000 Date: Aug, 27 2000 |
|
This is a brief and very
Want to add value to your
Allowing multiple choices of
This short tutorial explains
useful tutorial on creating
current search? Allow your
data elements enables people
how to to upload a text file
and using stored procedures
users to search from within
to customize views of your
and load it into your
with your asp applications.
search results. As databases
data and adds value to your
database using ASP. It uses
A stored procedure is
grow the necessity for the
applications. In this sample
a sample of the
nothing more than an sql
user to continually narrow a
code, user inputted
space-delimited file for an
statement stored inside a
search to the item that they
choice(s) are added to the
example.
database. The database can
truly want will grow also.
basic sql statement to draw
be SQL Server or MS Access
The following example
them from the db. Since the
as well as others. A stored
utilizes a db on U.S. State
input from the dropdown menu
procedure is compiled by
capitals. Upon the first
comes through comma
your database (for the most
search two radio buttons
delimited it is simply
part) one time, when it is
will appear indicating a
written into the statement
entered. This results in
search (default) or a search
without modification. Two
faster database executions
within the current results.
simple for next loops
and overall performance
Searching within the current
determine which elements are
updates, and it further
results will take the first
part of the record set and
separates the sql statement
search and add it to the new
displays them accordingly.
from your asp leaving you
search and so on.
with more readable code.
This tutorial describes:
What is a stored procedure?,
Writing stored procedures,
Getting the stored procedure
into the database, Calling
stored procedures in ASP
pages, and Modifying and
removing stored procedures.
Date: Aug, 13 2000 Date: Aug, 12 2000 Date: Aug, 06 2000 Date: Jul, 11 2000 |
{ Copyright } ©2019 NuclearScripts.com