/**
popular collection of scripts for all
*/
/** Search */
{
Sql Statements
}|
Be a better ColdFusion
This article presents three
This short tutorial
The Compsys IntrSQL product
scripter with these tips
modular routines to access
demonstrates how to insert
is a component that allows
covering everything from
and fetch data easier with
data into a SQL database
SQL Statements to be
effective use of variables
ASP. Topics include:
using SQL statements.
run against almost any
to securing your
Fetching a Recordset, An
database over the Internet.
applications to
alternative to the
The SQL Statement (along
object-oriented techniques.
GetConnectedRecordSet
with DSN, Username and
Some of the main topics
function that opens a
Password) are entered via
covered: Generate Dynamic
connection, fetches a
any standard HTML (or ASP)
SQL Statements,
recordset, and immediately
page and the results are
Secure Your Applications,
closes the connection, and
returned as standard HTML.
Time Out Client Variables,
Utilities for Creating Valid
The look and feel of the
Leverage Application
SQL Statements.
resulting HTML can be
Variables, Set Your Root
formatted by the user (via
Directory, Include a Menu
IntrSQL parameters) to suit
With Dynamic Highlighting,
most web styles and layouts.
Tag Your Page Formatting,
Most SQL statements
Use Evaluate to Increase
are supported including
Reusability, Protect Against
Select, Insert, Update,
Cross-Site Scripting, and
Delete, Create, Drop etc.
Use Fusebox.
In addition IntrSQL also
supports Describe (to detail
the Table Attributes) for
SQL Server, Access and
Oracle databases. To run
IntrSQL you require the
database to have a valid
Data Source Name (DSN) or
connection string and the
appropriate User permissions.
Date: Nov, 06 2000 Date: May, 16 2001 Date: Oct, 13 2000 Date: Jan, 18 2001 |
|
SAL provides a set of classes
SQL, Structured Query
SqlFun is a Java
Village is a 100% Pure Java
for creating and
Language, is the most
program/applet that allows
API that sits on top of the
manipulating SQL
powerful tool to connect to
you to experiment with
JDBC API. The purpose of
statements. This makes
a database regardless of the
SQL statements
this API is to make it
it easy to refer to your
form of the database.
(hopefully) without having
easier to interact with a
SQL statements
However, building a perfect
to install a SQL server or
JDBC compliant relational
by-name instead of by-value,
SQL statement can be very
database program. All you
database. By using Village,
increasing portability. It
frustrating. Especially
need is Java and Windows
it is possible to execute
also means you do things
debugging -- the error
ODBC (or any other database
and manage
like have a search form
message simply didn't tell
server that supports JDBC).
select/insert/update/delete
generate SQL (including
you where the error is. This
Starting from version 2.3,
SQL statements
arbitrary SQL joins) on the
tutorial provides a nice
newly added undo/redo of SQL
without having to actually
fly.
summary of SQL
statement editing, and
write a single line of SQL.
statements.
simple SQL statement syntax
Village can use any valid
highlight.
JDBC Connection object, so
it is possible to use
Village with a JDBC
Connection pool.
Date: Jul, 19 2000 Date: Feb, 15 2000 Date: Aug, 23 2002 Date: Jun, 27 2000 |
{ Copyright } ©2006 NuclearScripts.com