/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 697
*****
0.0

Suggestion Box

Hits: 694
*****
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
To database or not to
SQL, Structured Query
You can connect to an Access
displaying binary data
database? Test of consumed
Language, is the most
database within an ASP page
(images) from an Access
resources (processor,
powerful tool to connect to
with different methods. This
database. Online demo and
memory) and results with
a database regardless of the
article will help you to
sample code available for
file upload to database or
form of the database.
create a System Data Source
download.
file system. Test of JetOLEB
However, building a perfect
Name (DSN) for an Access
 
connection to MDB, test of
SQL statement can be very
database on your local
 
MSSQL 2000 and AppendChunk
frustrating. Especially
machine.
 
method and UPDATE text SQL
debugging -- the error
 
 
command.
message simply didn't tell
 
 
 
you where the error is. This
 
 
 
tutorial provides a nice
 
 
 
summary of SQL statements.
 


Date: Apr, 03 2001


Date: May, 06 2002


Date: Feb, 15 2000


Date: Jun, 14 2000
{ Copyright } ©2019 NuclearScripts.com