/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
Sometimes, we would have
This code demonstrates how to
This article by James Shaw
Many a time, you are
chance to convert our
use an MD5 hash to encrypt
demonstrates how to
confronted with creating a
existing database or create
user passwords when storing
dynamically add properties
system DSN for use with ASP.
a new database. Some
them in a database. There
to an object (expando
If you have an ISP account,
decisions IT professionals
are constantly news items
properties) - by
this might take time and
need to make are scary, and
about companies where user
implementing a function to
more than sometimes - money.
choosing database software
information is compromised.
create named recordsets.
This article describes how
is one of them. This
By storing passwords using
to use File DSNs and save
overview aims to describe
an MD5 hash, even if your
time and money. Also, you
how to set database
database is compromised the
can reuse these DSNs and
connections with some common
passwords cannot be decoded.
thus, with some
database software (Oracle,
The only downside is that
modifications, use the same
MySQL, MS Access,MS SQL
users cannot retrieve lost
DSN for as many database
Server).
passwords, they must reset
connections.
them.
Date: Sep, 01 2003 Date: Sep, 18 2006 Date: Dec, 16 2000 Date: Jan, 25 2000 |
|
This article describes how to
SQL, Structured Query
Create a connection to DBF
You all must have seen and
use Microsoft SQL Server
Language, is the most
files using JetOLEDB
done stuff with the
triggers to automatically
powerful tool to connect to
provider (DSN-less,
RecordSet object, infact
record all updates and
a database regardless of the
ODBC-less connection), basic
everything is done with the
inserts for a particular
form of the database.
work with DBF files (select,
RecordSet object. Now, this
database table in a
However, building a perfect
insert, update), other ISAM
acticle explains how to use
customized history table.
SQL statement can be very
formats + FOXPRO option,
GetRows to page through the
frustrating. Especially
real sample code, create a
records that you recieve
debugging -- the error
new DBF file.
from the SELECT. It's much
message simply didn't tell
faster than MoveNext,
you where the error is. This
because it closes the
tutorial provides a nice
database connection
summary of SQL statements.
immediately whereas MoveNext
loops through the records
with the overhead of the
database connection. Plus
GetRows let's you count the
records correctly!
Date: Sep, 20 2001 Date: Feb, 15 2000 Date: Jun, 18 2003 Date: Oct, 04 2003 |
{ Copyright } ©2019 NuclearScripts.com