/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

How to connect to database using a connection string

Hits: 30
*****
5.0

Multiple Form Selection (Where In)

Hits: 30
*****
3.0

Compacting an Access database from ASP code

Hits: 28
*****
5.0

Search db by Field

Hits: 28
*****
0.0
The power of Active Server
Allowing multiple choices of
This source code can compact
Providing search capabilities
Pages comes through when we
data observations enables
and repair your MS-Access
to a db enables users to
tie databases to our web
people to customize views of
database files. If you
query on whichever element
sites. To connect to a
your data and adds value to
compact your access files
you target them to. However
database, ASP uses what is
your applications. This
regularly, it will work more
allowing users to target
called ActiveX Data Objects,
example utilizes our db on
faster and secure. Also you
which portion of the db they
or ADO for short. ADO comes
the career statistics of
will save some hard disk
would like to query gives
with ASP, and can be used
Hammerin’ Hank Greenberg.
space.
extra value. In this
easily from your ASP pages.
The years he played are
 
example, utilizing our db of
In this tutorial we will
available to select from in
 
US States (state, statename,
show you how to connect to
a dropdown menu. When
 
and capital) the user can
Access database and retrieve
multiple years are selected
 
search in any of three
all the records from the
they are passed comma
 
fields (by dropdown menu
table.
delimited. Utilizing the
 
input) rather than the
 
where in statement in our
 
application targeting one
 
sql the comma delimited
 
specific table element.
 
selections are appended to
 
Note: The db only has 50
 
our sql statement to display
 
observations in it, so it is
 
only those years selected.
 
better to search on single
 
 
 
or double letter
 
 
 
combinations.


Date: Sep, 25 2006


Date: Oct, 04 2000


Date: Jan, 25 2004


Date: Jun, 26 2000
To database or not to
Want to add value to your
The ASP data access component
Learn how to create
database? Test of consumed
current search? Allow your
is one of the most powerful
dynamically dependent
resources (processor,
users to search from within
features of ASP. With this
dropdown lists with. There's
memory) and results with
search results. As databases
component you are able to
an online demo and source
file upload to database or
grow the necessity for the
interface your database(s)
code provided.
file system. Test of JetOLEB
user to continually narrow a
directly with your
 
connection to MDB, test of
search to the item that they
webserver. Database access
 
MSSQL 2000 and AppendChunk
truly want will grow also.
in ASP is, or can be, very
 
method and UPDATE text SQL
The following example
complex. This online
 
command.
utilizes a db on U.S. State
tutorial focuses on just a
 
 
capitals. Upon the first
few objects to help you get
 
 
search two radio buttons
started with the basics and
 
 
will appear indicating a
you can then move forward
 
 
search (default) or a search
from there.
 
 
within the current results.
 
 
 
Searching within the current
 
 
 
results will take the first
 
 
 
search and add it to the new
 
 
 
search and so on.
 
 


Date: May, 06 2002


Date: Aug, 12 2000


Date: Dec, 11 1999


Date: Jul, 21 2006
{ Copyright } ©2006 NuclearScripts.com