|
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 |