/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Populate dropdowns from your database

Hits: 667
*****
0.0

Easy way to add a record

Hits: 663
*****
0.0

Multiple Form Selection

Hits: 663
*****
4.0

Making the Switch from ODBC to OLE DB

Hits: 662
*****
0.0
Dropdowns or combo boxes are
Adding a record from a
Allowing multiple choices of
ODBC is great and all but for
an excellent way to get
database table is a simple
data elements enables people
speed and reliability you
input from a user. One of
task. Fill out the form
to customize views of your
should switch to OLE DB to
the biggest problems with
below and click submit. The
data and adds value to your
power your database driven
user input is spelling and
sql statement will be
applications. In this sample
apps. This tutorial will
formatting. Here is how to
generated for you.
code, user inputted
show you how to do it two
use and populate dropdowns
 
choice(s) are added to the
ways: in the global.asa and
from a database.
 
basic sql statement to draw
in any ASP page.
 
 
them from the db. Since the
 
 
 
input from the dropdown menu
 
 
 
comes through comma
 
 
 
delimited it is simply
 
 
 
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, 05 2002


Date: Apr, 15 2002


Date: Aug, 06 2000


Date: Feb, 13 2000
Displaying specific subsets
This tutorial shows you
Allowing multiple choices of
You fill in the blanks, and
of data from a database is
step-by-step how to
data observations enables
you are given the source
easy to accomplish in .asp.
incorporate MS Access
people to customize views of
code for the form, and a
The following example
databases into your web site
your data and adds value to
page to display the
utilizes an Access database
using ASP.
your applications. This
information in the database.
of Mark "The Bird"
 
example utilizes our db on
Also the database is ready
Fidrych and displays all of
 
the career statistics of
to download with all fields
his season statistics for
 
Hammerin’ Hank Greenberg.
in your form.
1976 contained in the
 
The years he played are
 
database rather than
 
available to select from in
 
displaying the entire db.
 
a dropdown menu. When
 
 
 
multiple years are selected
 
 
 
they are passed comma
 
 
 
delimited. Utilizing the
 
 
 
where in statement in our
 
 
 
sql the comma delimited
 
 
 
selections are appended to
 
 
 
our sql statement to display
 
 
 
only those years selected.
 


Date: Jan, 20 2000


Date: Mar, 15 2000


Date: Oct, 04 2000


Date: Apr, 15 2002
{ Copyright } ©2019 NuclearScripts.com