/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 784
*****
0.0

Suggestion Box

Hits: 777
*****
0.0
How to build a dynamic
This is the second article in
Create a connection to DBF
Sample implementation (source
dropdown list with ASP and
this series. This article
files using JetOLEDB
code)illustrating how to
database data. Then, how to
mainly deals with SQL Joins
provider (DSN-less,
implement a "Suggestion
use ADO and recordset
and SQL sub-queries. Both of
ODBC-less connection), basic
Box" style form using
filtering to produce a
these are extremely useful
work with DBF files (select,
ASP and MS Access. Easily
structured list.
SQL constructs and should be
insert, update), other ISAM
installed, and customized.
 
learnt by all beginners.
formats + FOXPRO option,
 
 
 
real sample code, create a
 
 
 
new DBF file.
 


Date: Aug, 27 2003


Date: May, 10 2002


Date: Jun, 18 2003


Date: Mar, 20 2006
This is an article about
You can connect to an Access
It is an often problem with
Step-by-step tutorial on how
displaying binary data
database within an ASP page
database intergration when
to display uploaded binary
(images) from an Access
with different methods. This
you use a reserved word.
files from the database
database. Online demo and
article will help you to
Often asked why a script
using plain ASP pages. Every
sample code available for
create a System Data Source
does not work and it quite
step has been explained in
download.
Name (DSN) for an Access
often comes down the the
detail. Downloadable source
 
database on your local
author setting a field name
code available.
 
machine.
as a reserved word,
 
 
 
confusing SQL and making
 
 
 
debugging hard. To solve
 
 
 
this problem here is a quick
 
 
 
list of the SQL Reserved
 
 
 
Words.
 


Date: Apr, 03 2001


Date: Jun, 14 2000


Date: Aug, 28 2003


Date: Jun, 17 2002
{ Copyright } ©2019 NuclearScripts.com