/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
To database or not to
A step by step tutorial on
How to build a dynamic
Dropdowns or combo boxes are
database? Test of consumed
caching data in memory. This
dropdown list with ASP and
an excellent way to get
resources (processor,
tutorial goes one step
database data. Then, how to
input from a user. One of
memory) and results with
further from simply caching
use ADO and recordset
the biggest problems with
file upload to database or
data in memory to allow you
filtering to produce a
user input is spelling and
file system. Test of JetOLEB
to set a time limit in
structured list.
formatting. Here is how to
connection to MDB, test of
seconds after which it
use and populate dropdowns
MSSQL 2000 and AppendChunk
refreshes the data in
from a database.
method and UPDATE text SQL
memory. Extremely useful
command.
technique. Online demo
available.
Date: May, 06 2002 Date: Aug, 08 2001 Date: Aug, 27 2003 Date: Aug, 05 2002 |
|
This is the second article in
This is an article about
Allowing multiple choices of
Sample implementation (source
this series. This article
displaying binary data
data elements enables people
code)illustrating how to
mainly deals with SQL Joins
(images) from an Access
to customize views of your
implement a "Suggestion
and SQL sub-queries. Both of
database. Online demo and
data and adds value to your
Box" style form using
these are extremely useful
sample code available for
applications. In this sample
ASP and MS Access. Easily
SQL constructs and should be
download.
code, user inputted
installed, and customized.
learnt by all beginners.
choice(s) are added to the
basic sql statement to draw
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: May, 10 2002 Date: Apr, 03 2001 Date: Aug, 06 2000 Date: Mar, 20 2006 |
{ Copyright } ©2019 NuclearScripts.com