/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Two Table Join

Hits: 40
*****
0.0

Display Table Script Writer

Hits: 37
*****
3.0

Counting Records in SQL Script

Hits: 36
*****
2.5

Simple Table Display With Where Clause (Hard Coded)

Hits: 35
*****
4.0
Outputting data from two
This is a Web-based script
Sometimes we worry about
Displaying specific subsets
tables is almost as easy as
writer that generates an ASP
limits of database table and
of data from a database is
displaying from one. This
code for displaying an
we need to know how manay
easy to accomplish in .asp.
example utilizes two tables
Access or SQL Server
recods we have. In ASP we
The following example
with state information on
database using
could count all recods using
utilizes an Access database
them. The first table
user-submitted variable
a loop. But if we have a
of Mark "The Bird"
(state_order) contains state
names and the name of the
small piece of knowledge
Fidrych and displays all of
abbreviations (state), state
table. Copy the output code
about SQL script, our
his season statistics for
names (statename) the year
into an asp document on your
script works better and
1976 contained in the
each state was admitted into
web server and your db is
faster.
database rather than
the union (year) and the
ready to be displayed on the
 
displaying the entire db.
numeric order they entered
web. The DSN connection
 
 
in (entered). The second
requires that you register
 
 
table (state_capitals)
the DSN for the db prior to
 
 
contains state abbreviations
executing the code.
 
 
(state), state names (state)
 
 
 
and state capitals
 
 
 
(capital). The where
 
 
 
statement looks to make a
 
 
 
match on the field that each
 
 
 
table has in common to
 
 
 
ouput the correct capital
 
 
 
with all the info from the
 
 
 
state_order table.
 
 
 


Date: Jun, 26 2000


Date: May, 21 2001


Date: Sep, 06 2006


Date: Jan, 20 2000
Allowing multiple choices of
This article describes
It is very common operation
This example / tutorial
data elements enables people
practical methods of
to request one field of
explains how to use the LIKE
to customize views of your
optimizing the performance
information via a database
operator to perform a
data and adds value to your
of ASP pages which retrieve
query. This is called a
partial match on an Access
applications. In this sample
and display tabular data
singleton query. ADO.Net has
database.
code, user inputted
from a database. Test
specific functions for
 
choice(s) are added to the
results of each coding
singleton queries, but not
 
basic sql statement to draw
technique show the potential
ADO (ActiveX Data Objects).
 
them from the db. Since the
for dramatic speedups of
This article describes how
 
input from the dropdown menu
dynamic web pages.
to use an ADO command object
 
comes through comma
 
to perform faster singleton
 
delimited it is simply
 
queries.
 
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: Aug, 06 2000


Date: Oct, 20 2006


Date: Oct, 20 2006


Date: Dec, 08 2000
{ Copyright } ©2006 NuclearScripts.com