So you need a DSN-Less
This example / tutorial
Step-by-step tutorial on how
Providing search capabilities
connection but your not
explains how to use the LIKE
to upload files (images,
to a db enables users to
quite sure what to do. Well
operator to perform a
text, other documents, etc)
query on whichever element
we can do this for you. A
partial match on an Access
using plain ASP pages to the
you target them to. However
quick and easy way to make a
database.
database. Every step has
allowing users to target
connection without a DSN.
been explained in detail.
which portion of the db they
This will work for your MS
Downloadable source code
would like to query gives
Access database only. Now
available.
extra value. In this
includes SQL Server.
example, utilizing our db of
US States (state, statename,
and capital) the user can
search in any of three
fields (by dropdown menu
input) rather than the
application targeting one
specific table element.
Note: The db only has 50
observations in it, so it is
better to search on single
or double letter
combinations.
Date: Apr, 15 2002 Date: Dec, 08 2000 Date: Jun, 17 2002 Date: Jun, 26 2000 |
This code demonstrates how to
This is a group of 3
Filter method is very useful
Create a connection to DBF
use an MD5 hash to encrypt
tutorials that guide you
working with large datasets.
files using JetOLEDB
user passwords when storing
through the process of using
You might need to put only
provider (DSN-less,
them in a database. There
an MS Access Database in
some records from your
ODBC-less connection), basic
are constantly news items
ASP. The tutorials teach you
database but you should
work with DBF files (select,
about companies where user
how to connect to a
select all data from
insert, update), other ISAM
information is compromised.
database, add data to the
database. Fileter method is
formats + FOXPRO option,
By storing passwords using
database, update the
advantage working on
real sample code, create a
an MD5 hash, even if your
database, and delete from
recordsets after querying on
new DBF file.
database is compromised the
the database. The 3
SQL command.
passwords cannot be decoded.
tutorials togather allow you
The only downside is that
to build a simple Guestbook
users cannot retrieve lost
for your web site.
passwords, they must reset
them.
Date: Sep, 18 2006 Date: Sep, 03 2001 Date: Aug, 09 2006 Date: Jun, 18 2003 |