/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Database Search Sample Code

Hits: 493
*****
0.0

Display Image From Database

Hits: 292
*****
0.0
It is somewhat ironic that
Here is a quick sample of
It is possible to store
This is a comprehensive
the most confusing part of
searching a DB for certain
images in a database using a
tutorial on how to
creating and executing a SQL
records. It's really no
number of third party tools
incorporate SQL server
statement from ASP is
different then doing any
or a custom built component.
7.0/2000 databases into your
determining where to put the
other query except that you
Once you have the images
ASP pages. Topics include:
quotes. When is a single
need to use wildcards. In
stored in your database,
Installation steps, Creating
quote used? When is a double
ASP / ADO the wildcard
however, displaying them
SQL Server 7.0/2000
quote used? When are they
character is %. It works the
requires the use of a simple
Databases, Creating SQL
used together? Which takes
way most of us have come to
ASP page. This tutorial
Server 7.0/2000 Tables,
precedence? This article
expect * to work. Why is it
explains how to retrieve
Creating SQL Server 7.0/2000
will answer these questions.
%? I have no idea, but it
images from a database table
Logins, Setting SQL Server
 
is. An Access 97 version of
and use them in an HTML page.
7.0/2000 Permissions,
 
the database is available
 
Increasing SQL Server
 
for download.
 
7.0/2000 Performance with
 
 
 
Indexes, and Distributed SQL
 
 
 
Server 7.0/2000 Transactions
 
 
 
& Queries.


Date: Feb, 27 2001


Date: Feb, 20 2001


Date: Jan, 11 2001


Date: Jan, 08 2001
Explains everything in detail
In this first article of the
This article discusses two
This article by James Shaw
you'll ever need to know
ASPHoleTools series, you
different ways to
demonstrates how to
about creating Stored
will be shown the basics for
dynamically generate
dynamically add properties
Procedures in Access
data access. Covers how to
data-entry forms: Use the
to an object (expando
Database and then calling
create the basic include
ADO OpenSchema Method, and
properties) - by
from within ASP. Select,
file for database access,
Query Your SQL Server System
implementing a function to
Update, Insert and Delete
and testing that data access
Tables. Describes advantages
create named recordsets.
Stored Procedures are
was installed properly on
and disadvantages of each
 
described. Sample code and
your machine.
method.
 
database available for
 
 
 
download.
 
 
 


Date: Jan, 07 2001


Date: Dec, 21 2000


Date: Dec, 18 2000


Date: Dec, 16 2000
{ Copyright } ©2019 NuclearScripts.com