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:
Thanks,
Frederic
__
Structure your ColdFusion code with Fuseb
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
candid
/www.quilldesign.com
> SiteDirector - 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 alread
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 c
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 it
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 witho
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
trim(trim(#v
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 sit
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 still
Thanks to everyone.
I already had the date formatting correct.
I was using a perl script to generate the 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
Tony Schreiber
I am using cf5 and to insert a date/time into oracle 8i. If I
pass only the date like this:
It works fine. but when I attempt to include the time as 03-Jan-2002 00:00
I get the following error
ORA-01830: date format picture ends before converting entire input
string ORA-06512: at line 1
anyon
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 store
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
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 t
You could try:
SELECT
tbl_seq.nextval as tbl_currval
FROM
dual
Insert Into tbl( name )
values( 'My Name' )
I am not sure if this would work but it seems that it would get the nextval prior to
it being assingned using the
trigger.
Al
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
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 di
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
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.
Matt Robertson wrote:
> CF_Hiermenus. Actually its a great script without the CF wrapper, albeit a
> tad slow. Unmatched in its cross-browser compatibility
; ColdFusion Developer Resources
> http://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 sol
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 /ser
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 co
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 atr
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 fe
-Original Message-
> From: 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 nume
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 -
>
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,
G
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 code
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 bett
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 ha
>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
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
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
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
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). W
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 t
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
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"
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 = 0Timeout 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 wh
Here is what I use to access an oracle sp:
works fine for us.
Frederic
Alex Skinner wrote:
> I dont believe you can use output parameters with Oracle I may be wrong?
>
> Alex
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf
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 train
gt;
> -Original Message-
> From: freddy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 1:12 PM
> To: CF-Talk
> Subject: CF 4.5 and pvcs
>
> 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 n
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 i
Remember if the js file is included lik this:
you have to wrap the include in a:
In the preceding instance the src directory is on the root of the site and the site
has a coldfusion mapping of dd.
Hope that helps.
Frederic
Dave Hannum
x27;#RMOTOWN#')
> AND A.RMOTown=T.RMOTown
>
> WHERE T.RMOTown='#RMOTOWN#'
> AND A.RMOTown=T.RMOTown
>
> order by iif(T.RMOTown='#RMOTOWN#',0,1), T.rmotown, A.PrimaryName
>
>
&g
e WHERE
> RMOTown='#RMOTOWN#')
> ORDER BY T.rmotown, A.PrimaryName
>
>
>
> Bryan Love ACP
> Internet Application Developer
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Freddy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 3:50
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
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?
SELECT
How to stop worrying and learn to love the session. :-)
Don't forget to wrap a 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...
>
>
>
>
>
>
> Bryan Love ACP
>
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 permiss
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" <[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 ha
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 m
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
57 matches
Mail list logo