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