----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 17:04:56 -0000
Yes, that sounds like a good idea.
I don't think CFQUERYPARAM would have helped you with
performance anyway. It just validates the parameters
you pass to the stored procedure.
--I think you're thinking of CFPROCPARAM. CF*QUERY*PARAM enables the use of
bind variables in a query (according to the Allaire article titled
"CFQUERYPARAM and Oracle Databases" by Justin Fidler--it's actually quite a
good article. Someone on another list pointed it out to me this morning.)---
I'm guessing here but are you actually looking for the
syntax for passing parameters to an Oracle stored procedure?
--Nope. Though I do appreciate the example. I've had my share of passing the
params to Oracle, and it's not always easy :)) Extra examples are always
appreciated!--
Thanks for the help! I think we're just going to push for the upgrade to 4.5
(with a subscription, of course, with 5.0 and Neo on the horizon ;)
Terri
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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