Yes, you can. If you're using PL/SQL, just make sure you define your
procedure's output as OUT variables. Recordsets should be defined as REF
CURSOR. Then use cfstoredproc to run the procedure.
Dunno about MX, but in 4.5, you have to take out that maxrows=
Of course, the logical distinction is that an Apache upgrade is free...
-Original Message-
From: Matt Liotta [mailto:mliotta@;r337.com]
While I agree with you that Macromedia should support Apache 2.0 for CF
5, I disagree with your post. You seem to imply that a normal IT shop
wouldn't wa
-Original Message-
From: Chunshen Li
> If a user is comfortable with "Foo must be a valid, non-negative number
> without fractions or decimals" wouldn't he/she be comfortable with
> "Enter an integer for this entry/field"? And the later seems simpler.
Except of course, that an integer c
If the calendar is in a separate frame/template, have a function onload that
sets a semaphore back in the links page. Until the semaphore is "on", don't
allow links to be opened.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 9:47 AM
To: CF-
./ means the current directory. (I've never seen this in a web document
before either)
/ means the root directory of the webserver.
-Original Message-
From: Schuster, Steven
Sent: Wednesday, December 17, 2003 1:24 PM
To: CF-Talk
Subject: RE: Weird Images issues...
./ is just another way
I would use a structure in the application scope to do this. Have the
username as the key and the time of failure as value.
-Original Message-
From: John Ho
Sent: Thursday, December 18, 2003 9:43 AM
To: CF-Talk
Subject: Session variable time out?
When user fails to log in, I want to disa
-Original Message-
From: Rob Rohan
Sent: Friday, January 30, 2004 12:00 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedure and CF 5.0
>
> datasource="#request.dsn#" debug="no"
> >
> cfprocparam dbVarName="ipaddress" value="#cgi.REMOTE_ADDR#"
> CFSQLtype="CF_SQL_VARCHAR" null="N
What version of CF are you using?
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 4:46 AM
To: CF-Talk
Subject: the oracle, the stored procedure and the cfstoredproc
I know I should be able to work this out, but it's wall butting time
Unless it changed from 6.1 to 6.0, you do not have to have a cfprocparam for
the ref cursor as someone else suggested.
We put our Oracle stored procedures in this format:
datasource="#request.dsn#"
returncode="No">
value="#iUserId#">
It seems very similar to yours, so not
-Original Message-
From: Thomas Chiverton
Sent: Friday, February 13, 2004 4:30 AM
To: CF-Talk
Subject: Re: the oracle, the stored procedure and the cfstoredproc
> > We put our Oracle stored procedures in this format:
> > It seems very similar to yours, so not sure if that is any help.
-Original Message-
From: Thomas Chiverton
Sent: Friday, February 13, 2004 10:24 AM
To: CF-Talk
Subject: Re: the oracle, the stored procedure and the cfstoredproc
On Friday 13 February 2004 15:19 pm, Plunkett, Matt wrote:
> > IS
> > possible though, we use Oracle stored procs
You could write a stored procedure that does something like:
1. select all rows, order by the column with dupes
2.loop through the rows, record the column's value at each iteration
3. if the current value is equal to the last value, delete the current row.
Of course this will leave only one o
Don't use a cfprocresult unless you're getting a ref cursor back. Just
refer to the variable as cookieId.
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 4:56 PM
To: CF-Talk
Subject: Cold Fusion and Oracle Stored Procedures
and here
Yeah I was a bit confused by that as well. If it works, great. Otherwise,
this is what I was suggesting, assuming that Id is the unique key and
reportId was the column with duplicates.:
select distinct reportId, Id from
testReports where date = {ts '2004-02-11 00:00:00'}
order by reportId
-Original Message-
From: Richard Crawford
Sent: Tuesday, February 24, 2004 3:24 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle Stored Procedures
> CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
> studentID IN int,
> studentInfo in out types.cursorType
> )
AFAIK, you can't
-Original Message-
From: Richard Crawford
Sent: Tuesday, February 24, 2004 4:12 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle Stored Procedures
> > Can you run your procedure directly in Oracle?
> It compiles just dandy.
But what happens when you run it? Do you get the results
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 9:56 AM
To: CF-Talk
Subject: OT: Radio button check
> How do I check whether a certain value is checked off on a radio button?
> The group name is "send". The value I want checked is whe
-Original Message-
From: Troy Simpson
Sent: Thursday, February 26, 2004 2:18 PM
To: CF-Talk
Subject: What is a Factory?
> 1. What is the general definition of a Factory?
> 2. What is the general definition of a Manager?
They're design patterns. I see that other folks have already e
-Original Message-
From: Cutter
Sent: Thursday, February 26, 2004 12:10 PM
To: CF-Talk
Subject: How do I...
pull all records from a table with the word "Beach" in the contents of a
field?
use like
oracle:
select * from table where upper(field) like '%BEACH%'
the upper function
-Original Message-
From: Nick de Voil
Sent: Friday, February 27, 2004 9:56 AM
To: CF-Talk
Subject: Re: Improving stored procedure
> BackOrder NOT LIKE '%HR%' could be causing you problems even if that
field
> is indexed, because you're not looking at the beginning of the field. Is
>
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 11:44 AM
To: CF-Talk
Subject: RE: Improving stored procedure
> So I want to search title and subtitle for "music." If I search only
title
> or only subtitle by itself, it pulls the information qui
Is it possible to call a PL/SQL function (not a procedure) using
CFSTOREDPROC from CF5? If so, what is the syntax?
Thanks,
Matt
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 5:00 PM
To: CF-Talk
Subject: Re: Call PL/SQL function from ColdFusion 5?
> Matt, if your function returns a string value, you can do something like
this:
>
> select myFunction(arg) from dua
-Original Message-
From: Adrocknaphobia
Sent: Thursday, March 04, 2004 11:15 AM
To: CF-Talk
Subject: Oracle / Stored Proc Issues
> So basically we've moved some code from dev to production and on
production it blew up.
> (big surprise right?) well the suprise is that whats blowing up is
-Original Message-
From: Mark W. Breneman
Sent: Tuesday, March 09, 2004 1:24 PM
To: CF-Talk
Subject: SQL custom Order by
> I doubt this is possible, but is there a way to do a custom order by
based
> on the order I provide? I need the SQL results to be in a specific order
> based on th
Is it possible to add custom commands to the right click menu in Homesite+?
I'd like to be able to comment selected blocks of code by right clicking. I
don't think this is possible, but thought I would ask. It is one of the
things I like about jEdit.
Failing that I suppose I'll have to define so
Ah well. The other thing I miss from jEdit is the Favorites menu in the
file lister. It's nice to be able to instantly jump to my Oracle folder to
edit tnsnames.ora and so on. If only jEdit would run faster on my
machine...
-Original Message-
From: Steve Nelson
Sent: Tuesday, March 23
-Original Message-
From: Rob
Sent: Tuesday, March 23, 2004 11:10 AM
To: CF-Talk
Subject: Re: right click to comment selection in Homesite+
> To be a jerk :) you can do that with cfeclipse there is a right click
option to comment out
> your selection and the default keyboard short cut is
Run your query through SQL+ using different optimizer hints like so:
select /*+ CHOOSE */ column from table etc etc
select /*+ RULE */ column from table etc etc
It could be that ColdFusion is using a different default hint than Oracle
is.
-Original Message-
From: Semrau Steven Ctr
It doesn't look like there is a direct way to do this since you want to sort
by the value instead of the key. If you were sorting by the key, you could
use ListSort(StructKeyList(departments)).
-Original Message-
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28,
I don't think this fits his needs, your output would be sorted on the key,
not value. He is not sorting based on position. I concur that you should
not expect a structure to be in any particular order.
> I'm looking:
> 1 Auto parts
> 5 Manufacturing
> 3 Sales
-Original Message-
From
We are setting up a new Windows 2000 server with CFMX 6.1 and IIS. The
server has gone through the SANS lockdown, and IIS was fairly aggressively
locked down also. We have other boxes like this that work fine with MX, but
this one for some reason is not able to write the application.log and
excep
the cf admin
area?
If so CF will nto make an application log I believe.
Adam H
On Thu, 29 Jul 2004 14:38:48 -0400, Plunkett, Matt <[EMAIL PROTECTED]>
wrote:
> We are setting up a new Windows 2000 server with CFMX 6.1 and IIS. The
> server has gone through the SANS lockdown, and II
CF. If you
have no reason for keeping it that way, consider making it just an OUT. And
I use variable="" instead of dbvarname="". In MX, you are correct that you
do not put a procparam for the ref cursor in.
-Original Message-
From: Ryan Geesaman
[Plunkett, Mat
SELECT *
FROM
(
SELECT WHATEVER, YOU, NEEED
FROM tablename
)
WHERE rownum < 4;
Do your ordering in the inner query.
-Original Message-
From: Heald, Tim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 7:40 AM
To: CF-Talk
Subject: Top n i
To do case insensitive like searches, I use UPPER() on both sides of the
where clause. I haven't tried it here, but WHERE
dbms_lob.INSTR(UPPER(section.text), UPPER('abc'))>0 may work fine.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 200
In Oracle 8 and 9, I believe the limit is 30 characters on any database
object.
-Original Message-
From: Jill Robin Pascua [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 8:28 AM
To: CF-Talk
Subject: OT: max length of a fieldname
What'st he maximum length for fieldnames in MS S
in on a blob
No, it doesn't work, dbms_lob is a package and INSTR is a function within
the package. It does not support UPPER.
-Deanna
- Original Message -
From: "Plunkett, Matt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wedne
Does the updater include MPSB03-06, MPSB03-07, MPSB04-01, and MPSB04-02?
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 7:44 PM
To: CF-Talk
Subject: Re: Hot-fixes
Earl, George wrote:
>
> What if you are building a new server (mig
-Original Message-
From: Ramesh Deva
Sent: Tuesday, August 05, 2003 3:58 PM
To: CF-Talk
Subject: Debugger for Oracle storeprocedures
> Anybody knows good debugger for Oracle Stored Procedures?
If you find one better than SQL Navigator for writing/debugging, please post
to the list. I di
I have CF Studio 5 and am just starting to code for MX a bit. Is there
anyway I can get tag insight and help files for the new MX stuff such as
cfc's? I looked around on the macromedia site a bit but couldn't find
anything.
Thanks,
Matt
~~~
-Original Message-
From: Raymond Camden
Sent: Monday, August 25, 2003 3:06 PM
To: CF-Talk
Subject: RE: DWMX 2004 - Whats new for us?
> Ah, but just HS, not HS+. Does anyone actually use HS i>nstead of HS+ (or
HS instead of CFS)? I'm not knocking it - just curious.
I use HS at home. Its
-Original Message-
From: Jerry Johnson
Sent: Wednesday, August 27, 2003 2:02 PM
To: CF-Talk
Subject: Re: DWMX 2004 - Whats new for us?
>I see it from exactly the opposite point of view.
>I am forever thankful Allaire (and Macromedia) have divorced the language
from the development enviro
43 matches
Mail list logo