/**

popular collection of scripts for all

*/
/** Search */

{ 

Sql Statements

 }

10 ColdFusion Scripting Tips

Hits: 20
*****
0.0

Village

Hits: 16
*****
0.0

SqlFun

Hits: 14
*****
0.0

SQL Tutorial

Hits: 14
*****
0.0
Be a better ColdFusion
Village is a 100% Pure Java
SqlFun is a Java
SQL, Structured Query
scripter with these tips
API that sits on top of the
program/applet that allows
Language, is the most
covering everything from
JDBC API. The purpose of
you to experiment with
powerful tool to connect to
effective use of variables
this API is to make it
SQL statements
a database regardless of the
to securing your
easier to interact with a
(hopefully) without having
form of the database.
applications to
JDBC compliant relational
to install a SQL server or
However, building a perfect
object-oriented techniques.
database. By using Village,
database program. All you
SQL statement can be very
Some of the main topics
it is possible to execute
need is Java and Windows
frustrating. Especially
covered: Generate Dynamic
and manage
ODBC (or any other database
debugging -- the error
SQL Statements,
select/insert/update/delete
server that supports JDBC).
message simply didn't tell
Secure Your Applications,
SQL statements
Starting from version 2.3,
you where the error is. This
Time Out Client Variables,
without having to actually
newly added undo/redo of SQL
tutorial provides a nice
Leverage Application
write a single line of SQL.
statement editing, and
summary of SQL
Variables, Set Your Root
Village can use any valid
simple SQL statement syntax
statements.
Directory, Include a Menu
JDBC Connection object, so
highlight.
 
With Dynamic Highlighting,
it is possible to use
 
 
Tag Your Page Formatting,
Village with a JDBC
 
 
Use Evaluate to Increase
Connection pool.
 
 
Reusability, Protect Against
 
 
 
Cross-Site Scripting, and
 
 
 
Use Fusebox.
 
 
 


Date: Nov, 06 2000


Date: Jun, 27 2000


Date: Aug, 23 2002


Date: Feb, 15 2000
This article presents three
This short tutorial
The Compsys IntrSQL product
SAL provides a set of classes
modular routines to access
demonstrates how to insert
is a component that allows
for creating and
and fetch data easier with
data into a SQL database
SQL Statements to be
manipulating SQL
ASP. Topics include:
using SQL statements.
run against almost any
statements. This makes
Fetching a Recordset, An
 
database over the Internet.
it easy to refer to your
alternative to the
 
The SQL Statement (along
SQL statements
GetConnectedRecordSet
 
with DSN, Username and
by-name instead of by-value,
function that opens a
 
Password) are entered via
increasing portability. It
connection, fetches a
 
any standard HTML (or ASP)
also means you do things
recordset, and immediately
 
page and the results are
like have a search form
closes the connection, and
 
returned as standard HTML.
generate SQL (including
Utilities for Creating Valid
 
The look and feel of the
arbitrary SQL joins) on the
SQL Statements.
 
resulting HTML can be
fly.
 
 
formatted by the user (via
 
 
 
IntrSQL parameters) to suit
 
 
 
most web styles and layouts.
 
 
 
Most SQL statements
 
 
 
are supported including
 
 
 
Select, Insert, Update,
 
 
 
Delete, Create, Drop etc.
 
 
 
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: May, 16 2001


Date: Oct, 13 2000


Date: Jan, 18 2001


Date: Jul, 19 2000
{ Copyright } ©2006 NuclearScripts.com