/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 761
*****
0.0

Suggestion Box

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


Date: Jun, 18 2003


Date: Aug, 27 2003


Date: May, 10 2002


Date: Mar, 20 2006
This is an article about
You can connect to an Access
Step-by-step tutorial on how
It is an often problem with
displaying binary data
database within an ASP page
to display uploaded binary
database intergration when
(images) from an Access
with different methods. This
files from the database
you use a reserved word.
database. Online demo and
article will help you to
using plain ASP pages. Every
Often asked why a script
sample code available for
create a System Data Source
step has been explained in
does not work and it quite
download.
Name (DSN) for an Access
detail. Downloadable source
often comes down the the
 
database on your local
code available.
author setting a field name
 
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: Jun, 17 2002


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