/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part 1

Hits: 669
*****
0.0
Article describes what is
It is an often problem with
Dropdowns or combo boxes are
Step-by-step tutorial on how
SQL? what it is used for?
database intergration when
an excellent way to get
to display uploaded binary
how to SELECT, INSERT,
you use a reserved word.
input from a user. One of
files from the database
UPDATE and DELETE records
Often asked why a script
the biggest problems with
using plain ASP pages. Every
from the database? and more.
does not work and it quite
user input is spelling and
step has been explained in
 
often comes down the the
formatting. Here is how to
detail. Downloadable source
 
author setting a field name
use and populate dropdowns
code available.
 
as a reserved word,
from a database.
 
 
confusing SQL and making
 
 
 
debugging hard. To solve
 
 
 
this problem here is a quick
 
 
 
list of the SQL Reserved
 
 
 
Words.
 
 


Date: Mar, 13 2002


Date: Aug, 28 2003


Date: Aug, 05 2002


Date: Jun, 17 2002
You can connect to an Access
Allowing multiple choices of
This article shows how to
Many a time, you are
database within an ASP page
data elements enables people
generate random records from
confronted with creating a
with different methods. This
to customize views of your
the database. Also explains
system DSN for use with ASP.
article will help you to
data and adds value to your
how to generate random
If you have an ISP account,
create a System Data Source
applications. In this sample
numbers. Sample Database and
this might take time and
Name (DSN) for an Access
code, user inputted
Code available for download.
more than sometimes - money.
database on your local
choice(s) are added to the
 
This article describes how
machine.
basic sql statement to draw
 
to use File DSNs and save
 
them from the db. Since the
 
time and money. Also, you
 
input from the dropdown menu
 
can reuse these DSNs and
 
comes through comma
 
thus, with some
 
delimited it is simply
 
modifications, use the same
 
written into the statement
 
DSN for as many database
 
without modification. Two
 
connections.
 
simple for next loops
 
 
 
determine which elements are
 
 
 
part of the record set and
 
 
 
displays them accordingly.
 
 


Date: Jun, 14 2000


Date: Aug, 06 2000


Date: Aug, 30 2000


Date: Jan, 25 2000
{ Copyright } ©2019 NuclearScripts.com