/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 708
*****
0.0

Suggestion Box

Hits: 706
*****
0.0
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
SQL, Structured Query
You can connect to an Access
It is an often problem with
displaying binary data
Language, is the most
database within an ASP page
database intergration when
(images) from an Access
powerful tool to connect to
with different methods. This
you use a reserved word.
database. Online demo and
a database regardless of the
article will help you to
Often asked why a script
sample code available for
form of the database.
create a System Data Source
does not work and it quite
download.
However, building a perfect
Name (DSN) for an Access
often comes down the the
 
SQL statement can be very
database on your local
author setting a field name
 
frustrating. Especially
machine.
as a reserved word,
 
debugging -- the error
 
confusing SQL and making
 
message simply didn't tell
 
debugging hard. To solve
 
you where the error is. This
 
this problem here is a quick
 
tutorial provides a nice
 
list of the SQL Reserved
 
summary of SQL statements.
 
Words.


Date: Apr, 03 2001


Date: Feb, 15 2000


Date: Jun, 14 2000


Date: Aug, 28 2003
{ Copyright } ©2019 NuclearScripts.com