/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

How to create a System DSN for Access database

Hits: 632
*****
0.0

Multiple Form Selection (Where In)

Hits: 631
*****
3.0

Named Recordsets

Hits: 626
*****
0.0

Generating random records from the Database

Hits: 626
*****
0.0
You can connect to an Access
Allowing multiple choices of
This article by James Shaw
This article shows how to
database within an ASP page
data observations enables
demonstrates how to
generate random records from
with different methods. This
people to customize views of
dynamically add properties
the database. Also explains
article will help you to
your data and adds value to
to an object (expando
how to generate random
create a System Data Source
your applications. This
properties) - by
numbers. Sample Database and
Name (DSN) for an Access
example utilizes our db on
implementing a function to
Code available for download.
database on your local
the career statistics of
create named recordsets.
 
machine.
Hammerin’ Hank Greenberg.
 
 
 
The years he played are
 
 
 
available to select from in
 
 
 
a dropdown menu. When
 
 
 
multiple years are selected
 
 
 
they are passed comma
 
 
 
delimited. Utilizing the
 
 
 
where in statement in our
 
 
 
sql the comma delimited
 
 
 
selections are appended to
 
 
 
our sql statement to display
 
 
 
only those years selected.
 
 


Date: Jun, 14 2000


Date: Oct, 04 2000


Date: Dec, 16 2000


Date: Aug, 30 2000
It is an often problem with
Step-by-step tutorial on how
Article describes what is
SQL, Structured Query
database intergration when
to display uploaded binary
SQL? what it is used for?
Language, is the most
you use a reserved word.
files from the database
how to SELECT, INSERT,
powerful tool to connect to
Often asked why a script
using plain ASP pages. Every
UPDATE and DELETE records
a database regardless of the
does not work and it quite
step has been explained in
from the database? and more.
form of the database.
often comes down the the
detail. Downloadable source
 
However, building a perfect
author setting a field name
code available.
 
SQL statement can be very
as a reserved word,
 
 
frustrating. Especially
confusing SQL and making
 
 
debugging -- the error
debugging hard. To solve
 
 
message simply didn't tell
this problem here is a quick
 
 
you where the error is. This
list of the SQL Reserved
 
 
tutorial provides a nice
Words.
 
 
summary of SQL statements.


Date: Aug, 28 2003


Date: Jun, 17 2002


Date: Mar, 13 2002


Date: Feb, 15 2000
{ Copyright } ©2019 NuclearScripts.com