/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }
Multiple level select boxes
The author writes
In depth article on showing
This hands-on tutorial
tackled with hierarchical
"Recently I was asked
records in a page by page
explains how to develop a
data! This sample
to develop a web based
fashion with 'first
simple SQL-driven web site
illustrates the concept
report that would collect
page','next','back' and
in just minutes. Topics
using a hierarchy consisting
data from a database, format
'last page' links at the
include: Our Database
of geographical region,
it in an HTML page and then
bottom to navigate through
Design, Creating a Data
country, and state data. The
print a certain number of
the records. Sample code and
Source, Inserting A Tip Into
code expects a system DSN by
rows on each page with a
database available for
Our Database, Displaying and
name "Hierarchy"
column header on each page.
download. Online demo also
Deleting Tips, Searching the
and accesses the database
This solution solves the
available.
Database, and Displaying the
using the user id
problem." Source code
 
Tips.
"sa" with a blank
available for download.
 
 
password. The database is
 
 
 
created in SQL Server 7.0.
 
 
 


Date: Jun, 13 2000


Date: Jul, 20 2001


Date: Jul, 10 2000


Date: Aug, 30 2000
This is a quick sample code
This article covers two
Learn how to add records with
Want to add value to your
which combines a number of
advanced ADO topics:
an SQL statement instead of
current search? Allow your
database functions into one
creating hierarchical
a Recordset. Here are two
users to search from within
script. Includes functions
Recordsets (via data
examples. One will use a
search results. As databases
to add, delete, and edit
shaping) and creating custom
query string and the other
grow the necessity for the
records in a database table.
Recordsets. Specifically,
gets the info from a form.
user to continually narrow a
It illustrates a number of
this article looks at how to
Both examples include an
search to the item that they
useful techniques for
create custom hierarchical
example of a DSN-LESS
truly want will grow also.
database manipulation.
Recordsets. The reader is
connection.
The following example
 
required to have a fluid
 
utilizes a db on U.S. State
 
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: Jun, 12 2001


Date: Jun, 05 2001


Date: Aug, 05 2002


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