RE: Cold Fusion and Bind Variables

[Vordos, Suzy]

 

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