Thanks Suzy, CFQUERYPARM is what he needs.
Jared
| "Vordos, Suzy" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 01/13/2004 05:34 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]
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
