/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 800
*****
0.0

Suggestion Box

Hits: 787
*****
0.0
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
{ Copyright } ©2019 NuclearScripts.com