Hi
Jared,
Look at
QFQUERYPARM:
Usage
The CFQUERYPARAM is designed to do the following
things:
Allows the use of SQL bind
parameters.
Allows long text
fields to be updated from an SQL
statement.
Improves
performance.
The ColdFusion ODBC, DB2, Informix, Oracle 7 and
Oracle 8 drivers
support SQL bind parameters.
However, at present, the ColdFusion Sybase
11 driver
and Sybase native driver do not support SQL bind
parameters.
If a database does not support bind parameters,
ColdFusion still
performs validation and substitutes
the validated parameter value back
into the string.
If validation fails, an error message is returned.
Suzy
Dear List,
We have a
developer here that is pretty good with the web stuff, but his strong
suit is not databases, or at least not
Oracle.
He develops primarily in
Cold Fusion, which I know little about.
I'm trying to teach him the difference between literal and bind
variables, and the
importance of
knowing the difference. While it is easy to demonstrate this
in PL/SQL or Perl, I have no idea how to do
so in CF.
A few minutes of
googling didn't really turn up anything useful.
I'm looking for some examples of using bind variables
in SQL as used
in Cold Fusion that
connects to Oracle 8i. If you have one, the virtual
beer is on me. :)
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vordos, Suzy
INET: Suzy.Vordos_at_qwest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jan 13 2004 - 07:34:38 CST