SQL, Structured Query
It is an often problem with
Step-by-step tutorial on how
Article describes what is
Language, is the most
database intergration when
to display uploaded binary
SQL? what it is used for?
powerful tool to connect to
you use a reserved word.
files from the database
how to SELECT, INSERT,
a database regardless of the
Often asked why a script
using plain ASP pages. Every
UPDATE and DELETE records
form of the database.
does not work and it quite
step has been explained in
from the database? and more.
However, building a perfect
often comes down the the
detail. Downloadable source
SQL statement can be very
author setting a field name
code available.
frustrating. Especially
as a reserved word,
debugging -- the error
confusing SQL and making
message simply didn't tell
debugging hard. To solve
you where the error is. This
this problem here is a quick
tutorial provides a nice
list of the SQL Reserved
summary of SQL statements.
Words.
Date: Feb, 15 2000 Date: Aug, 28 2003 Date: Jun, 17 2002 Date: Mar, 13 2002 |
This article by James Shaw
You can connect to an Access
This article shows how to
Many a time, you are
demonstrates how to
database within an ASP page
generate random records from
confronted with creating a
dynamically add properties
with different methods. This
the database. Also explains
system DSN for use with ASP.
to an object (expando
article will help you to
how to generate random
If you have an ISP account,
properties) - by
create a System Data Source
numbers. Sample Database and
this might take time and
implementing a function to
Name (DSN) for an Access
Code available for download.
more than sometimes - money.
create named recordsets.
database on your local
This article describes how
machine.
to use File DSNs and save
time and money. Also, you
can reuse these DSNs and
thus, with some
modifications, use the same
DSN for as many database
connections.
Date: Dec, 16 2000 Date: Jun, 14 2000 Date: Aug, 30 2000 Date: Jan, 25 2000 |