Thanks Suzy, CFQUERYPARM is what he needs.
Jared
| "Vordos, Suzy" <Suzy.Vordos@qwest.com>
Sent by: ml-errors@fatcity.com
01/13/2004 05:34 AM
Please respond to ORACLE-L
|
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
Subject: RE: Cold Fusion and Bind Variables |
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
-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]On Behalf Of Jared.Still@radisys.com
Sent: Monday, January 12, 2004 6:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Cold Fusion and Bind Variables
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:
INET: Jared.Still_at_radisys.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 - 11:19:32 CST