/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Database Editing Sample

Hits: 592
*****
0.0
An article on connecting to
Multiple level select boxes
This is a quick sample code
The author writes
database via ASP using both
tackled with hierarchical
which combines a number of
"Recently I was asked
DSN and DSN less
data! This sample
database functions into one
to develop a web based
connections. Explains uses
illustrates the concept
script. Includes functions
report that would collect
of each. Learn using
using a hierarchy consisting
to add, delete, and edit
data from a database, format
connection strings.
of geographical region,
records in a database table.
it in an HTML page and then
 
country, and state data. The
It illustrates a number of
print a certain number of
 
code expects a system DSN by
useful techniques for
rows on each page with a
 
name "Hierarchy"
database manipulation.
column header on each page.
 
and accesses the database
 
This solution solves the
 
using the user id
 
problem." Source code
 
"sa" with a blank
 
available for download.
 
password. The database is
 
 
 
created in SQL Server 7.0.
 
 


Date: Dec, 03 2000


Date: Jun, 13 2000


Date: Jun, 12 2001


Date: Jul, 20 2001
This hands-on tutorial
This article covers two
Learn how to add records with
Want to add value to your
explains how to develop a
advanced ADO topics:
an SQL statement instead of
current search? Allow your
simple SQL-driven web site
creating hierarchical
a Recordset. Here are two
users to search from within
in just minutes. Topics
Recordsets (via data
examples. One will use a
search results. As databases
include: Our Database
shaping) and creating custom
query string and the other
grow the necessity for the
Design, Creating a Data
Recordsets. Specifically,
gets the info from a form.
user to continually narrow a
Source, Inserting A Tip Into
this article looks at how to
Both examples include an
search to the item that they
Our Database, Displaying and
create custom hierarchical
example of a DSN-LESS
truly want will grow also.
Deleting Tips, Searching the
Recordsets. The reader is
connection.
The following example
Database, and Displaying the
required to have a fluid
 
utilizes a db on U.S. State
Tips.
understanding of both data
 
capitals. Upon the first
 
shaping and custom
 
search two radio buttons
 
Recordsets.
 
will appear indicating a
 
 
 
search (default) or a search
 
 
 
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: Aug, 30 2000


Date: Jun, 05 2001


Date: Aug, 05 2002


Date: Aug, 12 2000
{ Copyright } ©2019 NuclearScripts.com