Article describes what is
It is an often problem with
Dropdowns or combo boxes are
Step-by-step tutorial on how
SQL? what it is used for?
database intergration when
an excellent way to get
to display uploaded binary
how to SELECT, INSERT,
you use a reserved word.
input from a user. One of
files from the database
UPDATE and DELETE records
Often asked why a script
the biggest problems with
using plain ASP pages. Every
from the database? and more.
does not work and it quite
user input is spelling and
step has been explained in
often comes down the the
formatting. Here is how to
detail. Downloadable source
author setting a field name
use and populate dropdowns
code available.
as a reserved word,
from a database.
confusing SQL and making
debugging hard. To solve
this problem here is a quick
list of the SQL Reserved
Words.
Date: Mar, 13 2002 Date: Aug, 28 2003 Date: Aug, 05 2002 Date: Jun, 17 2002 |
You can connect to an Access
Allowing multiple choices of
This article shows how to
Many a time, you are
database within an ASP page
data elements enables people
generate random records from
confronted with creating a
with different methods. This
to customize views of your
the database. Also explains
system DSN for use with ASP.
article will help you to
data and adds value to your
how to generate random
If you have an ISP account,
create a System Data Source
applications. In this sample
numbers. Sample Database and
this might take time and
Name (DSN) for an Access
code, user inputted
Code available for download.
more than sometimes - money.
database on your local
choice(s) are added to the
This article describes how
machine.
basic sql statement to draw
to use File DSNs and save
them from the db. Since the
time and money. Also, you
input from the dropdown menu
can reuse these DSNs and
comes through comma
thus, with some
delimited it is simply
modifications, use the same
written into the statement
DSN for as many database
without modification. Two
connections.
simple for next loops
determine which elements are
part of the record set and
displays them accordingly.
Date: Jun, 14 2000 Date: Aug, 06 2000 Date: Aug, 30 2000 Date: Jan, 25 2000 |