/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 810
*****
0.0

Suggestion Box

Hits: 799
*****
0.0
This is the second article in
Sample implementation (source
This is an article about
This code demonstrates how to
this series. This article
code)illustrating how to
displaying binary data
use an MD5 hash to encrypt
mainly deals with SQL Joins
implement a "Suggestion
(images) from an Access
user passwords when storing
and SQL sub-queries. Both of
Box" style form using
database. Online demo and
them in a database. There
these are extremely useful
ASP and MS Access. Easily
sample code available for
are constantly news items
SQL constructs and should be
installed, and customized.
download.
about companies where user
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: Mar, 20 2006


Date: Apr, 03 2001


Date: Sep, 18 2006
You can connect to an Access
Step-by-step tutorial on how
It is an often problem with
Article describes what is
database within an ASP page
to display uploaded binary
database intergration when
SQL? what it is used for?
with different methods. This
files from the database
you use a reserved word.
how to SELECT, INSERT,
article will help you to
using plain ASP pages. Every
Often asked why a script
UPDATE and DELETE records
create a System Data Source
step has been explained in
does not work and it quite
from the database? and more.
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: Jun, 14 2000


Date: Jun, 17 2002


Date: Aug, 28 2003


Date: Mar, 13 2002
{ Copyright } ©2019 NuclearScripts.com