/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

WiredNow.net: SQL Reserved Words

Hits: 673
*****
0.0

SQL In Simple English - Part 1

Hits: 673
*****
0.0

Named Recordsets

Hits: 673
*****
0.0

Displaying binary data from the database using plain ASP

Hits: 672
*****
4.0
It is an often problem with
Article describes what is
This article by James Shaw
Step-by-step tutorial on how
database intergration when
SQL? what it is used for?
demonstrates how to
to display uploaded binary
you use a reserved word.
how to SELECT, INSERT,
dynamically add properties
files from the database
Often asked why a script
UPDATE and DELETE records
to an object (expando
using plain ASP pages. Every
does not work and it quite
from the database? and more.
properties) - by
step has been explained in
often comes down the the
 
implementing a function to
detail. Downloadable source
author setting a field name
 
create named recordsets.
code available.
as a reserved word,
 
 
 
confusing SQL and making
 
 
 
debugging hard. To solve
 
 
 
this problem here is a quick
 
 
 
list of the SQL Reserved
 
 
 
Words.
 
 
 


Date: Aug, 28 2003


Date: Mar, 13 2002


Date: Dec, 16 2000


Date: Jun, 17 2002
Dropdowns or combo boxes are
This article shows how to
Many a time, you are
Allowing multiple choices of
an excellent way to get
generate random records from
confronted with creating a
data elements enables people
input from a user. One of
the database. Also explains
system DSN for use with ASP.
to customize views of your
the biggest problems with
how to generate random
If you have an ISP account,
data and adds value to your
user input is spelling and
numbers. Sample Database and
this might take time and
applications. In this sample
formatting. Here is how to
Code available for download.
more than sometimes - money.
code, user inputted
use and populate dropdowns
 
This article describes how
choice(s) are added to the
from a database.
 
to use File DSNs and save
basic sql statement to draw
 
 
time and money. Also, you
them from the db. Since the
 
 
can reuse these DSNs and
input from the dropdown menu
 
 
thus, with some
comes through comma
 
 
modifications, use the same
delimited it is simply
 
 
DSN for as many database
written into the statement
 
 
connections.
without modification. Two
 
 
 
simple for next loops
 
 
 
determine which elements are
 
 
 
part of the record set and
 
 
 
displays them accordingly.


Date: Aug, 05 2002


Date: Aug, 30 2000


Date: Jan, 25 2000


Date: Aug, 06 2000
{ Copyright } ©2019 NuclearScripts.com