Whenever I have used ORACLE stored procs (and we use ORACLE and SPs
eclusively here) with CF version 4, 4.5.1, 5 I have had to specify the
params in order or I recieved the wrong number of calls or types
error. As far as I know this has always been the situation but I
could always be
What syntax do I use in cfmx to retrieve oracle ref cursors as cf
recordsets?
The following is what I used in CF5 but it doesn't work in MX:
cfstoredproc datasource=#SID#
procedure=AKC.pkg_store_util.pr_sub_category_list
returncode=no
cfprocparam
dbvarname=in_cde_category
The company I work for is currently looking for an experienced (mid-senior level)
ColdFusion developer.
Other skills desirable are:
1) Oracle PL/SQL
2) Javascript
3) DHTML
4) Dreamweaver/Ultradev/Coldfusion Studio
This would be a 4 month contract. Onsite in Raleigh, NC. No relocation. The
What difference does it make? If you want it fill out the info... it is faster than
writing an email to complain about
it.
Gyrus wrote:
I am proud to announce the availability of our VTML Builder tool for
both use on our site and download.
Looks great!
Can you download it without
I already get a ton of spam...I don't like it so I delete it. And also I do not mind
filling out forms writing, or
deleting emails. Besides it seems I get so many more responses to any criticism I make
on this list than I do to any of
the questions I have needed answered so I thought I'd do
They are padded all the time the char fields in question range in length from char(4)
to char(10). Also a single trim()
doesn't work. I need to trim(trim()) or the length of the field is still 254. I have
no control over how the data will
be stored in the database. I have requested they all be
- Commerce Builder
- Original Message -
From: freddy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 2:24 PM
Subject: Re: [OT] Re: VTML Builder
I already get a ton of spam...I don't like it so I delete it. And also I
do not mind filling out forms writing
Ever since coming over to an ORACLE/Solaris envirionment I have had a
problem taking char(x) field and having it return with the right length. No
matter what length char field I use I get a length of 255 returned when
called from a pl/sql procedure.If the variable is not trimmed twice
I have a question regarding the use of oracle native drivers with oracle 8i and cf 5.
We have a user account set up for coldfusion that allows 50 connections.
However at any given time even under extreme load only one connection is actively
doing anything in oracle. The other
connections just
We are currently getting an inordinant amount of restarts as well. We also see
alot (over 10,000) i/o errors a day due to clients not waiting for a response from
our bogged down oracle 8i database server. We also recieved over 7,000 timeouts
even after bumping the timeout up to 45 second and
I am using cf5 and cfstoredproc to insert a date/time into oracle 8i. If I
pass only the date like this:
cfprocparam
dbvarname=in_DATE_EVENT_END
cfsqltype=cf_sql_varchar
value=03-Jan-2002
type=in
It works fine. but when I attempt to include the time as 03-Jan-2002 00:00
I get the following
Thanks to everyone.
I already had the date formatting correct.
I was using a perl script to generate the cfstoredproc for some reason it didn't
like the date datatype in oracle and
defaulted the cfsqltype to varchar. Changing the cfsqltype to date fixed the problem.
Thanks again,
Frederic
I agree with this in most cases. However it is not currently possible to cache
oracle stored procs in cf (except by assigning the results to session or
application variables). Also on most simple selects I found that the time for
processing was faster using embedded cf queries that calling a
You could try:
cftransaction action=BEGIN
cfquery name=qryCurrval datasource = DSN
SELECT
tbl_seq.nextval as tbl_currval
FROM
dual
/cfquery
cfquery name=qryInsert datasource=DSN
Insert Into tbl( name )
values( 'My Name' )
/cfquery
I would use a stored procedure. Only because I have yet to learn how to connect to a
function in oracle via cf. If this cane be done please let me know
what syntax to use.
Thanks,
Frederic
Troy Simpson wrote:
Freddy,
I believe that using a stored procedure might be the way to go
No PITA is a middle eastern bread.
Douglas Brown wrote:
A PITA Isnt that mexican bread lol :)
Doug
- Original Message -
From: Philip Arnold - ASP [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 07, 2001 9:41 AM
Subject: RE: If anyone else needs zip
How would you do this on a solaris install?
Ken Wilson wrote:
You just have to create it. Works great.
Ken
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 9:51 PM
To: CF-Talk
Subject: Re: CFToken and CFID not secure for
Kwang Suh wrote:
My heart goes out to you! You sound like you've had a bad experience with
a
session variable cult, or something. But if used in its proper context,
session variables can change your (work) life.
Yeah, but what's proper context? Do people even bother to do enough
Let me see. A scalable app that uses session vaiables? Try an application that
delivers personalized content. Store a cookie that logs the user in on entry to
the site. It then retrieves a list of links, images, and pertinent user info
that is stored in session variables. If the user moves to a
CFPLUG
Also check out http://www.akc.org I used a reworked cf version of hiermenus to drive
the dropdown lists on this site's
navigation menu.
/CFPLUG
Matt Robertson wrote:
CF_Hiermenus. Actually its a great script without the CF wrapper, albeit a
tad slow. Unmatched in its cross-browser
://www.cfdev.com/
-Original Message-
From: freddy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 3:54 PM
To: CF-Talk
Subject: Re: JMAIL
I am attempting to install the trial of cfx_jmail on a sun solaris box with
cf 4.5.1 and after following the directions
that came
I am attempting to install the trial of cfx_jmail on a sun solaris box with cf 4.5.1
and after following the directions
that came with the tag I have found that all that happens when I call the tag is cf
crashes and restarts via the
cfexecutive service. I have tried pointing the JVM path to
I beleive he means this looks to be the work of religious zealots. Hence the
reference to God being at the root of this. If you look throughout history you
will see that more atrocities have been perpetrated in the name of God than
for any other reason.
Frederic
[EMAIL PROTECTED] wrote:
i
Hm do religions that worship a different god not count? Take a
count most wars have religious as well as polical motivations. Did I ever
say be an athiest all I said was that more atrocities are committed in the
name of God.
Though wars do kill people and the results can be
All I can say is You idiot
Freedom wrote:
Truly think about this. If even a few people on those planes could have
been carrying a gun, none of this would have happened today. Yes, something
would happen sometime, but not this today! The wrong thinking has directed
the politically correct
Dave,
I did that long before I attempted to contact my support rep on the issue. That
didn't help at all they were running
already.
Dave Hannum wrote:
Check to see if RDS is running If not, start it then try again.
Dave
- Original Message -
From: Freddy [EMAIL PROTECTED
: Freddy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 6 September 2001 9:20 AM
To: CF-Talk
Subject: Re: ColdFusion license agreement
what did you do to get the browse function to work for setting up
datasources et al? I have installed numerous times on multiple boxes
(all
with win 2000 pro
what did you do to get the browse function to work for setting up
datasources et al? I have installed numerous times on multiple boxes (all
with win 2000 pro) and can not get the browse applets functioning even
with an service contract and numerous calls to our allaire support guy.
Thanks,
I was opening the server.log
However no matter the reason (for having the 3meg file) it opens fine in 4.5.x so me
thinks it is a bug.
CF studio is my text editor of choice... so when I want to open a text file I use it.
Thanks
Frederic
Neil Clark wrote:
Maybe you should question why you
Or maybe the upgrade should include ALL the functionality of the previous version. I
DO NOT code 3 meg files I just
attempted to open them...
I did not expect that pointing out a deficiency would have you attacking me. Why not
lighten up a bit?
If I were writing an app and I was making it
Dave,
Your fix for the cf admin and rds did not work for me. I no longer get the rds error
404 I now get connection cannot be
established. I still get the same error in the administrator.
Thanks anyway,
Frederic
~~
Structure your ColdFusion
I have continuosly had a problem with having to ctr + alt + del out of cf 5 whenever I
try to open large text files 3meg
+. Reported as a bug in the beta forum but no one ever responded.
Freddy
Mark Stewart wrote:
I'll have to agree with the Access Violations - It's happened to me a
few
Just as a point to note. I have not been able to get cf administrator in version 5 to
work correctly on my
win2k/apache install. The applet for browsing the server for a datasource (or any
other function that uses that
applet) does not work. I continually get i/o errors. I have tried it on two
If you're talking about security issues - worm vulnerabilities and buffer
overflow exploits, for example - the fault generally lies with the person
who installed IIS, and didn't follow IIS installation best practices (which
are strikingly similar to those for installing any accessible network
Has anyone experienced any major trouble with deployment of cf 4.5.1 applications on
cf 5?
We are getting ready to upgrade and a few of the different dept heads would like to
know how this may effect them
(currently it is only the dev box we are upgrading)
Well it seems even if IE does end up completely dominating the market we will still
be changing the code to comply with MS's changes to
the DOM in IE. 4 doesn't comply with 5, 5 doesn't comply with 5.5 and 6 probably
doesn't comply with 5.5. My bet is unless we go to the
completely integrated
Thanks to everyone that responded I guess it's just an inconvienience and not any
real trouble.
Thanks again,
Fred
John Forrester wrote:
Il giorno [DATA], [NOME], [INDIRIZZO] ha scritto:
I just looked again in my apache logs and I found an interesting entry. It
looks like all the
Just for information purposes we use session variables exclusively to manage our
personalization sessions and have not
yet gone up over 15% of memory usage. There are a minimum of actual variables used in
a session (an array of link
values, name, breed and breed image, plus a few flag fields).
I believe it means that the client has stopped waiting for the page to return and hit
stop or moved to another page
prior to the page being returned.
Freddy
Mak Wing Lok wrote:
did anyone know what caused this error?
Warning,08/14/01,11:11:04,(Apache) A network I/O error occurred while
I just looked again in my apache logs and I found an interesting entry. It looks like
all the other code red
entries I have but it is 1.78 megs of code can anyone tell me what this is? should I
be worried about being
infected? I was informed that only iis was susceptible to the worm but I have
Here is what I use to access an oracle sp:
cfstoredproc
datasource=#sid#
procedure=package.proc
returncode=no
cfprocparam
type=InOut
cfsqltype=CF_SQL_VARCHAR
variable=in_key
value=#key#
cfprocparam
dbvarname=out_rec_csr
variable=rec_cur
Hello,
I am wondering if anyone out there running cf 4.5.1 sp2 and oracle 8i has run across
this error in their application logs
Oracle Error Code = 0PTimeout while obtaining an Oracle statement lock
We are getting a bunch of them on and off (some days 10 some days 60) They started
showing up
Thanks John.
John Cummings wrote:
Frederic,
The PVCS integration works pretty much the same way in Studio as VSS
does/would except that you would choose a different source control
provider when you first set up the project.
J.
[EMAIL PROTECTED]
-Original Message-
From: freddy
All I can say is it has taken me three years of persistant complaining to get
interwoven's teamsite out of our shop. The
technical support they provided with a 16,000.00 yearly contract was horrendous. The
product was never configured
correctly for our needs (even after an expensive onsite
Along the same line as the VSS thread. What is the best way to integrate cf studio and
merant pvcs? Is it a better idea
to not integrate the two and just use cf studio as an editor and pcvs as a separate
source control project?
Thanks,
Frederic
I have a fairly unique situation here. Our cf server has very limited access rights.
It cannot write any files at all
anywhere on our servers. In this case how would it be possible to exploit the security
hole? We have a subscription to
cf and are going to be upgrading asap but are currently
Remember if the js file is included lik this:
Script language="Javascript" src="/src/dynapi.js"/script
you have to wrap the include in a:
script language="JavaScript"
cfinclude template="/dd/src/dynapi.js"
/script
In the preceding instance the src directory is on the root of the
I am using Access as a database and it does not support the PATINDEX function. Any
other thoughts?
Seva Petrov wrote:
Frederic,
You can try using PATINDEX to set a bit on the matching town and then order
on the results of the PATINDEX, which will return the town with the bit set
first:
MOTown=T.RMOTown AND
T.RMOTown'#RMOTOWN#' AND
Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE
RMOTown='#RMOTOWN#')
ORDER BY T.rmotown, A.PrimaryName
/cfquery
/cfif
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-Original Message
.rmotown, A.PrimaryName
/cfquery
-Original Message-
From: Freddy [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:50 PM
To: CF-Talk
Subject: QUERY TROUBLE
I have a query that returns a list of attractions in a certain town. If the town
is in a "cluster"
I have a query that returns a list of attractions in a certain town. If the town is in
a "cluster" (a group of
related towns) it also needs to order by the selected town first and then list the
rest of the towns
alphabetically.
How would I get this output from the following queries?
cfquery
How to stop worrying and learn to love the session. :-)
Don't forget to wrap a cflock around that code.
Bryan Love wrote:
Why you would want to convert innocent, safe form fields into tricky,
unstable session variables is beyond me, but here's the code...
cfloop list="#form.fieldnames#"
Couldn't you use Permissions.PermissionID IN " '4','5' "
Tim Fields wrote:
I have a client that has an existing SQL Server database which includes a
table used as part of a permissions framework. The problem is that whoever
created the table was clever enough to create a column for
get it to verify
correctly. Any ideas?
Deb Dickerson wrote:
What are you specifically referring to? There aren't any SQL Server native
drivers with ColdFusion, only ODBC drivers.
Debbie
- Original Message -
From: "Freddy" [EMAIL PROTECTED]
To: "CF-Talk" [EM
Could someone please point me in the right direction to get information on configuring
sql server native drivers? I
have searched the allaire knowledge base and found nothing and cannot find anything in
the documentation the goes
through the whole process.
Thanks
Andrew Scott wrote:
Yes I
I am having a problem I hope someone here can help with. I have a client that I work
for remotely. Currently for
some reason I cannot access their website or connect via ftp, telnet, or as an rds
from any of my NT based
machines.
1: NT 4 SP 6
2: Win 2000 professional
I have no trouble using
Sorry can't help you there.
Jeff Britts wrote:
Basically, we're working on a tool to generate the pl/sql script on the fly
so we
cant use a stored proc. Any ideas?
-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:54 AM
To:
57 matches
Mail list logo