A step by step tutorial on
How to build a dynamic
This is the second article in
Sample implementation (source
caching data in memory. This
dropdown list with ASP and
this series. This article
code)illustrating how to
tutorial goes one step
database data. Then, how to
mainly deals with SQL Joins
implement a "Suggestion
further from simply caching
use ADO and recordset
and SQL sub-queries. Both of
Box" style form using
data in memory to allow you
filtering to produce a
these are extremely useful
ASP and MS Access. Easily
to set a time limit in
structured list.
SQL constructs and should be
installed, and customized.
seconds after which it
learnt by all beginners.
refreshes the data in
memory. Extremely useful
technique. Online demo
available.
Date: Aug, 08 2001 Date: Aug, 27 2003 Date: May, 10 2002 Date: Mar, 20 2006 |
This is an article about
It is an often problem with
You can connect to an Access
SQL, Structured Query
displaying binary data
database intergration when
database within an ASP page
Language, is the most
(images) from an Access
you use a reserved word.
with different methods. This
powerful tool to connect to
database. Online demo and
Often asked why a script
article will help you to
a database regardless of the
sample code available for
does not work and it quite
create a System Data Source
form of the database.
download.
often comes down the the
Name (DSN) for an Access
However, building a perfect
author setting a field name
database on your local
SQL statement can be very
as a reserved word,
machine.
frustrating. Especially
confusing SQL and making
debugging -- the error
debugging hard. To solve
message simply didn't tell
this problem here is a quick
you where the error is. This
list of the SQL Reserved
tutorial provides a nice
Words.
summary of SQL statements.
Date: Apr, 03 2001 Date: Aug, 28 2003 Date: Jun, 14 2000 Date: Feb, 15 2000 |