Oops. Yes, I should have been more specific :) and stipulated "bind
variables". I'm talking about improving our db performance by "caching" the
best execution paths for the queries.
I know 4.5 uses the CFQUERYPARAM tag, but alas, we are still on 4.0.
I was hoping that there would be an equivalent way in 4.0 that would be
relatively painless, but from what I've found so far, it looks like our only
choice would be to used stored procedures to pass the variables to Oracle
and allow Oracle to do the rest...
----Original Message Follows----
From: "DeVoil, Nick" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Syntax for binding a query?
Date: Mon, 05 Feb 2001 15:26:04 -0000
> Can anyone tell me what the SQL syntax is for binding a query (Oracle
db)?
Terri,
Not sure what you mean.
To me "binding a query" refers to the action of associating values
with variable names when when querying a database. In SQL this is
simply done by saying "WHERE columnname = value".
Or are you asking about "bind variables" in Oracle PL/SQL?
These are local variables in stored procedures or triggers which you
declare "VARIABLE variablename datatype" and refer to by saying
something like ":variablename := value"
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
