|
It is an often problem with
This short tutorial
Here's how to get started
DB_Browser is a CGI tool for
database intergration when
demonstrates how to insert
using SQL and
developers working with a
you use a reserved word.
data into a SQL database
SQL-driven databases from
relational database. It
Often asked why a script
using SQL statements.
Perl. Main topics include:
easily facilitates
does not work and it quite
General information about
searching, editing, and
often comes down the the
relational databases, About
adding tables within a
author setting a field name
SQL, What DBI is For,
database, as well as
as a reserved word,
Example of How to Use DBI,
directly querying the
confusing SQL and
Cached Queries, and
database using SQL in
making debugging hard. To
Transactions.
a web-browser form. While it
solve this problem here is a
can be used as a regular
quick list of the SQL
interface to database data
Reserved Words.
itself, it works well as a
supplemental tool for
developers creating their
own primary interface.
Date: Aug, 28 2003 Date: Oct, 13 2000 Date: May, 12 2000 Date: Dec, 04 2000 |
|
One of the most powerful
This article explains how to
jOmniGate is an O/R-mapper
In this second part of the
enhancements for any site is
design and program a
for timespending and
series, it describes 7
to establish community and
multifunctional shopping
reusable development of
common mistakes in PHP
personalization features. In
cart application using
databased applications
programming that will lead
our new series, we are going
SQL Server, ASP, and
without using sql or
to drastically slower run
to demonstrate how to add
ODBC. Source code available
any database-specific
times and less secure
community and
for download.
language. By using
scripts, in addition to less
personalization features to
jOmniGate-api your programs
maintainable code. Topics
your web-site. The first
will run without any changes
covered: Not Following Basic
step to reach this goal is
the same with
MySql,
Naming Conventions (Variable
to allow user registration.
Oracle, interbase and
Naming, Function Naming),
In this first article, we
others.
jOmniGate supports
Databases & SQL
show you how to add user
automatic table-creation and
(Misapplying database
registration to your site
-update, automatic mapping
functions, Misusing
using SQL Server and
between java-classes and
SQL: Not Fetching What
ASP.
db-tables and much more.
You Need, Misusing
SQL: Not Fetching What
You Need), Lack of Error
Checking, Overusing OO,
Misusing Regular
Expressions, Programming PHP
Like It Was Some Other
Language, and Not Being
Security Conscious (System
Call Security, Checking an
e-mail address).
Date: Aug, 11 2000 Date: Apr, 13 2001 Date: Sep, 20 2001 Date: Oct, 21 2000 |