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