/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 778
*****
0.0

Suggestion Box

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


Date: Aug, 27 2003


Date: Jun, 18 2003


Date: May, 10 2002


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