|
This is the second article in
This code demonstrates how to
Sample implementation (source
This is an article about
this series. This article
use an MD5 hash to encrypt
code)illustrating how to
displaying binary data
mainly deals with SQL Joins
user passwords when storing
implement a "Suggestion
(images) from an Access
and SQL sub-queries. Both of
them in a database. There
Box" style form using
database. Online demo and
these are extremely useful
are constantly news items
ASP and MS Access. Easily
sample code available for
SQL constructs and should be
about companies where user
installed, and customized.
download.
learnt by all beginners.
information is compromised.
By storing passwords using
an MD5 hash, even if your
database is compromised the
passwords cannot be decoded.
The only downside is that
users cannot retrieve lost
passwords, they must reset
them.
Date: May, 10 2002 Date: Sep, 18 2006 Date: Mar, 20 2006 Date: Apr, 03 2001 |
|
Create a connection to DBF
You can connect to an Access
Step-by-step tutorial on how
It is an often problem with
files using JetOLEDB
database within an ASP page
to display uploaded binary
database intergration when
provider (DSN-less,
with different methods. This
files from the database
you use a reserved word.
ODBC-less connection), basic
article will help you to
using plain ASP pages. Every
Often asked why a script
work with DBF files (select,
create a System Data Source
step has been explained in
does not work and it quite
insert, update), other ISAM
Name (DSN) for an Access
detail. Downloadable source
often comes down the the
formats + FOXPRO option,
database on your local
code available.
author setting a field name
real sample code, create a
machine.
as a reserved word,
new DBF file.
confusing SQL and making
debugging hard. To solve
this problem here is a quick
list of the SQL Reserved
Words.
Date: Jun, 18 2003 Date: Jun, 14 2000 Date: Jun, 17 2002 Date: Aug, 28 2003 |