FW: More problems with hourly digests?

[RADEMAKERS Tanguy]

oops, looks like the quoted text was stripped out. What i *meant* to say
was:

Hello,

Here below the latest hourly digest received from CF-Talk in 
its entirety. As you can see, some information would seem to 
have been left out ;)

This has been happening every once in a while over the last 
week or two, bust usually there's *some* information in the digest.

--start of digest --
From: CF-Talk [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 5:00 PM
To: CF-Talk
Subject: ColdFusion Technical Talk (CF-Talk): Digest every hour


ColdFusion Technical Talk (CF-Talk)  22-Aug-06 
Issue:840
In this issue:
 Firefox vs. JavaScript
 Parsing an XML Feed
 Parsing an XML Feed



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250611
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

More problems with hourly digests?

[RADEMAKERS Tanguy]

Hello,

Here below the latest hourly digest received from CF-Talk in its
entirety. As you can see, some information would seem to have been left
out ;)

This has been happening every once in a while over the last week or two,
bust usually there's *some* information in the digest.

>-Original Message-
>From: CF-Talk [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, August 22, 2006 5:00 PM
>To: CF-Talk
>Subject: ColdFusion Technical Talk (CF-Talk): Digest every hour
>
>
>ColdFusion Technical Talk (CF-Talk)  22-Aug-06 
>Issue:840
>In this issue:
> Firefox vs. JavaScript
> Parsing an XML Feed
> Parsing an XML Feed
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: what if the next CF...

[RADEMAKERS Tanguy]

Hello,

Apologies in advance for the long and OT post. Don't worry, this isn't
yet another cf wish list (or is it?). This really is long and rambling,
so you will need coffee, and you might not want to read this at your
desk... maybe print it and take it home for the weekend?

Unless you've been living under a rock for the past few weeks, you've
probably seen / read / commented on one of the umpteen "CF 8 wish list"
blog postings / email threads / surveys / etc that have been floating
around. Recently, we all got the chance to do the same thing for the
"ultimate CF IDE" on Damon Cooper's blog [1] - which currently has over
100 comments. Reading through those comments, i came away with the
impression that, warts and all, Eclipse based tools are taking over the
cf developer workbench. As we should all know, Adobe is part of the
Eclipse foundation (whatever that means) and even just started selling
an Eclipse based solution for flex...

One of those blog comments, from Mr. Cooper himself, reads:

>I sincerely hope we can both pleasantly shock and awe you with what we
>have on store.
>
>I will say this: the solution we come up with may not be what you're
>expecting, but it may be what just what you've wished for :)
>
>Damon

(For those who don't know, Damon works for Adobe)

For no other reason than the fact that it's Friday and that i've had
waaay too much coffee today, this has put me in full on "conspiracy
theory" mode, so i thought i'd pour out my "what if" before the black
helicopters show up ;)

In short: what if the next version of CF was split into two (or more)
parts: a (probably eclipse based?) client side tool and an (optional?)
server side tool? 

Basically, what if they pulled a Flex on CF? 

Remember Flex 1, the twelve thousand dollar server side component? Now
we've got Flex 2 which comprises:

- a free of charge SDK / compiler for MXML and AS3
- a commercial IDE / gui builder, also available with an
optional commercial plugin for charting and graphing
- a set of server side components which you can buy if you need
them (Interestingly enough, these seem to be free for one cpu servers?)

This is a BIG change in strategy, since it opens the Flex door to people
who don't work in "enterprise" IT. You can now play for free, or spend a
reasonable amount of money for a tool that will undoubtedly make you
much more productive, or go "whole hog" for a set of server components
that will allow you to do more "heavy lifting" kinds of things. Also,
since the SDK compiles your flex apps to a standard swf file, i'm
guessing you can now write a simple Flex RIA (although i guess a flex
"component" would be a better term) and deliver it to a customer **who
does not own any kind of Flex server license** to deploy on their own
systems.

But enough about Flex. Let's just imagine for a second...

1) How would/could this work?

When you think of it, there are already two main "parts" to cfmx. On the
one hand, you have code that parses CFML, generates java code from that,
and hands that java code off to the underlying app server (JRUN or
whatever) to compile into executable code. This is why you can already
pre-compile your cf code today, using the cfcompile script that ships
with CF. If you look into that, you'll see that the work is done by a
call to coldfusion.tools.Compiler, which lives in your
/WEB-INF/cfusion/lib/cfusion.jar. On the other hand, you have a bunch of
runtime services, which is basically all the stuff you find in the cf
server administrator: data source management, scheduled tasks, event
gateways, yadda yadda etc.

This is the question: what if you turned cf into TWO products: an SDK /
IDE combo that included at least the cfml parser and maybe even the
compiler, and a server component that gave you access to more
"enterprisey" options?

Well, if you had a parser and compiler in the IDE, you could certainly
do some pretty amazing things in terms of highlighting errors,
auto-completion, etc etc. A big part of the JDT goodness is made
possible by the fact that your code is constantly being compiled, and
problems and messages are being fed back to you through the IDE. I know
that CFML is a dynamic and loosely typed language, but so is javascript
and you should see what the JSEclipse IDE can do with that. I know that
cf is very runtime bound (by which i mean that you need the execution
context to figure out a lot of stuff), but there's no reason that the
IDE couldn't embed a servlet container like the sysdeo tomcat plugin
does. CF already contains some code licensed under a business-friendly
Apache license, like Axis, bcel, log4j, xalan, etc etc, so something
like Tomcat would make a good match. And once you have THAT, then say
hello to interactive debugging at the touch of a button. No more hassles
with setting up remote debugging, attaching to a different jvm, etc etc.
Obviously this is not going to magically work "out of the box" for hairy
enterprise projects with all kinds of d

Hourly Digests down again?

[RADEMAKERS Tanguy]

Hello,

I haven't received an hourly digest for cf-talk since... last thursday
morning. I have verified my subscription settings on houseoffusion.com
and all seems well. Is the problem on my side? Or yours?

Regs,
/t

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248419
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: mimic a pivot table query

[RADEMAKERS Tanguy]

Hello Martin,

>select 
>   user_name,

>,

There is - move the user_name column to the end of the select list -
that way you always include a "," character...

Happy to help,
/t

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247041
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF Studio Edits Not Being Saved?

[RADEMAKERS Tanguy]

check the list archives, or check their (Zone Alarm) web site - i don't
know anything about this firsthand, just remembered that somebody else
had this problem recently.

Happy.

Googling.

/t

>-Original Message-
>Subject: CF Studio Edits Not Being Saved?
>From: Chris Montgomery
>Date: Wed, 12 Jul 2006 08:53:07 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4thr
>eadid:46748#246260
>
>RADEMAKERS Tanguy said the following on 7/12/2006 4:55 AM:
>> Last person to have this problem, it was due to a bug with firewall
>> software (Zone Alarm?) blocking a change to the file update 
>timestamp:
>> the file was changed, but since the update time wasn't changed, the
>> server didn't reload it.
>
>Hmm, that could be it. I am running ZA for my firewall. Any 
>idea where I 
>can find out more on this issue to resolve it? Thanks.
>
>-- 
>Chris Montgomery

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246264
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF Studio Edits Not Being Saved?

[RADEMAKERS Tanguy]

Last person to have this problem, it was due to a bug with firewall
software (Zone Alarm?) blocking a change to the file update timestamp:
the file was changed, but since the update time wasn't changed, the
server didn't reload it.

/t 

>-Original Message-
>Subject: CF Studio Edits Not Being Saved?
>From: Chris Montgomery
>Date: Wed, 12 Jul 2006 02:29:31 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4thr
>eadid:46748#246232
>
>This is weird. Just playing around, I installed CFEclipse, 
>edited a .cfm 
>file, reloaded it in my browser and the edits don't show up. I 
>tried it 
>again, this time editing/saving in UltraEdit, reloaded the file in my 
>browser and it shows the edits just fine! What the hey?
>
>-- 
>Chris Montgomery

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246245
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

HTML and digests

[RADEMAKERS Tanguy]

Hello,

For the past couple of days, the digests have been coming through "kinda
weird":

- angle brackets used to indicate a previous poster's text are being
translated into html entities:
"> have searched their Site and cannot find any step by step"
- links are showing up as a full html a tag:
Visit http://training.figleaf.com";
target="_blank">http://training.figleaf.com/ for more information!

Is anyone else seeing this or is the problem on my side?

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245371
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: mail server connection verification

[RADEMAKERS Tanguy]

>In the same office behind the same router on my laptop (Win XP 
>Pro with CFMX 7.01 Developer Edition), the connection verifies 
>as expected.
 
Hello Bryan,

Try to connect using telnet from both your laptop and the server - just
type "telnet [mail server ip] [mail server port - usually 25]" in the
windows command prompt. It sounds to me like there is something stopping
the connection on port 25 from the server. If the mail server is on
another network and you can connect from a laptop on your network, i'd
say it sounds like you have a firewall of some kind installed on the
server...

Regards,
/t


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245110
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: AJAX

[RADEMAKERS Tanguy]

>A really good resource for Prototype is the book "Head Rush Ajax". It 
>is, IMO, one of the best books on Ajax at the moment because it really 
>does provide the content in a distinct way that truly helps 
>you capture 
>the ideas in the book. At first I was skeptical but now I'm sold.
>
>Rey...

Sadly, i can't agree. "Head Rush Ajax" devotes one whole page (big
fonts, crazy layout) to Prototype, and only covers one of the Ajax
methods, which amounts to just a few percent of the whole API. Rumour
has it that Sitepoint (publishers of the second best js book ever: "The
Javascript Anthology") will be publishing a book completely devoted to
Prototype... now that's gonna rock. For AJAX specific books available
now, i recommend manning's "AJAX in action" and the "Pragmatic AJAX"
book. The manning book is especially interesting in that it goes way
beyond the "here's how to make an xmlHttp request" stuff and gets into
things like patterns (esp. MVC style development) and refactoring in
javascript. Not that i'm looking to develop the next google calendar or
anything, but if i ever wanted to, this book would be the one living
under my pillow.

/t



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244407
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

List address has changed?

[RADEMAKERS Tanguy]

Hello,

I am receiving the digests from the address "test@houseoffusion.com",
which means they are all dropping into my inbox... Is this the new
address for the list or will this be changed (fixed?) soon?

Regards,
/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244088
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BEA licenses BlueDragon for WebLogicr

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: BEA licenses BlueDragon for WebLogicr
>From: Thomas Chiverton <[EMAIL PROTECTED]>
>Date: Wed, 19 Apr 2006 14:55:38 +0100
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=45587&forumid=4#238080
>
>On Wednesday 19 April 2006 14:38, RADEMAKERS Tanguy wrote:
>> Number one peeve: Can't pass java objects you created 
>yourself to an EJB
>> in a different application on the same server: MX uses the 
>classloader
>
>You couldn't do that even if it was two JSP apps, if they were 
>in different 
>J2EE application contexts, could you ?

Actually, you *can* do that with a "normal" java web app - Struts, in
our case, but i guess a jsp could do it as well.

>
>> Also, there's some kind of issue with memory not being 
>released when you
>> redeploy cf - do it enough times and bang, out of memory error. Which
>
>We don't see that here- our memoray graph is fairly flat with time.
>I assume asking you if you are up to date with O/S, WL and CF 
>patches is 
>obvious ?

All up to date for CF6.1 - and, again, the problem only affects
(re)deploying the cfmx app, not other java apps on the same wl server.

>
>> Then, there's the occasional null pointer exception being thrown from
>> the middle of code you haven't touched in donkey's years. solution:
>> bounce the app or better yet, the server. Thank god that 
>only happens in
>> dev... so far.
>
>Oddness.
>Does it look like:
>Thread Stack Trace:
>at mmGetObjectSize+8()@0x40298908
>at mmGetPossibleMovedObjectSize+26()@0x40298942
>at setAsLastObj+31()@0x40292313
>at findNext+205()@0x402923f1
>at findNextToReturn+24()@0x40292430
>at refIterGetNext+40()@0x402924a0
>at trProcessRootsForThread+92()@0x40290a2c
>at tsMarkAllRootsForThread+44()@0x40307040
>at mmGenCon1ThreadInspection+30()@0x4029fc32
>at tsDoGCInspectionForAllThreads+55()@0x40306f9b
>at mmGenCon1ProcessThreadRoots+24()@0x4029fc50
>at mmGenConMark+43()@0x402a0453
>at mmConMark+48()@0x4029f7c4
>at mmGCMainEP+80()@0x4029b058 
>
>by any chance ?
>We're getting that for some reason on *one* of the dev machines.

Can't recall off the top of my head, will copy and paste the next one i
see and send it to you.

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238100
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BEA licenses BlueDragon for WebLogicr

[RADEMAKERS Tanguy]

>-Original Message-
>*Really* ?
>What's up ?

Number one peeve: Can't pass java objects you created yourself to an EJB
in a different application on the same server: MX uses the classloader
of the various objects/parameters to figure out which method to call, so
it claims that no such method exists. Solutions (in order of "banging
your head against the wallness"):
- fiddle with classloader settings in bea - only works if you want to
talk to EJB's from ONE other app... 
- have the EJB give you "blank" instances of the objects which you then
customize and return to it. You get to handle the "why do we need this
method?" questions every time you break in a new Java dev.
- Dynamic proxy (which is how we went) - works, but that's code for
nothing, since a bog standard struts application deployed right next to
the cf one can do exactly what we're trying to do, no muss, no fuss.
Much ribbing by Java devs ensues.

Also, there's some kind of issue with memory not being released when you
redeploy cf - do it enough times and bang, out of memory error. Which
means you should restart the server when you redeploy the app. Round
here, that means a weekend, which means that operations hates you for
making them work on saturdays...

Then, there's the occasional null pointer exception being thrown from
the middle of code you haven't touched in donkey's years. solution:
bounce the app or better yet, the server. Thank god that only happens in
dev... so far.

My opinion: i just don't see what *real* benefits you get from the J2EE
configuration; i'm sure that the adobe/macromedia marketing department
finds it very useful to sell into big companies on the "Enterprise"
ticket, but my suggestion would be to stick with enterprise on JRUN

just my 0.02$

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238077
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BEA licenses BlueDragon for WebLogic

[RADEMAKERS Tanguy]

>-Original Message-
>We already run MX on Weblogic. This is a supported 
>configuration and works great.

You must be luckier than us then - we run MX 6.1 in weblogic and so far,
"great" is most certainly not the word i'd use to describe it.

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238068
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Asp calling ColdFusion

[RADEMAKERS Tanguy]

>> CF can use the getPageContext.include() to 
>> cause an asp page to be processed inside the CF context.
>
>I'm pretty certain that this is incorrect.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/

As far as i know, that will only work to execute a jsp or servlet - ie
some (other) java resource running in the same web container. If someone
ever writes a java based ASP engine...

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237073
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Hourly digests down again?

[RADEMAKERS Tanguy]

Hello,

Haven't received an hourly digest since 7:12 am my time (seven hours
ago...). Are they down or has it suddenly gone deathly quiet in here?

Regs,
/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234234
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Stored Procedures and when to use them

[RADEMAKERS Tanguy]

One of the nice things about stored procedures wv. inline sql is that
your database can tell you which procs are invalidated by a change to
your schema, which can be a big time saver in development.

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233854
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Digital Signing a SOAP Request

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: Digital Signing a SOAP Request
>From: "John Wilker" <[EMAIL PROTECTED]>
>Date: Mon, 27 Feb 2006 15:48:07 -0700

>I've printed out just about every PDF Paypal has on the topic. 
>All I could
>figure out was that unless you have your own server you're SOL
>
>If you have your own, they have a Java API that works for CF 
>(I am told).
>But in a hosted environment, you're outa luck.


someone (Jim Collins) just posted a message on CFCdev about a
JavaClassLoader.cfc which is "... designed to load classes dynamically
in cases when you don't have access to the classpath or don't want to
restart ColdFusion (ie shared hosting)."

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233632
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Annoyances with cfencode

[RADEMAKERS Tanguy]

>Hmmm. So I gather that this behavior is what you see too? You 
>work around it by not asking it to do more than one file at once? 
>A bit odd that after all these years, basic functionality of this 
>tool is so broken.
>Thanks,
>
>Dave Merrill

Actually i've never used it, it was just an off the cuff remark... there
might be a way to get it to work, maybe ask the rabid guy ;)

As for these kinds of tools being broken: the silent command line
installer on Unix insists on installing a developer version, even when
you put the correct enterprise serial number in. It doesn't get fixed
because it affects such a tiny number of people - which is probably the
same thing happening here...

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232983
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Annoyances with cfencode

[RADEMAKERS Tanguy]

>No matter what I do, cfencode gives a failure alert when 
>encrypting more
>than one file at once. 

use a shell command with some kind of looping structure:

dos:
for /R %i in (*.cfm) do cfencode %i [opts]

*nix:
find . -name *.cfm -exec cfencode [opts] {} \;

/t



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232938
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT: Compiling java source code

[RADEMAKERS Tanguy]

If you're going to compile java code and you don't want to go all the
way and install some kind of IDE, then you should really really really
look into using Ant. In fact, some linux distros already come with a
version of ant installed (but since your distro shipped without a JDK i
guess that's doubtful in your case).

One of the key benefits is that your classpath settings are effectively
documented in your ant build file, which is a real time saver if you
come back to your code six months later, or if you need to get the code
compiling on some one else's machine. I read your blog entry and it
would be easy to setup a build file to compile and jar your code.

/t

>-Original Message-
>Subject: OT: Compiling java source code
>From: Rick Root <[EMAIL PROTECTED]>
>Date: Thu, 16 Feb 2006 23:16:51 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=44685&forumid=4#232676
>
>I finally got everything compiled and working.  Many issues along the 
>way were solved, and since I went through this whole process 6 months 
>ago and didn't remember a damn thing, I decided to blog about 
>it this time:
>
>Compiling Custom Event Gateways For Dummies
>http://www.rickroot.com/blog/1/2006/02/Compiling-Custom-Event-G
>ateways-For-Dummies.cfm
>
>Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232707
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX errs on Java class .isAuthenticated() method

[RADEMAKERS Tanguy]

>-Original Message-
>Folks--- How do I get around this one?  In my CFMX6.1 template 
>I instantiate userObj from a Java User class used for 
>authentication.  I want to determine if authentication was 
>successful so I use the Java class's .isAuthenticated() method 
>which fails because MX thinks I'm trying to use the old CF5.0 
>isAuthenticated() function.  Any ideas?  Thanks.--- Rob

if you have access to the java source, you can look into changing the
method name. Otherwise, you could write a little java wrapper for your
User class and then call that. Finally, you could mess about with the
java reflection APIs from within CF (in theory... YMMV)

/t

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229995
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SVN/CFEclipse question

[RADEMAKERS Tanguy]

I'm using that plugin with Eclipse 3.1.1 and CFEclipse 1.2 - works
great: much better than the one from Rational software.

/t

>Subject: SVN/CFEclipse question
>From: Angus Johnson <[EMAIL PROTECTED]>
>Date: Wed, 11 Jan 2006 10:11:11 +1000
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=44075&forumid=4#229117
>
>All you need to do is create a new CFEclipse project, name it 
>and change the
>default workspace directory to your localspace/directory. I'm 
>assuming any
>saved change in CFEclipse would be picked up by whatever logic 
>ClearCase
>uses to update.
>
>There is a plugin for ClearCase here.
>https://sourceforge.net/projects/eclipse-ccase. I haven't used 
>it so not
>sure if it current with the latest Eclipse version

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229140
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[RADEMAKERS Tanguy]

>-Original Message-
>The point is this  their PHP site, using "free" PHP took 
>two of them two
>years to do.   Multiply that out by an hourly rate, and 
>compare that to my
>building almost the same site (from a programming standpoint) 
>in 74 hours.
>Even if you add the cost of the server, mine still came out at 
>a fraction of
>the cost.

They worked non stop for two years to do what you did in 74 hours?
Assuming 8 hours per day and 200 hundred working days per year, that
adds up to 2(people) * 8(hours per day) * 2(years) *200(working days per
year) = six thousand four hundred hours! And it only took you 74 hours!

Gosh, i wonder why the whole freaking world isn't running on Coldfusion?

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227391
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

digests down again?

[RADEMAKERS Tanguy]

Hello,

Are digests down again? Haven't received anything since 7 am my time
(i'm posting this at a quarter to six pm...)

/t

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226783
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Calling Oracle Stored Procedures from CF

[RADEMAKERS Tanguy]

i tried answering this a few hours ago, but HOF seems to have eaten my
mail, so here goes again:
 
>Michael,
>
>1) Your proc is incorrect (that's what the error message is 
>complaining about). You need to fix a few things: 
>   - don't use both AS and IS in the same declaration (just AS)
>   - no output parameters (the proc needs to get something 
>back to you)
>   - the select needs to be INTO an output param (or you 
>need to OPEN a cursor variable AS this select)
>   - no semi-colon at the end of the select
>
>2) once you've fixed these, try running the proc using 
> iso 
>
>/t
>

Also, i noticed that you created this procedure in the SYSTEM schema,
which is really - really - not a good idea. You should create a separate
user/schema for your web application and only grant appropriate privs.
If somebody can carry out a sql injection attack against your SYSTEM
schema...


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226583
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Calling Oracle Stored Procedures from CF

[RADEMAKERS Tanguy]

>I am having troubles getting even basic Oracle sp's to call 
>from my coldfusion pages.
>
>Heres the procedure:
>
>CREATE OR REPLACE PROCEDURE selRandomQuestionIDs() AS
>IS
>BEGIN
>SELECT quizQuestionID, RANDOM_ORDER 
>FROM random_number
>WHERE rownum <= 20
>END;
>
>Heres the call:
>
>
>BEGIN selRandomQuestionIDs(); END;
>
>
>The error being returned is as follows:
>
>[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, 
>column 7: PLS-00905: object SYSTEM.SELRANDOMQUESTIONIDS is 
>invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Michael,

1) Your proc is incorrect (that's what the error message is complaining
about). You need to fix a few things: 
- don't use both AS and IS in the same declaration (just AS)
- no output prameters (the proc needs to get something back to
you)
- the select needs to be INTO an output param (or you need to
OPEN a cursor variable AS this select)
- no semi-colon at the end of the select

2) once you've fixed these, try running the proc using 
iso 

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226581
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: MX7 CFHTTP : connection failure with Proxy

[RADEMAKERS Tanguy]

Hello Yves,

1) Just thinking out loud, but are you sure that you can connect to the
proxy url (http://myproxy/cgi-bin/mro/perlFile.pl, in your example) from
the ColdFusion MX7 server? Have you tried using cfexec to ping the proxy
from within a cf page? Have you tried using cfexec and wget to see if
you can get the url via http? This will eliminate the possibility of a
lower level (network) snafu causing problems.

2) have you tried using the various proxy* attributes of the cfhttp tag?
In this scenario, you would have a tag that looked more like :

http://cgiserver/cgi-bin/mro/perlFile.pl";
proxyServer="myproxy" result="strXMLFile">


http://cfmServer/cfmFile.cfm";>

  
   
 

  


 with maybe some other attributes like proxyPort, proxyUser, etc.
defined.


/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226069
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL

[RADEMAKERS Tanguy]

1) given that you have to list all the columns in your "create temporary
table as select..." statement, you might as well just do

"insert into customers (select myNewID, pkCUST, CUST_Fname, CUST_LName,
CUST_ZIPCode from customers where pkCUST = 37);"

2) "myNewID" is most probably a sequence, so it should be something like
"myNewID.nextval"

3) no, you cannot just use * to get all the columns, because then you'd
get the existing ID as well, which you don't want.

Regards,
/t

>-Original Message-
>Subject: SQL
>From: "Cornillon, Matthieu \(Consultant\)" 
><[EMAIL PROTECTED]>
>Date: Mon, 28 Nov 2005 13:54:54 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=43478&forumid=4#225445
>
>> Thanks for that, but is there a way to copy a whole row...
>
>This is a snippet of code that a friend here at work sent me for
>creating a whole new row from a whole old row all within SQL.  It is
>Oracle-based, and I have never used it myself, but I am pretty 
>sure that
>it does what you want.
>
>Say you have CUSTOMERS
>pkCUST
>CUST_FName
>CUST_LName
>CUST_ZIPCode
>
>and you want to copy the row with pkCUST=37 into a new row of the
>same table.  Then just use this sequence of SQL statements:
>
>CREATE TEMPORARY TABLE t SELECT myNewID  AS
>pkCUST, CUST_Fname AS CUST_Fname, CUST_LName AS CUST_LName, 
>CUST_ZIPCode
>AS CUST_ZIPCode
>FROM CUSTOMERS
>WHERE pkCUST = 37;
>
>INSERT INTO CUSTOMERS
>SELECT * 
>FROM t;
>
>DROP TABLE t;
>
>As I said, I have never used temporary tables, but I wish I had learned
>about them long ago.  I think they are perfect for this sort of thing.
>I am not sure that in the first statement you need the ColName AS
>ColName statements; you might be able to just say * to get a 
>copy of all
>existing rows, but you'd have to test it.
>
>Hope this helps,
>Matthieu

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

hourly digests down?

[RADEMAKERS Tanguy]

Hello,

I haven't received an hourly digest since 4.01 am my time (almost twelve
hours ago). Are they down or is the problem on my side?

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224792
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: and application.cfm

[RADEMAKERS Tanguy]

>Anyone have a way that I can enable the custom prefix of a tag library
>within every page of my site, including includes?

find . -name "*.cfm" | xargs grep -L "" | xargs sed -i.bak -e "1i"

Execute from the root of your cf site. 

Will add "" as the first line
of every cfm file that doesn't already contain it (*after* making a
backup of the file - foo.cfm -> foo.cfm.bak)

Requires several of the gnuwin32 utils from sourceforge:
find
xargs
grep
sed

all hail the power of the command line.

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224512
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Form: user not going back

[RADEMAKERS Tanguy]

>What is a standard way of preventing the user from accessing a 
>form just submitted? I inserted a page with a "redirect" code 
>between my action page and my thank you page, but when I hit 
>the "Back" button, both the "refresh" and the action pages are 
>bypassed and the form (with completed fields) is accessed.

Put this in your form page:



/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224217
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

silent install problems: CFMX7 enterprise on Solaris

[RADEMAKERS Tanguy]

Hello,

I am trying to perform a silent installation on Solaris, and i keep
winding up with the developer version, not the enterprise version. I
have checked that i am using a valid enterprise serial number (if i
enter this in the admin after installation and deployment it works just
fine, if i run the installer in interactive mode it also works just
fine). I deploy CFMX as a j2ee app in weblogic (8.1)

my installer.properties file:
# Install is silent
INSTALLER_UI=SILENT
#
# License information - full | trial | developer
SILENT_LICENSE_MODE=full
SILENT_SERIAL_NUMBER=[**my cfmx serial**]
SILENT_PREV_SERIAL_NUMBER=
#
# Configuration - standalone | jrun | ear | war
SILENT_INSTALLER_TYPE=war
#
# Components to install
SILENT_INSTALL_ODBC=false
SILENT_INSTALL_VERITY=false
SILENT_INSTALL_SAMPLES=false
# (UNIX only) whether to start CFMX7 when booting
SILENT_CONFIGURE_SYSTEM_INIT=false
#
# Directories
SILENT_INSTALL_FOLDER=/opt/coldfusionmx7
# EAR/WAR only
SILENT_VERITY_INSTALL_FOLDER=
#
# Context root
SILENT_CONTEXT_ROOT=hsmc
#
# Runtime user for UNIX
SILENT_RUNTIME_USER=
#
# ColdFusion administrator password
SILENT_ADMIN_PASSWORD=[**my cfadmin password **]
#
# Flash forms - EAR/WAR only
SILENT_FLEX_ENABLED=true
#
# Enable RDS and password
SILENT_ENABLE_RDS=false
SILENT_RDS_PASSWORD=

after installation, the log file
/opt/coldfusionmx7/Macromedia_ColdFusion_MX_7_InstallLog.log says:

Summary
---

Installation: Successful.

95 SUCCESSES
0 WARNINGS
0 NONFATAL ERRORS
0 FATAL ERRORS

 and then a whole long list of info...

when i deploy the app in weblogic and access the administrator, i see:

Server Details
Server ProductColdFusion MX
Version   7,0,0,91690  
Edition   Developer  
Serial Number Developer  
Operating System  UNIX  
OS Version5.8

any thoughts?

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220346
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

hourly digests down?

[RADEMAKERS Tanguy]

Hello,

I haven't received any hourly digests since tem pm my time last night
(CET). Is there a problem or is something wrong on my side?

/t

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220109
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Content-Type

[RADEMAKERS Tanguy]

IIRC, you need to look into the "content-disposition" header, iso the
"content-type" one



/t



>-Original Message-
>Subject: Content-Type
>From: Matt Robertson <[EMAIL PROTECTED]>
>Date: Tue, 4 Oct 2005 12:19:48 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42580&forumid=4#220053
>
>Assuming you save the file somewhere yourself on your server, there
>used to be a way to do this but its no longer reliable.
>
>You push the file to the client with cfcontent, set the mime type to
>application/unknown and set the type to 'attachment'.  In the olden
>days before security tightened up this would give you a save dialog no
>matter what.  I would be real careful about any attempt to delete it
>immediately afterwards as you'll probably delete a file still in
>transmission to the client.
>
>IIRC default Windows firewall settings now prohibit acceptance of
>application/unknown MIME types like this.
>
>--
>--mattRobertson--
>Janitor, MSB Web Systems
>mysecretbase.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220069
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Questions regarding using CFMX7 with EJBs

[RADEMAKERS Tanguy]

Hello List,

I'm running into a problem using CFMX7 enterprise on weblogic to call an
EJB deployed in the same instance of weblogic (so it's running in the
same JVM), but in a different application (so it's loaded by a different
classloader). The basic problem is that i can't pass objects that i
create in CF to the EJB - the call fails with a NoSuchMethodError
because (i'm speculating here) the object that i'm passing was loaded
with a different classloader than the one "expected" on the other side
(If the EJB is deployed in a different instance of weblogic, then
everything works as advertised, but that's not an option for me.
Likewise if the EJB is deployed in the same app as cf.).

So far, i'm getting around this by having the EJB give me empty
instances of the objects in question, which i then populate with data
and return to the EJB, but this has the nasty side effect of adding all
kinds of getX() methods to the java API, which i have to "share" with
java developers writing "regular" java web apps (which have no problem
whatsoever doing what i'm trying to do). I've looked into creating a
pojo business delegate (a simple object that sits between cfmx and the
ejb in question, and handles things like lookups) but i'm running into
the same problems - i can look up an EJB but i can't pass objects i
created to it.

Has anybody here achieved what i'm trying to do? Any pointers or hints,
even just "it worked fine for us", would be much appreciated.

Thanks for your time,
/t

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219344
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT: hit tracking service

[RADEMAKERS Tanguy]

>DeepMetrix has all the eye candy anyone could need... it's 
>exactly what you
>want.
>
>Kevin

Thank you Kevin, that does look rather promising.

/t

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219222
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: hit tracking service

[RADEMAKERS Tanguy]

Hello,

My company is looking for some form of hit tracking service - something
that would allow us to "tag" pages with an identifier and then consult
reports of visits, visitors, etc by tag. Basically something like those
annoying hit counters, but more professionally done and with the ability
to tag any number of pages on an ad-hoc basis. We already have log
analysis software, we're looking for something easier to use from the
point of view of the content publishers (who are not capable of writing
webtrends reports). The idea is that we would provide them with a simple
cf custom tag that implements the page tracking tag, which they could
implement wherever they want (passing in params like the logical tag
name they want the page(s) to be tracked under). We've looked at
solutions from Coremetrics and Websidestory that can do this kind of
thing, but they are much to powerful for our needs (we do about a
million pageviews a month, these guys start at five million) and would
take a major effort to put into place. 

Our one big requirement is that this should be available as a service -
zero software installation on our site.

Has anybody here used or heard of such a service?

Regs,
/t


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219067
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

" Element FILTERS is undefined in STCURRENTSEARCH" when trying to view log files in CFMX7 admin

[RADEMAKERS Tanguy]

Hello,

I'm trying to view the mailsent.log file in my cfadmin (Debugging &
Logging -> Log Files -> mailsent.log).

That works just fine, but there are two checkboxes above the log output:
"View Raw Data" and "Compact View". Checking either of these gives me an
error message "Element FILTERS is undefined in STCURRENTSEARCH." Even
weirder, it reports that this error occurred in
"C:\blackstone_final\cfusion\wwwroot\CFIDE\administrator\logviewer\_sear
chloglogic.cfm: line 52" - and i'm running on Unix?

My server info is:
Server ProductColdFusion MX
Version   7,0,0,91690
Edition   Enterprise (Trial)
Serial Number
Operating System  UNIX
OS Version5.8 
Update Level
/home/web/cfmx7/cfusion-war/WEB-INF/cfusion/lib/updates/chf73.jar

anybody else see this error?

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: form validation utilizing database field types/sizes/etc

[RADEMAKERS Tanguy]

apologies for the redundancy - hourly digests...

so, euh, yeah: ME TOO!!

/t

>-Original Message-
>Subject: form validation utilizing database field types/sizes/etc
>From: "RADEMAKERS Tanguy" <[EMAIL PROTECTED]>
>Date: Wed, 14 Sep 2005 19:16:44 +0200
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42228&forumid=4#218262
>
>>I was wondering if there is a way to pull column information 
>>from oracle to help with form validation.  It would be really 
>>nice if I could set up my database and then have coldfusion  
>>read the setup of my tables and perform its form validation 
>>based on that.
>
>Oracle stores this kind of info in pseudo tables called the data
>dictionary. A db user can get data abut "his" objects in tables like
>user_tables, user_tab_columns, user_constraints, etc. If you have the
>appropriate privs, you can also check all_tables, etc for any user's
>objects. 
>
> but i would have to go with Jim's suggestion to use jdbc - more
>reusable across different db platforms. The data dictionary contains
>wy more info, but it's not stuff you need for form validation code.
>
>/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218264
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: form validation utilizing database field types/sizes/etc

[RADEMAKERS Tanguy]

>I was wondering if there is a way to pull column information 
>from oracle to help with form validation.  It would be really 
>nice if I could set up my database and then have coldfusion  
>read the setup of my tables and perform its form validation 
>based on that.

Oracle stores this kind of info in pseudo tables called the data
dictionary. A db user can get data abut "his" objects in tables like
user_tables, user_tab_columns, user_constraints, etc. If you have the
appropriate privs, you can also check all_tables, etc for any user's
objects. 

 but i would have to go with Jim's suggestion to use jdbc - more
reusable across different db platforms. The data dictionary contains
wy more info, but it's not stuff you need for form validation code.

/t


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218262
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest almost every hour

[RADEMAKERS Tanguy]

Hello,

Are hourly digests down? Don't seem to be getting any from the list this
afernoon...

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX6.1 on WebLogic 7, weird web services call error

[RADEMAKERS Tanguy]

Sorry, don't have desktop internet access (don't ask). We run wl8 here
and i just remember a chat i once had with one of the java guys about
how ws calls were restricted in the dev version above and beyond the
five ip rule... On the one hand, makes some kind of sense, since you
could stick your dev version behind a reverse proxy and bob's your
uncle. On the other hand... hearsay is one of the biggest time wasters
in this business. Note that i am specifically talking about a
restriction on ws calls - i do know for sure that the dev version (of
wl8 at least) is restricted to 5 distinct IPs.

I'd say do a controlled experiment: call your web services one by one in
order and check how many calls you can do before the system locks up.
Repeat in the same order and see if it always locks up at the same
point. Then change the order and see if you get a lockup after the same
number of calls but on another ws...

Of course *cough* an unscrupulous fellow would tell you to slap a
euh... *spare*... license number on your dev server and repeat the
experiment... just for the sake of curiosity.

/t

>-Original Message-
>Subject: CFMX6.1 on WebLogic 7, weird web services call error
>From: Thomas Chiverton <[EMAIL PROTECTED]>
>Date: Fri, 9 Sep 2005 10:03:45 +0100
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42115&forumid=4#217730
>
>On Thursday 08 September 2005 17:13, RADEMAKERS Tanguy wrote:
>> Tom,
>>
>> I think you might be running into a limitation of the development
>> version. Don't know about v7, but on v8 it's restricted to x 
>number of
>> IP addresses after which it refuses connections. I think for ws calls
>> there's a furthur restriction on number of subsequent calls 
>or something
>
>I can't find any information on this on BEA's site, don't 
>suppose you have a 
>reference at all ?
>
>FWIW our other dev. system (also running an eval/dev licence) 
>also has the 
>same problem - our live system has a proper licence, so you 
>might be on to 
>something.
>
>-- 
>
>Tom Chiverton 
>Advanced ColdFusion Programmer
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217735
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX6.1 on WebLogic 7, weird web services call error

[RADEMAKERS Tanguy]

Tom,

I think you might be running into a limitation of the development
version. Don't know about v7, but on v8 it's restricted to x number of
IP addresses after which it refuses connections. I think for ws calls
there's a furthur restriction on number of subsequent calls or something
- consult the docco on bea's web site. Do you by any chance have a fully
licensed server available for testing that you could afford to restart? 

/t 

>-Original Message-
>Subject: CFMX6.1 on WebLogic 7, weird web services call error
>From: Thomas Chiverton <[EMAIL PROTECTED]>
>Date: Thu, 8 Sep 2005 16:50:55 +0100
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42115&forumid=4#217631
>
>On Thursday 08 September 2005 16:11, RADEMAKERS Tanguy wrote:
>> Is this on a development (unlicensed) copy of weblogic server?
>
>Dev, yeah. Development != unlicensed though.
>I haven't entered a serial number into it, if that is what you mean.
>
>-- 
>
>Tom Chiverton 
>Advanced ColdFusion Programmer

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217632
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX6.1 on WebLogic 7, weird web services call error

[RADEMAKERS Tanguy]

Hello Tom,

Is this on a development (unlicensed) copy of weblogic server?

/t 

>-Original Message-
>Subject: CFMX6.1 on WebLogic 7, weird web services call error 
>(java.security.PrivilegedActionException)
>From: Thomas Chiverton <[EMAIL PROTECTED]>
>Date: Thu, 8 Sep 2005 15:23:01 +0100
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42114&forumid=4#217612
>
>We're having a weird issue with CF throwing a 
>"java.security.PrivilegedActionException: null" error when invoking a 
>webservice (for the first and subsequent times).
>Thing is, it doesn't matter what order I invoke the 3 or 4 
>different web 
>service calls in (they are in different pages on the site, 
>with different 
>WSDL URLs). The first few will be fine, and then one will go 
>pop. It will 
>then continue to fail with the same error until the server is 
>rebooted. At 
>that point I can go back to that broken service, and run it 
>again fine. One 
>or two of the others will be fine, but then one will blow up, 
>and the loop 
>repeats.
>
>The only think google has for the exception is not having the 
>java.security.AllPermission set in weblogic.policy, so I've 
>added that, to no 
>avail.
>
>Has anyone ever seen this before, because it's very very 
>irritating. It's not 
>happening in production yet, but I'm sure it will one day.
>
>I believe the file not found error in the CF stack dump is 
>caused by the 
>errors in the WebLogic stack dump, the file is really not 
>there, though 
>others (.java) are - looks like the Axis compile is falling over or 
>something.
>
>Below are full CF and WL stack dumps, with the part of the 
>path to the web / 
>CFC root replaced with '...'

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217624
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

anyone here from "nmha.org"?

[RADEMAKERS Tanguy]

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, September 01, 2005 9:18 PM
>To: RADEMAKERS Tanguy
>Subject: Symantec Mail Security detected prohibited content in 
>a message sent from your address (SYM:02178018114101170846)
>
>Subject of the message: RE: Full server/database/schema/table 
>name syntax for Oracle.
>Recipient of the message: "CF-Talk" 
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217137
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Full server/database/schema/table name syntax for Oracle.

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: Full server/database/schema/table name syntax for Oracle.
>From: "Ian Skinner" <[EMAIL PROTECTED]>
>Date: Thu, 1 Sep 2005 09:51:56 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42032&forumid=4#217099
>
>I am in an position where I have to join data from tables in 
>different databases on different servers.  I seem to recall 
>that this maybe possible (if highly undesirable) by expanding 
>the syntax of the table name.  How does that look?

don't know about the server/database part, but here's how i do it:

1) you have to establish a database link between the two dbs in
question. A dblink has a name.

2) your syntax is then [EMAIL PROTECTED]

like this:

select * FROM [EMAIL PROTECTED]

you will want to use synonyms to make this easier.

you should know that you need privs on both the dblink and the table on
the other side. By default, when you don't have enough privs, oracle
tells you that the object doesn't exist. This can get very
frustrating.

Read the section "Database Links" in "Distributed Database Concepts" in
the Administrators Guide for info.

/t


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217104
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: [SOT] Finding which files in a site aren't used anymore

[RADEMAKERS Tanguy]

the first obvious "gotcha" i can see here is including files
dynamically:



 

other than that, i don't know of any tools, but i did once see a perl
script that searched out unused images... would need extensive hacking,
but should be findable using a quality search engine.

Another approach might be to log every file, let your site run for a
while (possibly spidering it or some other heavy use scenario) and then
compare the list of logged files with the list of all files. I wouldn't
just delete the difference but it could give you a place to start...

/t


>-Original Message-
>Subject: [SOT] Finding which files in a site aren't used anymore
>From: Anthony Prato <[EMAIL PROTECTED]>
>Date: Wed, 31 Aug 2005 12:37:59 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=42023&forumid=4#217045
>
>I'm back to a problem that I run into a lot. I started working at a
>place that does not do a good job of cleaning up files in a websites
>directory. (as well as tons of unused stored procedures and views)
>I've found plenty of tools to track down database objects, even some
>that check your files for calls to the DB objects; I just can't find
>anything for cleaning up the files. I know I can get a list of all the
>files in all sub directories and grep for each, but I'm hoping someone
>can recommend me a nicer GUI utility instead. Another nice feature
>would be smarter than grep and if file A calls file B but nothing
>calls file A then they are both obsolete. Does anyone know of a
>utility like this. In the past I've used grep or similar but in this
>case there are just too many files.
>
>Anthony

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217058
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using JavaMail to send/fetch emails via SSL

[RADEMAKERS Tanguy]

Hello Hua,

Have you tried using JavaMail to fetch email from a different (non
gmail) ssl mail server?  I.E. is the problem gmail specific? BTW: your
debug output ("DEBUG POP3: connecting to host "pop.gmail.com", port 995,
isSSL false") seems to indicate that you are *not* connecting over
SSL...

You might be interested in checking out the Gmail 4 Java api (available
at http://g4j.sourceforge.net/) - at the very least i'm sure you will
find some knowledgeable people on their lists/forums/etc.

Regs,
/t

>-Original Message-
>Subject: Using JavaMail to send/fetch emails via SSL
>From: "Hua Wei" <[EMAIL PROTECTED]>
>Date: Tue, 30 Aug 2005 10:05:45 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41987&forumid=4#216758
>
>Hello All,
>Anyone using JavaMail and coldfusion together to send/fetch 
>emails via SSL?
>
>I tried gmail, but got time out errors. Increased the time 
>limit, but didn't help. 
>non-ssl emails work fine.
>
>Any suggestions? Thanks in advance
>
>Hua
>
>JavaMail version: 1.3.2
>System: CFMX 7 enterprise on windows 2000
>
> code 
>
>
>  username = "[username]";
>  password = "[password]";
>  debug = true;
>
>  POP_HOST_NAME = "pop.gmail.com";
>  POP_PORT = "995"; //995 for gmail
>  SSL_FACTORY = "javax.net.ssl.SSLSocketFactory";
>  
>  prop = createObject("Java", "java.util.Properties").init();
>  prop.setProperty("javax.mail.pop3.starttls.enable", "true");
>  prop.setProperty("javax.mail.pop3.socketFactory.class", SSL_FACTORY);
>  prop.setProperty("javax.mail.pop3.socketFactory.fallback", "false");
>  prop.setProperty("javax.mail.pop3.port", POP_PORT);
>  prop.setProperty("javax.mail.pop3.socketFactory.port", POP_PORT);
>  
>  urlName = createObject("Java", "javax.mail.URLName");
>  urlName.init("pop3",POP_HOST_NAME,POP_PORT,JavaCast("null", 
>""),username,password);
>  
>  mySession = createObject("java", 
>"javax.mail.Session").getInstance(prop);
>  mySession.setDebug(debug);
>  
>  store = mySession.getStore(urlName);
>  
>  // connect to mailbox
>   store.connect();
> inbox = store.getFolder("INBOX");
> inbox.open(inbox.READ_ONLY);
>  
> messages = inbox.getMessages();
>  store.close(); 
>
>=
>=== fetching debug output ===
>DEBUG: setDebug: JavaMail version 1.3.2
>DEBUG: getProvider() returning 
>javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun 
>Microsy stems, Inc]
>DEBUG POP3: connecting to host "pop.gmail.com", port 995, isSSL false
>S: EOF
>08/30 09:43:11 Warning [jrpp-2] - Thread: jrpp-2, processing 
>template: D:\HTDOCS\webroot\test_gmailget.cfm, completed in 60 
>seconds, exceeding the 60 second warning limit
>C: QUIT
>S: EOF
>=

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216813
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Count Question...

[RADEMAKERS Tanguy]

I don't know about sql server specifically, but you could try syntax
like

select count(distinct(mycolumn)) from mytable

or else you should be able to do

select count(*) from (select distinct(mycolumn) from mytable)

/t

>-Original Message-
>Subject: SQL Count Question...
>From: <[EMAIL PROTECTED]>
>Date: Fri, 26 Aug 2005 07:16:33 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41929&forumid=4#216470
>
>I don't think you can use DISTINCT with an aggregate function 
>like count().  Also, you didn't indicate anywhere in this 
>e-mail which database server you're using.  
>
>Are you doing the query just to get the count, or is it for 
>some other purpose as well.  There's nothing wrong with using 
>#queryname.recordcount#.  You could do the count() without the 
>DISTINCT, but that may give you more than you are looking for.  
>
>Maybe you could tell us the goal you're trying to accomplish 
>and there might be another way to approach it.  Be sure to 
>include your SQL database type and version.  Also, providing 
>your error message is very helpful.
>
>Dave
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216494
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

hourly digests down?

[RADEMAKERS Tanguy]

 or has nobody said anything since 11 am this morning (my time)?

it's... so... quiet...

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216349
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get fields in an Access table

[RADEMAKERS Tanguy]

you can get the column names by querying the table and then looking at
yourqueryname.columnList, but i don't know how you can get datatypes...

there was an article a way back in CFDJ ("leveraging JDBC or just
fetching coffee?") that talked about using the underlying JDBC api from
cf, but they mentioned that access has some limitations in terms of jdbc
support...

good luck!

/t 

>-Original Message-
>Subject: Get fields in an Access table
>From: Steve Bryant <[EMAIL PROTECTED]>
>Date: Wed, 24 Aug 2005 11:39:39 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41882&forumid=4#216184
>
>Does anyone know a way to get the all fields (and datatypes) 
>from a table in MS Access using ColdFusion?
>
>Thanks!
>
>Steve Bryant
>Bryant Web Consulting LLC
>http://www.BryantWebConsulting.com/
>http://steve.coldfusionjournal.com/

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216188
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: creating war ear files programatically

[RADEMAKERS Tanguy]

Hello,

WAR/EAR files are "just" zip archives with special layout (like the have
a META-INF directory with some xml files, etc).

I'd suggest dissecting an existing one and then trial... and error...
and trial... ;)

best of luck!

/t

>-Original Message-
>Subject: creating war ear files programatically
>From: Simon Smith <[EMAIL PROTECTED]>
>Date: Tue, 23 Aug 2005 05:29:33 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41851&forumid=4#216014
>
>Hi all, 
>
>Is it possilbe to createa a war / ear file using coldfusion ? 
>I'd like an application to create a "back up" of itself before 
>updates ?  
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216016
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: webservices and XML

[RADEMAKERS Tanguy]

 
If you are creating and consuming these web services from CF, then it
probably "magically" turns the query xml back into a CF query. 

Have you tried accessing this web service with a non-CF technology? 

/t

>-Original Message-
>Subject: webservices and XML
>From: "Bryan Stevenson" <[EMAIL PROTECTED]>
>Date: Mon, 22 Aug 2005 10:54:12 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41839&forumid=4#215919
>
>OKnobody is getting my point :-(
>
>Can anybody confirm this statement about CF generated 
>webservice output in 
>Livedocs and explain it (ignore the output attribute portion):
>
>The output attribute of the cffunction tag must be set to No because 
>ColdFusion converts all output to XML to return it to the consumer.
>
>So far in my testing I DO NOT GET XML returned from web 
>servicesI do get 
>whatever the returntype says I'll get IF I return that type of 
>data...I AM 
>NOT SEEING ANY CONVERSION TO XML
>
>TIA
>
>Cheers
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.com 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: WDDX Replacement Attempt - Take a Look!

[RADEMAKERS Tanguy]

>I think I've hit upon an appropriate name... get ready... here 
>it comes...
>
>YODEL
>
>It stand for "Yet another Open Data Exchange Language".  Also 
>Yodeling began
>as a method for passing messaged from mountain peak to 
>mountain peak using
>only simple modulations of voice... all told it seems appropriate.
>
>What do you guys think?

Jim, that's a *brilliant* name for such a technology. Seriously.

/t

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215743
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Cfhttp vs web services

[RADEMAKERS Tanguy]

Russ,

You have to compare apples with apples: not all web services work the
same way. CFMX web services built using cfcomponents with
access="remote" are "heavy duty" web services that use SOAP to pass
messages, publish a WSDL file to document their interface and check
things like parameter datatypes. All this stuff is a pain to do by hand,
but once again cf comes to the rescue and makes something complex very
easy for 80+% of cases. If your developer had had to do all these things
by hand in CF5 then the answer to "what do you gain" would most probably
be "time". 

Having said that, there's a lot of discussion out there about how SOAP
based web services may well be overly complex for most simple uses -
especially in cases like yours where you are both the publisher and the
consumer of a web service, or in cases when you have a small number of
simple in parameters. Now if you were publishing a web service that had
to be consumed by another team (maybe even in another time zone) using a
different technology, then SOAP based web services have one great
advantage - tool support. Turn the problem on its head: if you had to
consume a web service produced by somebody else, would you rather use
cfhttp then some kind of parsing on the result, or just use a single
cfinvoke tag? The ability to do the second depends on SOAP based web
services...

just my 0.02$

/t

>-Original Message-
>Subject: Cfhttp vs web services
>From: "Russ Michaels" <[EMAIL PROTECTED]>
>Date: Wed, 10 Aug 2005 10:15:07 +0100
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41634&forumid=4#214306
>
>I recently  had an interesting question from  one of our 
>developers that I
>had a hard time answering.
>
>Had had an app that required web services, but it was written 
>in CF5, so
>rather than move to CFMX, he just wrote a bunch of pages that 
>could have
>forms posted to them, with the commands in the form fields. 
>Then accessed
>this from elsewhere using CFHTTP.
>
>He then said, what is the difference between doing this and using web
>services, what would the web services allow him to do that he 
>had not done
>with this solution. And to be honest I really can't think of a 
>good reason
>why he should have used CFMX web services instead, as this 
>does produce the
>same result and can be used form any of the other platforms. 
>Whereas if we
>had used a CFMX web service, I know we likley would have had 
>problems with
>SOAP requests.
>
>russ

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[RADEMAKERS Tanguy]

Hello,

I'll second Barney's post with a big +1. For simple data passing, you
don't even need to use XML, let alone SOAP based web services - you can
get simple text strings and inject them directly in your layout. Google
XHConn for a nice little(43 lines) .js file that wraps the
XMLHttpRequest object (or MS equivalent) and will have you
getting/posting from your page in minutes. I guess you'd want to look
into a more complete framework (like CFAjax) for real work, but this
will get you up and tinkering in minutes (no need to create server
mappings, etc)

After all the brouhaha over AJAX in the last few months, the biggest
surprise for me was how simple it was.

/t


>-Original Message-
>Subject: Architecture thoughts
>From: Barney Boisvert <[EMAIL PROTECTED]>
>Date: Tue, 9 Aug 2005 09:20:15 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41599&forumid=4#214193
>
>I rarely use web services, instead preferring to just use GET and POST
>operations.  The XmlHttpRequest object was designed for fetching
>remote XML, but it's really nothing more than an HttpRequest object,
>and can be used as such.  There's some XML-related stuff, but at the
>core is just simple HTTP.
>
>If you're doing complex data passing, web services are very helpful,
>particularly the ability to have multiple typed parameters and complex
>data that is automatically marshalled/unmarshalled for you, but for
>simpler stuff, GET and POST are more than adequate.  Web services also
>have a fairly high spin-up cost for parsing the WSDL and making the
>stubs and stuff.  Not a big deal if you have a single page UI that
>does everything dynamically, but if you're still switching pages and
>just doing dynamic things within those pages, that cost can be
>prohibitive.
>
>Since GET/POST don't require any of that, they don't have any
>initialization cost except making an HTTP connection (something
>browsers are good at), and are therefore ridiculously fast.
>
>cheers,
>barneyb
>
>On 8/9/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
>> I thought AJAX apps generally used webservices to fetch their data...
>> isn't that the reason they use the XmlHttpRequest object? (and the
>> reason why X ended up in the acronym).
>> 
>> 
>> s. isaac dealey 954.522.6080
>> new epoch : isn't it time for a change?
>
>
>-- 
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/
>
>Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214215
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: clearing connection pool/expiring connections

[RADEMAKERS Tanguy]

It must be possible because you can do it in the admin ("Disable
Connections" checkbox in the datasource advanced settings page. All this
stuff is accessible from the undocumented
"coldfusion.server.ServiceFactory" object... which contains a
DataSourceService object... which declares a disableConnection()
method... but no idea how to use it.


maybe check something like the ontap framework for clues? 

best of luck!


>-Original Message-
>Subject: clearing connection pool/expiring connections
>From: frederick valone <[EMAIL PROTECTED]>
>Date: Wed, 13 Jul 2005 10:06:43 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41145&forumid=4#211739
>
>I am wondering if there is a way to programaitcally expire connections 
>between coldfusion and oracle.
>
>We currently have to "bounce" our cf server everytime we take 
>one of our 
>"linked" databases down for service or make changes made to stored 
>procedures or cf "sees" the state of the database as it was before the 
>changes were made.
>
>We are running cfmx6.1 for j2ee on jrun.
>Our operating environment is Sun Solaris.
>Oracle 9i DB
>Web server is Apache 2.
>
>Any help will be greatly appreciated

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211749
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: retrieve ID from db insert

[RADEMAKERS Tanguy]

Two other good resources:

http://www.jlcomp.demon.co.uk/
Jonathan Lewis' site -check out the oracle FAQs

http://www.psoug.org/reference
which has some great examples for more advanced db features

and, of course, the oracle docco, esp. the Concepts guide,
Application Developer's Guide - Fundamentals, and the various reference
guides to SQL, PL/SQL and (for when things go wrong) Error Messages. 
 

>-Original Message-
>Subject: retrieve ID from db insert
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Wed, 13 Jul 2005 06:09:37 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41103&forumid=4#211728
>
>I forgot to mention I have used their Ask Tom a few times and 
>with good 
>success. I usually end up finding something similar to my 
>needs in there and 
>try to apply it and if I get stumped then post to it, not sure 
>if I have 
>ever done a new thread in Ask Tom.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211731
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: retrieve ID from db insert

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: retrieve ID from db insert
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Tue, 12 Jul 2005 14:40:27 -0500

[snip]

> I often wonder how many CFM developers that work with Oracle use and 
>understand all the features that all that money was spent on. And if
they do 
>not understand the features well enough, what could have been intended
to 
>make their life/jobs easier could quickly make it harder but that is
just 
>part of life and anything out there.

It's not restricted to CFM developers - if anything, web developers are
more likely to be comfortable with a greater number of different
technologies than their mainstream counterparts. A lot of them
high-falutin' object cowboys are downright afraid of databases. Then
again, if i wrote SQL like that i would be too ;> 

And it's not restricted to Oracle - there are doubtless plenty of people
out there using SQLServer as if it was a big excel spreadsheet.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211688
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: retrieve ID from db insert

[RADEMAKERS Tanguy]

As i see it, the benefit of this approach is that it will be more
portable across different databases (as long as they understand
transactions). The down side is that if you want this to work you will
have to use  - "repeatable_read"
won't cut it if another transaction has finished in the mean time.
Unfortunately, some other products implement this level of isolation by
locking the whole table - which means that only one thread at a time
will be able to insert into this table. 

My advice: oracle cost a lot of money, so get your money's worth: use
oracle specific features when they make your life easier. It's what
they're for.


>-Original Message-
Subject: retrieve ID from db insert
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Tue, 12 Jul 2005 11:10:05 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41103&forumid=4#211639
>
>We appear to just be going around in circles on this one. If 
>you have a 
>query that selects the sequence next value then you do not need a 
>CFTRANSACTION but you do have to remember to always select the 
>next value 
>since I'd assume this uses no trigger to handle it on any 
>other inserts? 
>What do you do for mass inserts from another table, guess just 
>a little 
>addition to the SQL and really no biggie on that one.
> Or you take the approach of never inserting anything manually 
>into the "ID" 
>column and just little a trigger/sequence handle it. That means using 
>CFTRANSACTION so that after you insert it you do the SELECT 
>MAX(ID) AS NEWID 
> Since there seems to be no adverse reason to using 
>CFTRANSACTION unless 
>in some of the already noted situations which seem more out of 
>the norm than 
>the norm, then this method just to me seems like an easier approach.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211666
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

FW: CF-Talk: Digest every hour

[RADEMAKERS Tanguy]

 first ooops:

> RETURNING ID
>  INTO newid;

should be

> RETURNING GI_ID
>  INTO newid;

(obviously)

/t

>-Original Message-
>From: RADEMAKERS Tanguy 
>Sent: Monday, July 11, 2005 5:19 PM
>To: 'cf-talk@houseoffusion.com'
>Subject: RE: CF-Talk: Digest every hour
>
>Hello,
>
>1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to 
>insert and one to get the value of the new ID.
>
>2) Write a stored procedure that returns the value of the 
>inserted id (see the SQL guide for the syntax of RETURNING INTO clause)
>
>start with this:
>
>CREATE OR REPLACE PROCEDURE insert_game (
>   fsnep_login  IN   VARCHAR2,
>   g_list   IN   VARCHAR2,
>   budget   IN   VARCHAR2,
>   the_monthIN   VARCHAR2,
>   the_num_people   IN   VARCHAR2,
>   the_weeksIN   VARCHAR2,
>   newidOUT  INT
>)
>AS
>BEGIN
>   INSERT INTO fsnep_food_store_game_info
>   (gi_id, login_id, date_added,
>date_modified, grocery_list, budget, MONTH, num_people,
>num_weeks
>   )
>VALUES (unique_food_store_game_info_s.NEXTVAL, 
>fsnep_login, SYSDATE,
>SYSDATE, g_list, budget, the_month, the_num_people,
>the_weeks
>   )
> RETURNING ID
>  INTO newid;
>EXCEPTION
>   WHEN OTHERS
>   THEN
>  ROLLBACK;
>  RAISE;
>END;
>/
>
>call it like this:
>datasource="[your_datasource_name]">
>   dbvarname="fsnep_login" value="#cookie.fsnep_login#" null="No">
>   dbvarname="g_list" value="#form.g_list#" null="No">
>   dbvarname="budget" value="#form.budget#" null="No">
>   dbvarname="the_month" value="#form.the_month#" null="No">
>   dbvarname="the_num_people" value="#form.the_num_people#" null="No">
>   dbvarname="the_weeks" value="#form.the_weeks#" null="No">
>   dbvarname="newid" variable="newid">
>
>
>and then do:
>
>
>
>
>/t
>
>ps: none of the above is tested.
>
>>-Original Message-
>>Subject: retrieve ID from db insert
>>From: Daniel Kessler <[EMAIL PROTECTED]>
>>Date: Mon, 11 Jul 2005 10:47:21 -0400
>>Thread: 
>>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>>&threadid=41103&forumid=4#211529
>>
>>I create a new game and insert it into my Oracle database.  From 
>>there I want to have the game ID and put it into a cookie. I've used 
>>NEXTVAL AND CURVAL for inserting the value into the db, but not for 
>>any external use, like my insert into a cookie.  I guess I can do a 
>>CFLock and then do a query after the insert for the last inserted 
>>item, but is that the best way?
>>
>>Here's the insert:
>>
>>
>>  INSERT INTO fsnep_food_store_game_info
>> (
>> gi_id,login_id,
>> date_added,date_modified,
>> grocery_list,budget,
>> month,num_people,
>> num_weeks
>> )
>>  VALUES
>> (
>> unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
>> SYSDATE,SYSDATE,
>> >cfsqltype="cf_sql_varchar">,>cfsqltype="cf_sql_varchar">,
>> >cfsqltype="cf_sql_varchar">,>value="#form.the_num_people#" cfsqltype="cf_sql_varchar">,
>> >cfsqltype="cf_sql_varchar">
>> 
>> )
>>
>>
>>
>>
>>thanks for any help.
>>
>>-- 
>>Daniel Kessler
>>
>>Department of Public and Community Health
>>University of Maryland
>>Suite 2387 Valley Drive
>>College Park, MD  20742-2611
>>301-405-2545 Phone
>>www.phi.umd.edu
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211538
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[RADEMAKERS Tanguy]

Hello,

1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and
one to get the value of the new ID.

2) Write a stored procedure that returns the value of the inserted id
(see the SQL guide for the syntax of RETURNING INTO clause)

start with this:

CREATE OR REPLACE PROCEDURE insert_game (
   fsnep_login  IN   VARCHAR2,
   g_list   IN   VARCHAR2,
   budget   IN   VARCHAR2,
   the_monthIN   VARCHAR2,
   the_num_people   IN   VARCHAR2,
   the_weeksIN   VARCHAR2,
   newidOUT  INT
)
AS
BEGIN
   INSERT INTO fsnep_food_store_game_info
   (gi_id, login_id, date_added,
date_modified, grocery_list, budget, MONTH, num_people,
num_weeks
   )
VALUES (unique_food_store_game_info_s.NEXTVAL, fsnep_login,
SYSDATE,
SYSDATE, g_list, budget, the_month, the_num_people,
the_weeks
   )
 RETURNING ID
  INTO newid;
EXCEPTION
   WHEN OTHERS
   THEN
  ROLLBACK;
  RAISE;
END;
/

call it like this:










and then do:




/t

ps: none of the above is tested.

>-Original Message-
>Subject: retrieve ID from db insert
>From: Daniel Kessler <[EMAIL PROTECTED]>
>Date: Mon, 11 Jul 2005 10:47:21 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41103&forumid=4#211529
>
>I create a new game and insert it into my Oracle database.  From 
>there I want to have the game ID and put it into a cookie. I've used 
>NEXTVAL AND CURVAL for inserting the value into the db, but not for 
>any external use, like my insert into a cookie.  I guess I can do a 
>CFLock and then do a query after the insert for the last inserted 
>item, but is that the best way?
>
>Here's the insert:
>
>
>  INSERT INTO fsnep_food_store_game_info
> (
> gi_id,login_id,
> date_added,date_modified,
> grocery_list,budget,
> month,num_people,
> num_weeks
> )
>  VALUES
> (
> unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
> SYSDATE,SYSDATE,
> cfsqltype="cf_sql_varchar">,cfsqltype="cf_sql_varchar">,
> cfsqltype="cf_sql_varchar">,value="#form.the_num_people#" cfsqltype="cf_sql_varchar">,
> cfsqltype="cf_sql_varchar">
> 
> )
>
>
>
>
>thanks for any help.
>
>-- 
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD  20742-2611
>301-405-2545 Phone
>www.phi.umd.edu

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211534
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Poor performing Oracle Query

[RADEMAKERS Tanguy]

Hello,

I've never heard of oracle "restarting" a query because the underlying
data had changed. Oracle uses a multi-version view of data to show you
results consistent with what the database looked like at the start of
the query (at the very least - it can also do "consistent with the start
of the transaction"): if a row has been changed since the query started
then oracle will read the "old" value from rollback and use it in the
query. If you are executing a long running select query and making lots
of modifications to the underlying database at the same time, oracle
will eventually need to read info from a rollback segment that has been
flushed to disk and you will get the dreaded ORA 01555 error (snapshot
too old)... but Oracle won't restart the query. Of course, you could
have written your query in some kind of try-catch block (in either cf or
pl/sql) that just repeats whenver this error comes up, but i assume you
would have mentioned it.

Step 0 (if possible): export your live schema and import it to your
testing environment. You won't be able to recreate usage but you will
have "realistic" data.

The very first thing to do in investigating why this query takes so much
more time to execute in production than in development is to make sure
that you are comparing apples to apples: ie run the query using
coldfusion against both databases, and run the query using sql*plus
against both databases and check the results. In the past, i've seen
queries that ran much slower in cf than in TOAD because cf needed all
the results before it could return whereas TOAD only needed the first
rows. If your query returns a lot of records this is something to check
earlier rather than later.

If you see that the same query run from the same client still takes a
huge amount more time on the production database then the next step is
to do an EXPLAIN PLAN on both databases and make sure that the results
are identical. If they aren't, then ask yourself why not: different
volumes of data, lack of table stats in one of the databases, user
resource limitation, etc. 

Finally, if the plans are the same and the query is still taking
waay more time in production, then you need to turn on tracing and
use the tkprof utility to see exactly what is being done. This will slow
down your live db even more but will give you the definitive answer as
to what is happening in the db. 

/t

>-Original Message-
>Subject: Poor performing Oracle Query
>From: Dustin Tinney <[EMAIL PROTECTED]>
>Date: Sun, 10 Jul 2005 11:27:56 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41091&forumid=4#211507
>
>Does your query select any clob or blob data? 
>
>On 7/9/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>> Ian Skinner wrote:
>> > Well we have more information on the problem.  The query 
>that was running fairly well at 30 seconds or so was being run 
>against a validation database where the data is static.
>> >
>> > The query that was performing poorly at 18 minutes was 
>being run against the production server where the data is very 
>active.  Apparently every time data was being added to the 
>main tables, this query would be started over.  So depending 
>on the traffic sometime it performs relatively well other 
>times it performs very poorly.
>> 
>> That sounds rather vague. Does the DBA mean the database was
>> running out of rollback segments and instead of just returning an
>> error was somehow retrying the query?
>> 
>> Jochem

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211528
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: reverse compliment a sequence

[RADEMAKERS Tanguy]

You learn something new every day. 

Thanks for the explanation, i thought it worked like the TR (translate)
function in unix.

/t

>-Original Message-
Subject: reverse compliment a sequence
>From: Barney Boisvert <[EMAIL PROTECTED]>
>Date: Tue, 14 Jun 2005 12:33:28 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40706&forumid=4#209461
>
>ReplaceList is the same as a series of replace operations.  so first
>it replaces the C with a G leaving AGTG, then G with C leaving ACTC,
>then A with T leaving TCTC, and finally T with A leaving ACAC.
>
>replaceList("ACTG", "A,T,Z,G,C,Z", "Z,A,T,Z,G,C") should work
>
>cheers,
>barneyb
>
>On 6/14/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote:
>> Well, i was going to suggest using
>> 
>> #ReplaceList("ACTG","C,G,A,T","G,C,T,A")#
>> 
>> but on my system that replaces "ACTG" with "ACAC"
>> 
>> i'm confused?
>
>-- 
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/
>
>Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209532
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

reverse compliment a sequence

[RADEMAKERS Tanguy]

Well, i was going to suggest using 

#ReplaceList("ACTG","C,G,A,T","G,C,T,A")#

but on my system that replaces "ACTG" with "ACAC"

i'm confused?


>-Original Message-
>Subject: reverse compliment a sequence
>From: Barney Boisvert <[EMAIL PROTECTED]>
>Date: Tue, 14 Jun 2005 11:53:40 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40706&forumid=4#209447
>
>
>
>
>
>
>
>
>
>  
>
>#result.toString()#
>
>cheers,
>barneyb
>
>On 6/14/05, Richard Colman <[EMAIL PROTECTED]> wrote:
>> I need to to reverse compliment a nucleotide sequence, so
>> 
>> C become a G
>> G becomes a C
>> A becomes a T
>> T becomes an A
>> 
>> I need to go through a string a character at a time and 
>build a new string.
>> 
>> So:
>> 
>> "ACTG" becomes "TGAC"
>> 
>> Is there an easy way to do this?
>> 
>> 
>> Richard Colman
>> Institute for Genomics and Bioinformatics
>> 949-824-1816, 701-5330
>> [EMAIL PROTECTED]
>> 
>
>-- 
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/
>
>Got Gmail? I have 50 invites.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209459
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: "James Holmes" <[EMAIL PROTECTED]>
>Date: Thu, 9 Jun 2005 19:59:22 +0800
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#209077
>
>I should also have mentioned that there is an incredibly weird CF bug
>wherein an anonymous block like this in a CFC needs to be all on one
>line:
>
>BEGIN statement 1;  etc; END;
>
>or it fails. Outside of a CFC it can be on more than one line (or you
>can cfinclude the cfquery tag into the CFC and it still works on more
>than one line). No I'm not kidding - I can repeat the bug at will.

i see the bug outside a CFC as well:


declare
nextid number;
begin
select s.nextval into nextid from dual;
end;


throws
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 8:
PLS-00103: Encountered the symbol "" when expecting one of the
following: begin function package pragma procedure subtype type use
form current cursor

whereas 


declare nextid number; begin select s.nextval into nextid from dual;
end;


doesn't throw an error.

but it doesn't return anything either: 



throws

Variable ANONPLSQLTEST is undefined.

so you could use anonymous pl/sql to wrap several statements together in
a single database call, but i don't see how you could use it to get
things out from the db. 


/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209081
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Douglas Knudsen <[EMAIL PROTECTED]>
>Date: Wed, 8 Jun 2005 22:46:41 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#209060
>
>"So here is a completely random question. How can a user kill thier own
>session in Oracle without having priveleges to kill everyones session?
>(i.e. if they logout of the cf app, can we kill that user's session
>through a procedure rather than waiting for the session to timeout)"
>
>
>hmm, if you have connection pooling off in CFs DSN settings, 
>this happens 
>immediately. Otherwise I suppose you could run an SP upon 
>logging out that 
>kills it, eh? Or just set the timeout sweeper thingy to run 
>more often. How 
>often do users actually click logout though, eh?

It could be done because of the definer rights thing - as long as the
user who wrote the "killer" sp has the right to kill sessions then the
user who is executing it doesn't need to. You'd just have to get your
own SID and serial# values and pass them to the sp. Thing is, this isn't
a really attractive approach (imho) as  it's equivalent to asking
somebody to hang up the phone on you (and slam it down at that): why not
just hang up yourself? I'd say look into methods for closing/destroying
the java connection object from within cf, possibly using a JDBC aware
framework like ontap.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209073
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

Hello Doug,

as ever... inline ;) 

>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Douglas Knudsen <[EMAIL PROTECTED]>
>Date: Wed, 8 Jun 2005 15:15:06 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#209017
>
>1) huh? each connection to Oracle from CF creates a new 
>session. If you 
>happen to have connection pooling on in the ColdFusion DSN 
>settings, then 
>yes you would only see a fixed set of sessions as they are 
>reused, having 
>this set to one would get what you are seeing perhaps. If you have 
>connection pooling off in CF for the DSN, then you could see only one 
>session in the kill/trace view in Oracle IFF there is only one 
>connection to 
>Oracle from CF whilst you are looking. In fact, I have 
>connection pooling 
>off for several DSNs on a server. Say the DSN is named FOO. I 
>can look in 
>Oracle and see multiple sessions for FOO that die as soon as 
>the ColdFusion 
>request containing the CFQUERY/CFSTOREPROC call is done.

I was all ready to post a big rebuttal to this... and then i saw you
were right ;)

I made a cfpage like this:
-scribble.cfm


insert into t (id,name) values(s.nextval,'#header#')






and then opened up a bunch of tabs in my browser and cued up the url,
made sure i had the "maintain connections" checked and "limit
connections" unchecked in the admin, kicked off my tabs, and checked the
sessions in v$session -> result: just one session. Luckily for me,
before putting my foot in it big time, i also opened the url in the big
blue E and checked again: two sessions! I then opened up a truly sick
number of tabs and checked again: some more sessions (total of four
right now). So we're not talking one session per connection: it's more
like cf creates extra sessions/connections on an "as needed" basis.

>
>Now, what I have not figured out yet is, if you have 
>connection pooling off 
>for a DSN, call it GOO, and you have two CFQUERYs in a single 
>CF page, does 
>one connection/sessioon get used for both or are there two 
>connections/sessions? If its two seperate requests to the same 
>CF page, then 
>yes, there are two seperate and distinct connections/sessions. 
>I just don't 
>know at the page level.

Well, i tried turning "limit connections" on and setting "Restrict
connections to" to 1 then calling the same page as above (since it
satisfies the "multiple queries in a page" criteria) - result:

- with "maintain connections" checked: one session, same sid, same
serial throughout the page exec time, sticks around after the page ends
(and gets reused on reload)
- with "maintain connections" UNchecked: one session, same sid, same
serial throughout the page exec time, but it disappears once the page as
finished.

So it seems to me that cf will always execute all the queries in a given
page within the same session, but it *may* also execute queries from
different pages in the same session as well. I think it has to do with
making sure all the queries in a given transaction execute in the same
session (duh) - if a transaction is only one query long, then you can
reuse the session for another transaction quickly. Conclusion would be:
if you have a small pool of connections, be careful of long running
transactions because you're going to "hog" a scarce resource.


>
>2) a comment from my DBA here 'Yup, that comment is dead 
>wrong. Oracle never 
>inherently auto-commits inside or after a SP, unless it contains a DDL 
>operation (create index, analyze table, grant privs, etc).' 
>I'm agreeing 
>with tanguy below, we have seen this behaviour. CF 
>automagically appends 
>'SET TRANSACTION ISOLATION LEVEL READ COMMITTED' to the end of each 
>statement passed unless you use CFTRANSACTION. This includes 
>calling SPs. 


READ COMMITTED is pretty close to oracle standard, and i don't think we
can put **all** the blame squarely on cf - part of it belongs with JDBC,
which autocommits by default. Of course, java developers can just do
conn.setAutoCommit(false) - it would have been nice if there was a
checkbox in the cfadmin that allowed that. On the other hand (there's
always an other hand with me), cf is about making things simple, and
having to add an extra  at the bottom of every page that
modified data just to commit is not a simple solution. Cftransaction
actually works incredibly well, considering how easy it is to use.
Seriously, if you look at the hoops java developers have to jump
through, coldfusion's db access stuff is pretty sweet.

>Now, if you have a commit withing the body of your SP, this 
>kind of bypasses 
>what CF can be concerned about, eh?

Well, a lot of people who work with other databases do that because in
some databases long running transactions are a no-no, so you try to
break them up to remove stress from your db server. This is not the case
with oracle.

>
>
>DK

~~

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

Adam,

>1) No. Not true. I have a public website that has over 5k oracle
>users. 1 user account is used for the public (ie. people who do not
>log in). They all share the same session. When you look at active
>sessions in oracle there is only 1 entry for the public account.
>Unless that account is connecting from a different client toad/cf. CF
>passes the same username/password to oracle for the public account,
>oracle has no way to determine that different requests are different
>sessions, its all based on the client used to connect (dataDirect
>JDBC) and the username/password.

Sorry, should have been more clear: At the end of his mail, James
indicated that he had put page 1 and page 2 on two different servers - i
didn't mean that oracle created a different session for each page or
query. In the majority of cases (most people don't change the
username/password in their data source per *web* user) your web
application uses a single session in the db (per connection if you use
connection pooling). But if you have several web servers connecting to
the same db, then each has its own session.

As an aside, you *can* create two (or more) sessions for the same
user/password using the same client from the same machine - open two
command prompts on your machine, use sqlplus to connect to the same
schema as the same user with the same password, then open a third
command prompt, connect as sys or system and issue:

SELECT SID, username, machine, program FROM v$session WHERE schemaname =
'[[SCHEMANAME]]';

you will see two sessions with different sids, but all else will be
equal.

>
>2) Well thats kinda what I'm wondering. I think the commit occurs
>directly following the  tag, because Oracle
>automatically commits when _any_ stored procedure finishes without
>exception. Regardless if CF made the procedure call or an Oracle Forms
>app did. I don't think the  tag can modify the
>procedure call to tell oracle not to commit. Even if it could, would
>it be able to chain that to all procedures that were internal to the
>initial procedure call?

Without cftransaction, the commit DOES happen right after
, but that's because coldfusion is telling oracle to
commit. Try this:

session one:
[EMAIL PROTECTED]> truncate table t reuse storage;

Table truncated.

[EMAIL PROTECTED]> declare
  2  newid number;
  3  begin
  4 newid := NULL;
  5 t_insert('this is a test',newid);
  6  end;
  7  /

PL/SQL procedure successfully completed.

session two:
[EMAIL PROTECTED]> select * from t;

no rows selected

back in session one:
[EMAIL PROTECTED]> commit;

Commit complete.

back in session 2:
[EMAIL PROTECTED]> /

ID NAME
-- --
  1092 this is a test


i.e. oracle does not automatically commit a stored proc any more than it
does a "regular" block of sql - cf does (on both counts), unless you use
cftransaction. 

As for internal procedures, same difference: they're all part of one
transaction unless one of them called commit (or issued a ddl statement
like "alter table...", which causes a commit)- which is something you
should NEVER do within a stored proc, since it means you will not be
able to reuse that proc in a longer or different transaction tomorrow.
Bottom line: it is up to the client to decide when to commit because the
client knows when he is "done". Some people use commits in stored procs
along with nested procs by creating an outer "unit of work" procedure
which just manages the transaction - it calls the nested procs and then
issues a commit at the end - but there's no need to do that in cf:
either call a single proc by itself and cf will commit afterwards or
call several procs in a cftransaction and cf will commit after the
transaction: cf manages the "unit of work" for you.

/t


>
>-Adam



>
>On 6/8/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote:
>> Adam,
>> 
>> 1) Even with the same username/password, oracle treats it as two
>> sessions. If you have TOAD you can verify this with the 
>session browser.
>> 
>> 2) stored procs don't change the transaction handling of 
>oracle (unless,
>> or course, you manually commit within the body of the proc) - ie cf
>> handles cfstoredproc just like cfquery: by default it will 
>commit after
>> each  unless you use .
>> 
>> /t


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209016
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

Adam,

1) Even with the same username/password, oracle treats it as two
sessions. If you have TOAD you can verify this with the session browser.

2) stored procs don't change the transaction handling of oracle (unless,
or course, you manually commit within the body of the proc) - ie cf
handles cfstoredproc just like cfquery: by default it will commit after
each  unless you use .

/t 

>-Original Message-
Subject: FW: Get New Record ID in ORACLE
>From: Adrocknaphobia <[EMAIL PROTECTED]>
>Date: Wed, 8 Jun 2005 10:52:48 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40594&forumid=4#208966
>
>James,
>
>Interesting test. This strongly contradicts what our DBAs have been
>telling me. I'm going to bring this up with them. (I love when they
>are proved wrong!). The only thing is that you are using only a single
>session. ie. same user to perfrom both actions since I'm assuming u/p
>is hardcoded into your DSN. Although you get all sorts of errors with
>cftransaction if they aren't hardcoded.
>
>What about with stored procedures? I think the second a procedure is
>completed and returned the commit is automatically applied, regardless
>of the cftransaction. So is it safe to say that cftransaction should
>only be used with cfquery and not cfstoredproc?
>
>-Adam


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: session variables or multiple pages

[RADEMAKERS Tanguy]

By default, CF uses cookies to hold the session key, so you are running
into the same basic problem. Solution is to use  and then pass CFID and CFToken by url or hidden
form field on every page. Depending on the size of your app, you might
have your work cut out for you.

/t 

>-Original Message-
>Subject: session variables or multiple pages
>From: Daniel Kessler <[EMAIL PROTECTED]>
>Date: Wed, 8 Jun 2005 09:10:19 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40614&forumid=4#208939
>
>My boss has indicated to me that he would like to open up two PC IE 
>browser windows, log into our application under two different logins 
>and view the data from each of those independently.  I had been 
>keeping information in cookies, but since they'd share a cookie, I 
>migrated the information over to session variables.  But it doesn't 
>seem to be working.
>
>I log in as danielk and it shows "logged in as danielk".  Then I open 
>a second browser window and log in as rsBold and it shows "logged in 
>as rsbold" in the second browser window.  I then refresh the first 
>window using the refresh button and it shows "logged in as rsbold" 
>instead of danielk.  So they're still sharing the information.
>
>help?  this is an important feature.
>
>-- 
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD  20742-2611
>301-405-2545 Phone
>www.phi.umd.edu

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208957
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

>-Original Message-
Subject: FW: Get New Record ID in ORACLE
>From: Adrocknaphobia <[EMAIL PROTECTED]>
>Date: Tue, 7 Jun 2005 13:57:35 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40594&forumid=4#208851
>
>Well there are more (minor) speed benefits. Where as cfquery get
>compiled every time procedures do not. A stored procedure may be
>faster on the second run and the same speed following; cfquery will be
>as slow no matter how many times it's executed.

Not if you use bind variables - in fact, that's the whole point of bind
variables: you are telling the db "this is the same query i just ran,
but for different values, so go ahead and re use the same query plan
from the shared pool". 


>I've said this above, but cftransaction is drastically different than
>the transaction in a database. Plus it really doesnt fit well in an
>MVC pattern. Again, cftransaction doesnt give you row level locking.
>Which is pretty key in a database transaction. If you had two
>applications using the say schema. Both apps in CF, running seperate
>instances or using two seperate DSNs. They know nothing of each other
>transactions. You are going to end up with race conditions, which is
>what the transaction in the database will prevent.

not too sure i understand what you mean here. CF (used without
cftransaction) has a dirty habit of committing after each and every
cfquery, whereas as you pointed out cftransaction just delays the
commit, which allows oracle to manage the transaction. Oracle will lock
the rows you are updating and will place a ROW SHARE TABLE lock on the
table to make sure nobody else can change the structure of the table.
But if the two sessions want to change different rows in the same table
there should be no problem. Are you sure you aren't thinking of
deadlocks - where two sessions both need the other to commit before
being able to continue - the famous user 1 updates A, user 2 updates B,
user 1 updates B (has to wait for user 2 to commit - blocked but not
deadlocked), user 2 updates A (has to wait for user 1 to commit... bingo
deadlock)? 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208858
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

FW: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

 
aaargh - sorry, keep forgetting to turn off my digital signature. i
think the server kicks the mail in that case? otherwise... sorry ;))


>-Original Message-
>From: RADEMAKERS Tanguy 
>Sent: Tuesday, June 07, 2005 6:33 PM
>To: 'cf-talk@houseoffusion.com'
>Subject: RE: Get New Record ID in ORACLE
>
>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Adrocknaphobia <[EMAIL PROTECTED]>
>Date: Tue, 7 Jun 2005 10:51:35 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#208800
>
>1. Performance (maybe not as much on insert, but updates an queries
>definitely faster). When running queries in Oracle, a plan is made on
>how to efficiently retrieve the data. The PL/SQL is precompiled and an
>action plan is made to optimize performance.

That's not a completely fair or accurate point: the second 
execution of a stored procedure will be much faster than the second
execution of a  assuming that the cfquery doesn't use 
bind variables and is being run with different parameters. Otherwise,
the db will reuse the stored query plan and the time 
difference won't be *that* great. The reason i want to point 
this out is that a
lot of people think "SP's are complicated but they're fast", 
so they tend to see them as a kind of optimization technique... and
then they get disappointed when switching to SP's doesn't 
magically "deliver" much faster execution time. If all you're after is
speed and scalability then a) spend some time learning how to 
write correct sql and b) use cfqueryparam.


>2. Transaction and Locking. A procedure is an implied transaction
>block that the _database_ manages. If your database supports the
>ability for transaction and locking, CF should really never be used.
>If you have multiple SQL statements to execute, when in a procedure,
>it one fails then the actions are not commited to the database.
>
True enough, but then again that's what cftransaction is for. 
You could counter with savepoints and autonomous transactions but then
we're really getting into edge cases. 

>
>3. Security. Security. Security. This is by far the biggest and most
>important aspect of procedures in my opinion. I can't sleep easy at
>night knowing an application's SQL statements (a roadmap diagraming
>your database) is stored in open text files on your web server (which
>is the server most commonly comprimised).
>
>Additionaly, with procedures and packages you can start to leverage
>the role based permission of your database. For instance, the only
>actions a user is allowed to perform in the database is to execute a
>certain set of methods. When the SQL is stored in CF, then the user
>must have permission to select, insert, update & delete on every table
>in your database. (Unless you want to get into the enormous task of
>specifying each table/privelage seperately)

+1. The number of people who connect their web application to 
their database as a user with dba privs is amazing. There are two
aspects to sql injection attacks: people putting junk data 
into your tables... and people damaging your database (dropping tables,
deleting records, etc). In most cases, the user your web app 
connects as has no business being allowed to drop or create objects.
SP's are a great way to grant explicit object level privs to 
the web app user without having to even use the db privs system: they
can only do those things you gave them a proc to do. 

>
>4. Inline SQL functions. The ability to call custom functions 
>within a query.

yess, but: you could write functions in pl/sql and call 
them from within a query in a cfquery block.

>
>These are the first 4 that benefits that come to mind, but there are
>surely more. PL/SQL is a very very very simple language. You can read
>Oracle Press PL/SQL book in a weekend and become an expert.
>
>-Adam

My favorite stored proc feature is that when i change a 
database table i immediately know which procs need to be updated at the
press of a button, without having to test my whole web app. My 
second favorite feature is that i know where all my sql is. To be
more explicit on the book end: check out the book "Learning 
Oracle PL/SQL" from O'Reilly and hold off on the two other fuerenstein
books - you can
easily read that in a weekend and it will cover everything 
almost everybody needs to know for a long long time. 

/t

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208841
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

Aaron,

Read the concepts guide in the oracle docco, then check out the two
books by Tom Kyte - "expert one on one oracle" (get it secondhand, it
was written for 8i and the new edition will come out soon for 10g) and
"effective oracle by design". There are plenty of "big companies looking
for any excuse" to use oracle and it's actually fun. Twisted and bizarre
fun, but fun. If you're gonna work with it anyway, you might as well use
the opportunity to beef up your cv, it never hurts.

/t

>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Tue, 7 Jun 2005 10:48:52 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#208815
>
>Because this is a big oilfield company that spent way too much 
>money with 
>Oracle and is looking for any excuse to just use it. They 
>appear to not care 
>if it is used "right" or not. The web applications do not do 
>much more than 
>simple queries, other groups might very well be doing things much more 
>complex in Oracle. We also do not have access to any of the 
>administrative 
>side of things, typically a web application has a user in 
>Oracle that would 
>appear to have full access to that tablespace, although I do 
>know when I was 
>tried to create a "type" it did not have permissions but their fix was 
>simply to grant that permission to all users. That same user 
>is what is used 
>by the CF server connection. 
> I do believe I was saying simple inserts and updates, I just 
>have to wonder 
>what in the world people are collecting through a web interface that 
>requires complex inserts and updates. Now some of the select 
>queries, such 
>as for some of the reports I would not label simple, not sure 
>if I would use 
>complex either but that is why I tried not to specify select queries.
> I was just trying to verify on cftransaction, the first email 
>implied to me 
>that the only way it could be done was through a stored procedure.
> On 6/7/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: 
>> 
>> Hrmm, if you arent taking advantage of Oracle security and you are
>> just running simple queries... then why invest in such an expensive
>> database?
>> 
>> As far as cftransaction, it does work that way, but that logic really
>> belongs in the model (the database) not the controller (cf).
>> 
>> -Adam


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208833
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Douglas Knudsen <[EMAIL PROTECTED]>
>Date: Tue, 7 Jun 2005 10:41:52 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#208799
>
>select mysequence.nextval into newid from dual 
>
>You are using a sequence for your IDs, no? 
>
>DK

LOL. Yes i am using sequences for my IDs.

I have a sequence called s. This code:


select s.nextval into newid from dual


fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905:
missing keyword 

This code:


select s.nextval from dual


works just fine. So i am assuming that you insert a new row like this:


select s.nextval from dual



insert into t (id,name) values(#nextval.nextval#,'this is a test')


i was just wondering whether you had found a way to make "select
mysequence.nextval into newid from dual" work in a cfquery block (like
anonymous pl/sql or something). Have you?

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208807
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

>what problem? I use this
>
>select mysequence.nextval into newid from dual
>
>insert into foo (a,b,c,pk) values (A,B,C, newid)
>
>do whatever else you want with newidcarry on.

Yes, but how do you retrieve the value of the just inserted id? I can't
get the "select ... into..." syntax to work in a cfquery, perhaps you
could post an example?

If you don't need to get this value, then you can rewrite your query as:


insert into foo (a,b,c,pk) values (A,B,C, mysequence.nextval)


/t


>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Douglas Knudsen <[EMAIL PROTECTED]>
>Date: Tue, 7 Jun 2005 08:59:07 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#208782
>
>what problem? I use this
>
>select mysequence.nextval into newid from dual
>
>insert into foo (a,b,c,pk) values (A,B,C, newid)
>
>do whatever else you want with newidcarry on.
>
>I have yet to really understand the need for doing everything 
>via SPs. They 
>are only really faster in complex situations, no? Also, they seem to 
>complicate the ease of CF's cfquery tag too and place extra 
>burden on SCM, 
>IMHO.
>
>DK
>
>On 6/7/05, James Holmes <[EMAIL PROTECTED]> wrote:
>> 
>> For one they get around the problem of getting the last id 
>inserted into
>> the table as per some of the discussion in the MySQL thread 
>yesterday,
>> without needing to use serializable transactions. Procedures are also
>> often pre-compiled, so they may run faster, even the first 
>time they are
>> executed, although on an insert this probably doesn't make much
>> difference.
>> 
>> -Original Message-
>> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, 7 June 2005 11:57
>> To: CF-Talk
>> Subject: Re: Get New Record ID in ORACLE
>> 
>> What type of advantages does an SP in oracle(or whatever) have over
>> queries for basic DB inserts?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208797
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF & Google desktop search

[RADEMAKERS Tanguy]

there's an existing plugin (Larry's Any Text File Indexer) that allows
you to easily configure the extensions of any text based files you want
GDS to index... most handy.

/t

>-Original Message-
>Subject: CF & Google desktop search
>From: Rob <[EMAIL PROTECTED]>
>Date: Fri, 3 Jun 2005 10:28:29 -0700
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40529&forumid=4#208548
>
>Hum... is your code on your local machine or on a networked / shared
>drive? If it's not local you have to hack google to index your code
>http://www.robrohan.com/blog/index.cfm?mode=entry&entry=662FD36
>7-D5C5-08EE-BEFD1BC0B9CF83EF
>
>Otherwise, it might not do tags... I don't have any cfcode available
>at the minute to check

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208784
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

Jochem,

I tried to make an example using  the INSERT .. RETURNING syntax
directly in a cfquery to make the example clearer, but i couldn't get it
to work with straight SQL (didn't try things like anon pl/sql block). Do
you have such an example you could share with us? 

Aaron,
>What type of advantages does an SP in oracle(or whatever) have 
>over queries for basic DB inserts? 

SPs don't have any benefits over queries specifically for inserts, but
they have more general advantages that come into play here as well, like
the fact that they "automagically" use bind variables (unless you use
dynamic sql), etc. Contrary to popular belief, simple SPs are not
markedly faster than simple SQL statements, assuming several things
(like either correct use of cfqueryparam or repeating the same query
over and over so it's exec plan is read from the cache). The real
benefits are in things like code organization - keeping your sql
separate from your CFML, the fact that other developers on a team are
less likely to change a SP than a block of SQL in a cfm file - and even
less likely to just copy and paste it somewhere else if they need
"something kinda like that". Also, in oracle, the db can warn you if
your sp's become invalid, for example as a consequence of modifying a
table, whereas with queries you'll discover that error at runtime. You
can use sp's to enforce quite clever database security practices due to
what's called the "definer rights" model (by default, sp's in oracle
execute with the privs of the user who wrote them, not the user who's
running them). Once you get into more complex db manipulations - the
kind of things where you'd have several cfqueries in a row - then sp's
offer the possibility to do all kinds of stuff in a single trip to the
db, but then you're heading towards putting business logic in the db...
not necessarily a bad thing, but something to keep in mind. I started
using sp's because i had to, but now i think i would use them for
anything but the very simplest of projects.

/t


>-Original Message-
>Subject: Get New Record ID in ORACLE
>From: Jochem van Dieten <[EMAIL PROTECTED]>
>Date: Tue, 07 Jun 2005 10:33:57 +0200
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=40571&forumid=4#208766
>
>James Holmes wrote:
>> For one they get around the problem of getting the last id 
>inserted into
>> the table as per some of the discussion in the MySQL thread 
>yesterday,
>> without needing to use serializable transactions.
>
>But for that you can also use the INSERT .. RETURNING .. directly.
>
>Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208770
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get New Record ID in ORACLE

[RADEMAKERS Tanguy]

You don't need to use triggers at all if you use stored procedures:

--setup.sql---
CREATE TABLE t
(
  IDINTEGER NOT NULL,
  NAME  VARCHAR2(50)
);

CREATE SEQUENCE s;

CREATE OR REPLACE PROCEDURE t_insert (newname IN VARCHAR2, newid OUT
INT)
AS
BEGIN
   INSERT INTO t
   (ID, NAME)
VALUES (s.NEXTVAL, newname)
 RETURNING ID
  INTO newid;
END;

/

--scribble.cfm


  


  

  #myNewId#: #header#




plus, you can use packages to organize your procedures - either one per
table with all CRUD code (many tools can auto generate this for you if
you wish) or whatever (i'm a fuseboxer, so i create an [APPCODE]_QUERIES
package for selects and an [APPCODE]_ACTIONS package for inserts,
deletes, and updates).

Many people shy away from stored procs because they think they are
complicated, but they aren't and they have many benefits over plain
cfquery (IMNERHO).

/t

>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208718
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: [OT] Free ftp/sftp server

[RADEMAKERS Tanguy]

Dave,

Check out the FileZilla project on sourceforge. Their main product is an
ftp/sftp client, but they also have a server product. I haven't used it,
but i've been *real* impressed with the client in terms of how often
they release, fix bugs, patch security problems, etc - so i'd say the
server probably deserves a spin.

It's GPL and has beta sftp support. Win32 only...

/t

>-Original Message-
>From: Dave Merrill [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, May 18, 2005 3:49 PM
>To: CF-Talk
>Subject: [OT] Free ftp/sftp server
>
>I'm switching from IIS to Apache (win2k), and the only thing preventing
>me from shutting down IIS completely is that I need an ftp 
>server (don't
>ask).
>Ideally is should do sftp, be cross-platform win/nix/mac, and be
>compatible with a wide variety of clients. (I'm not interested in a cf
>solution.)
>
>The only relevant jakarta project I saw is Apache FtpServer, here:
>  http://incubator.apache.org/projects/ftpserver/
>
>The last update of that was in late '03, and it's at 0.9, neither of
>which makes me feel all warm and fuzzy about it, but it might be great.
>
>Besides that, I've seen:
>
>freeFTPd - appears to be brand new, win only, does sftp I think
>FtpGoServer - cross platform java War FTP Daemon - win, been around for
>ever
>
>Anyone have experience with any of these, or good alternatives?
>
>Thanks,
>
>Dave Merrill

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207148
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

interesting problem with function isNumeric and "NaN"

[RADEMAKERS Tanguy]

Hello,

I've come across an interesting problem during some form validation
involving the function isNumeric() and the value "NaN" ("Not a Number" -
it's what js gives you when you try to use strings in math). I've done a
very quick search on Google and in the MM knowledgebase but didn't find
anything. 

Here's an example:

isNumeric("NaN")? - #isNumeric("NaN")#

"NaN" gt 5? - #("NaN" gt 5)#


cfsetting myNumber = "NaN"...


isNumeric(myNumber)? -
#isNumeric(myNumber)#

myNumber gt 5? - #(myNumber gt 5)#

As you'll see, both isNumeric("NaN") and isNumeric(myNumber) return YES,
but "NaN" gt 5? returns NO whereas myNumber gt 5? throws a
coldfusion.runtime.Cast$NumberConversionException - The value "NaN"
cannot be converted to a number. This is causing me some problems
because i have code that looks like:



I wrote a quick and dirty isNaN() UDF (like the native one is js) so i
can fix the immediate problem, but i can't help thinking that i'm
missing something obvious.

This is on CFMX 6 and my local copy of CFMX 7. 

/t





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206922
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: detecting back button for page refresh

[RADEMAKERS Tanguy]

There is no way to do this from the server side, as no page request is
made (it is loaded from cache), so you will have to use javascript -
here's an example from the web:

-start---













-end---

note that this approach will detect any load from cache - so the forward
button as well. Once you've detected that the page was loaded from
cache, you can use the javascript location.reload(true) function to
force a reload of the page.

/t


 

>-Original Message-
>From: Protoculture [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, May 03, 2005 5:05 PM
>To: CF-Talk
>Subject: detecting back button for page refresh
>
>Hi All. I would like to detect that the user has clicked the 
>back button. I need to do this in order to get the last value 
>entered in the form. ( currently using session variables to 
>recall the last item searched for ). However as you can guess, 
>by pressing the back button you do not get the lastest session 
>items, you get the old ones. 
>
>any work arounds?
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205411
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF Error weirdness

[RADEMAKERS Tanguy]

Mike,

Do they perchance have a site wide eror handler defined in the
"Settings" section?

/t

>-Original Message-
>From: Michael Bramwell [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, May 03, 2005 11:25 AM
>To: CF-Talk
>Subject: CF Error weirdness
>
>This is a strange and frustrating problem, I have successfully 
>implemented cferror on our linux staging server, the problem 
>is that the exact same code seems to be getting completely 
>ignored on the clients linux staging server. What I am 
>wondering is if there are any settings within cfide admin that 
>disable cferror? If not any other suggestions will be more 
>than welcome as I am completly stumped on this one and have 
>had no responses in other coldfusion forums.
>
>Cheers,
>
>Mike.
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205354
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Little OT but know one else to ask...

[RADEMAKERS Tanguy]

oops - wrong thread!

/t 

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
>Sent: Monday, May 02, 2005 11:19 PM
>To: CF-Talk
>Subject: RE: Little OT but know one else to ask...
>
>Thanks, but I'm not sure that this pertains to my question.  I 
>was asking
>about the CDONTS send mail program included with windows 2000 
>server.  I
>tried copying it to windows 2003 but cant get it to run.  It 
>tells me access
>is denied.
>
>Thanks,
>
>David
>
>-Original Message-
>From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED]
>Sent: Monday, May 02, 2005 4:29 PM
>To: CF-Talk
>Subject: RE: Little OT but know one else to ask...
>
>
>tried answering this from the HOF website, but no joy...
>
>check out a product called Badboy (badboy.com.au) - it allows you to
>record website visits and then script them for testing. It can also
>export these scripts to Apache JMeter (jakarta.apache.org) which
>supports extra scripting and automation. JMeter can be a 
>little dicey to
>set up at first, but once you've got it running it's pretty sweet.
>
>Otherwise, there's a product called winrunner that our QA dept. uses,
>but i think it's expensive.
>
>/t
>
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>>Sent: Monday, May 02, 2005 9:59 PM
>>To: CF-Talk
>>Subject: RE: Little OT but know one else to ask...
>>
>>ok, I just noticed that I spell "NO" as "KNOW" in the subject.
>> So please
>>don't flame me... ;-)
>>
>>David
>>
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>>Sent: Monday, May 02, 2005 1:46 PM
>>To: CF-Talk
>>Subject: Little OT but know one else to ask...
>>
>>
>>Hello, all...
>>
>>This is kinda off topic.
>>
>>I added the CONTS mail object to win2k3 ENT from win2k Adv
>>Srv.  I added it
>>to the component services interface as a legacy component
>>under IIS Out of
>>Process Components and gave everyone access to it(behind
>>firewall so not a
>>huge deal).  It still says access is denied when I try to use
>>it from ASP or
>>CF... Has anyone ever encounted this problem and how did you fix it?
>>
>>Thanks,
>>
>>David
>>
>>
>>
>>
>>
>
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205352
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Little OT but know one else to ask...

[RADEMAKERS Tanguy]

tried answering this from the HOF website, but no joy...

check out a product called Badboy (badboy.com.au) - it allows you to
record website visits and then script them for testing. It can also
export these scripts to Apache JMeter (jakarta.apache.org) which
supports extra scripting and automation. JMeter can be a little dicey to
set up at first, but once you've got it running it's pretty sweet.

Otherwise, there's a product called winrunner that our QA dept. uses,
but i think it's expensive.

/t

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
>Sent: Monday, May 02, 2005 9:59 PM
>To: CF-Talk
>Subject: RE: Little OT but know one else to ask...
>
>ok, I just noticed that I spell "NO" as "KNOW" in the subject. 
> So please
>don't flame me... ;-)
>
>David
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Monday, May 02, 2005 1:46 PM
>To: CF-Talk
>Subject: Little OT but know one else to ask...
>
>
>Hello, all...
>
>This is kinda off topic.
>
>I added the CONTS mail object to win2k3 ENT from win2k Adv 
>Srv.  I added it
>to the component services interface as a legacy component 
>under IIS Out of
>Process Components and gave everyone access to it(behind 
>firewall so not a
>huge deal).  It still says access is denied when I try to use 
>it from ASP or
>CF... Has anyone ever encounted this problem and how did you fix it?
>
>Thanks,
>
>David
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205315
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Microsoft sponsoring CFUNITED-05

[RADEMAKERS Tanguy]

"half-ish" 

>-Original Message-
>From: Rob [mailto:[EMAIL PROTECTED] 
>Sent: Friday, April 29, 2005 5:04 PM
>To: CF-Talk
>Subject: Re: Microsoft sponsoring CFUNITED-05
>
>That was the new American Math btw:
>
>61 / x = 37
>x = like half
>
>:-/ 
>
>On 4/29/05, Rob <[EMAIL PROTECTED]> wrote:
>> They *used* to have that much. It's down to like 35 billion 
>or so (yup
>> thats like half)
>> http://finance.yahoo.com/q/ks?s=MSFT
>> 
>> Looks like thier cash is going the way of IE usage :)
>> 
>> Not that I would mind 30 billion in the bank...
>> 
>> On 4/29/05, Robert Munn <[EMAIL PROTECTED]> wrote:
>> > Microsoft has $61 billion in cash. Not stock. Not 
>valuation. Not borrowed money. Cash. They have to spend it on 
>something. Given the way they have benefited from the PC 
>revolution and their serendipitous rise to domninance, they 
>should sponsor every computing event everywhere in the world, 
>both to give back to the community and to give themselves 
>every opportunity to understand where the industry is going.
>> >
>> > >Rob wrote:
>> >
>> > >I went to the Microsoft booth at Linux World because I 
>felt bad for
>> > >the poor guys standing there. I saw them an 
>networld+interop, and I
>> > >think I saw them at Mac World too. The point is, good or 
>bad, they go
>> > >to (and by that I mean sponsor) almost anything they can 
>- even if it
>> > >has little to do with them they find a way to show up so 
>that's not
>> > >too surprising.
>> >
>> > 
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205086
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get file size on UNIX?

[RADEMAKERS Tanguy]

of course i meant "wc -c [your_filename_here]"

i'll just get my coat... 

/t 

>-Original Message-
>From: RADEMAKERS Tanguy 
>Sent: Thursday, April 28, 2005 7:59 PM
>To: 'cf-talk@houseoffusion.com'
>Subject: RE: Get file size on UNIX?
>
>>something like this?
>>
>>ls -alh ./ | grep -v ".* \." | awk {'print $5"|" $9'}
>
>or "wc -c"
>
>/t
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Get file size on UNIX?

[RADEMAKERS Tanguy]

>something like this?
>
>ls -alh ./ | grep -v ".* \." | awk {'print $5"|" $9'}

or "wc -c"

/t

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

like it says (somewhere):
"never say 'ps!', always say 'ah, interesting'" 

>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 7:20 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>Yes... and I ran fine.  LOL
>
>18 live servers and it runs fine.  1 development server (where 
>I run this
>script) it blows...
>
>Go figure.
>
>-Original Message-
>From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 10:15 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>oh, smells like a learning experience ;)
>
>anybody else out there got a windows 2003 machine to try this on? 
>
>>-Original Message-
>>From: Jacob [mailto:[EMAIL PROTECTED] 
>>Sent: Thursday, April 28, 2005 7:11 PM
>>To: CF-Talk
>>Subject: RE: CFMX interrupting javascript - MORE
>>
>>On my laptop...  Windows 2000 Server, IIS 5.0, CF MX 6.1 
>>development edition
>>..
>>..
>>..
>>..
>>..
>>..
>>
>>78 ms
>>
>>Is it Friday yet???
>>
>>-Original Message-
>>From: Kerry [mailto:[EMAIL PROTECTED] 
>>Sent: Thursday, April 28, 2005 9:56 AM
>>To: CF-Talk
>>Subject: RE: CFMX interrupting javascript - MORE
>>
>>and this:
>>
>>
>>
>>
>>
>>
>>
>>
>>http://XX/DVD/"&trim(tmpURL)&">>color=""Navy""
>>style=""font-size: 15px;"">"&trim(tempTitle)&"  >color=""Navy"" style=""font-size: 15px;"">DVD >href=""javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
>>ge.cfm?Image=
>>"&urlencodedformat(main_jpeg)&"&type=DVD&title="&urlencodedform
>>at(tempPopTit
>>le)&"','236','335')"" onmouseover=""window.status='See Box 
>>Art'; return true
>>""
>>onmouseout=""window.status=''"">>src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>>Art"" hspace=""4""
>>vspace=""0"" border=""0"" align=""bottom"">">
>>>output="#line#">
>>
>>#gettickcount()-timer#
>>
>>took 67ms
>>
>>CFMX 6.1 + win2k + phat dev box under no load
>>
>>
>>
>>-Original Message-
>>From: Jacob [mailto:[EMAIL PROTECTED]
>>Sent: 28 April 2005 16:46
>>To: CF-Talk
>>Subject: RE: CFMX interrupting javascript - MORE
>>
>>
>>This looped 50 times takes on average 1.2 to 1.4 seconds:
>>
>>
>>
>>>addnewline="No"
>>output="http://XX/DVD/#trim(URL)#"">>style=""font-size: 15px;"">#trim(tempTitle)#  >color=""Navy"" style=""font-size: 15px;"">DVD >href=""javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
>>ge.cfm?Image=
>>#urlencodedformat(main_jpeg)#&type=DVD&title=#urlencodedformat(
>>tempPopTitle)
>>#','236','335')"" onmouseover=""window.status='See Box Art'; 
>>return true ""
>>onmouseout=""window.status=''"">>src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>>Art"" hspace=""4""
>>vspace=""0"" border=""0"" align=""bottom"">">
>>
>>
>>
>>This looped 50 time takes .2 to .3 seconds:
>>
>>
>>
>>>addnewline="No"
>>output="http://XX/DVD/#trim(URL)#"">>style=""font-size: 15px;"">#trim(tempTitle)#  >color=""Navy"" style=""font-size: 15px;"">DVD>src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>>Art"" hspace=""4""
>>vspace=""0"" border=""0"" align=""bottom"">">
>>
>>
>>
>>This was removed from the second test.
>>
>>
>>
>>>href=""javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
>>w_Movies_Imag
>>e.cfm?Image=#urlencodedformat(main_jpeg)#&type=DVD&title=#urlen
>>codedformat(t
>>empPopTitle)#','236','335')"" onmouseover=""window.status='See 
>>Box Art';
>>return true "" onmouseout=""window.status=''"">
>>
>>
>>
>>Jacob
>>
>>
>>
>>-Original Message-
>>From: Jacob [mailto:[EMAIL PROTECTED]
>>Sent: Thursday, April 28, 2005 8:40 AM
>>To: CF-Talk
>>Subject: CFMX interrupting javascript
>>
>>
>>
>>I have a script that writes html files every so often.  Under 
>CF 5, the
>>
>>script took about 4 to 5 seconds to create the .htm file.
>>
>>
>>
>>When I tested the same script under CF MX 6.1, it takes over 
>>14 seconds.
>>
>>Same thing with CF MX 7.
>>
>>
>>
>>I went through the code, piece by piece and found out that if I have "
>>
>>javascript:" in the output for the cffile, it is slow (14 
>>seconds).  If I
>>
>>remove javascript:", the script runs in about 5 seconds.
>>
>>
>>
>>Is CFXM trying to interrupt javascript when it is writing a file?  Has
>>
>>anybody had this type of problem?
>>
>>
>>
>>TIA
>>
>>Jacob
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

oh, smells like a learning experience ;)

anybody else out there got a windows 2003 machine to try this on? 

>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 7:11 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>On my laptop...  Windows 2000 Server, IIS 5.0, CF MX 6.1 
>development edition
>..
>..
>..
>..
>..
>..
>
>78 ms
>
>Is it Friday yet???
>
>-Original Message-
>From: Kerry [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 9:56 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>and this:
>
>
>
>
>
>
>
>
>http://XX/DVD/"&trim(tmpURL)&">color=""Navy""
>style=""font-size: 15px;"">"&trim(tempTitle)&"  color=""Navy"" style=""font-size: 15px;"">DVD href=""javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
>ge.cfm?Image=
>"&urlencodedformat(main_jpeg)&"&type=DVD&title="&urlencodedform
>at(tempPopTit
>le)&"','236','335')"" onmouseover=""window.status='See Box 
>Art'; return true
>""
>onmouseout=""window.status=''"">src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>Art"" hspace=""4""
>vspace=""0"" border=""0"" align=""bottom"">">
>output="#line#">
>
>#gettickcount()-timer#
>
>took 67ms
>
>CFMX 6.1 + win2k + phat dev box under no load
>
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: 28 April 2005 16:46
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>
>This looped 50 times takes on average 1.2 to 1.4 seconds:
>
>
>
>addnewline="No"
>output="http://XX/DVD/#trim(URL)#"">style=""font-size: 15px;"">#trim(tempTitle)#  color=""Navy"" style=""font-size: 15px;"">DVD href=""javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
>ge.cfm?Image=
>#urlencodedformat(main_jpeg)#&type=DVD&title=#urlencodedformat(
>tempPopTitle)
>#','236','335')"" onmouseover=""window.status='See Box Art'; 
>return true ""
>onmouseout=""window.status=''"">src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>Art"" hspace=""4""
>vspace=""0"" border=""0"" align=""bottom"">">
>
>
>
>This looped 50 time takes .2 to .3 seconds:
>
>
>
>addnewline="No"
>output="http://XX/DVD/#trim(URL)#"">style=""font-size: 15px;"">#trim(tempTitle)#  color=""Navy"" style=""font-size: 15px;"">DVDsrc=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>Art"" hspace=""4""
>vspace=""0"" border=""0"" align=""bottom"">">
>
>
>
>This was removed from the second test.
>
>
>
>href=""javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
>w_Movies_Imag
>e.cfm?Image=#urlencodedformat(main_jpeg)#&type=DVD&title=#urlen
>codedformat(t
>empPopTitle)#','236','335')"" onmouseover=""window.status='See 
>Box Art';
>return true "" onmouseout=""window.status=''"">
>
>
>
>Jacob
>
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 8:40 AM
>To: CF-Talk
>Subject: CFMX interrupting javascript
>
>
>
>I have a script that writes html files every so often.  Under CF 5, the
>
>script took about 4 to 5 seconds to create the .htm file.
>
>
>
>When I tested the same script under CF MX 6.1, it takes over 
>14 seconds.
>
>Same thing with CF MX 7.
>
>
>
>I went through the code, piece by piece and found out that if I have "
>
>javascript:" in the output for the cffile, it is slow (14 
>seconds).  If I
>
>remove javascript:", the script runs in about 5 seconds.
>
>
>
>Is CFXM trying to interrupt javascript when it is writing a file?  Has
>
>anybody had this type of problem?
>
>
>
>TIA
>
>Jacob
>
>
>
>
>
>
>
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204959
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

my tests were on solaris, for what it's worth (no consistent marked
difference in execution times) 

>-Original Message-
>From: Kerry [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 7:11 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>im suspicious of win2k3, maybe the comment about AV was close 
>to the mark,
>but instead of AV being the culprit, its win2k3 not being happy about
>writing files to the system that contain script.
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: 28 April 2005 18:01
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>
>That took 4.7 seconds on my server.
>
>Maybe I am looking in the wrong direction...
>
>My server is Windows 2003 Server, IIS 6, CF MX 6.1, 2 GB RAM, DUAL 3.06
>Xeon.
>
>-Original Message-
>From: Kerry [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 9:49 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>Hmm, this:
>
>
>
>   http://domain.com/Show_Movies_
>Image.cfm,'23
>6','335')"" onmouseover=""window.status='See Box Art'; return true ""
>onmouseout=""window.status=''">
>
>
>#gettickcount()-timer#
>
>
>took 47ms on my server.
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: 28 April 2005 17:38
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>
>Here is something...
>
>This takes long (2+ seconds):
>
>http://ExcaliburFilms.com/Show
>_Movies_Image
>.cfm,'236','335')"" onmouseover=""window.status='See Box 
>Art'; return
>true
>"" onmouseout=""window.status=''""">
>
>
>This does not (.3 seconds): (I removed the "<" before the a href)
>
>http://ExcaliburFilms.com/Show
>_Movies_Image
>.cfm,'236','335')"" onmouseover=""window.status='See Box 
>Art'; return
>true
>"" onmouseout=""window.status=''""">
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 9:29 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>This takes about 2.2 to 2.5 seconds.
>
>
>http://domain.com/Show_Movies_
>Image.cfm,'23
>6','335')"" onmouseover=""window.status='See Box Art'; return true ""
>onmouseout=""window.status=''""">
>
>
>
>This takes .2 seconds. (Removed javascript, onmouseover, onmouseout and
>replaced with "X")
>
>
>http://domain.com/Show_Movies_Image.cfm
>,'236','335')
>"" X=""window.status='See Box Art'; return true "" 
>X=""window.status=''""">
>
>
>
>I have tried various combinations with javascript, onmouseover and
>onmouseout, but it speeds up only when I have all 3 removed.
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 9:13 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>I removed the urlencodedformat and I was still over 1 second.
>
>-Original Message-
>From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 9:06 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>you have two calls to function urlencodedformat:
>
>#urlencodedformat(main_jpeg)#
>#urlencodedformat(tempPopTitle)#
>
>could that have something to do with it?
>
>/t
>
>
>
>
>
>
>
>
>
>
>
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204957
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

i ran this a bunch of times :



http://domain.com/Show_Movies_Image.cfm
,'23
6','335')"" onmouseover=""window.status='See Box Art'; return
true ""
onmouseout=""window.status=''""">





http://domain.com/Show_Movies_Image.cfm,'236','3
35')
"" X=""window.status='See Box Art'; return true ""
X=""window.status=''""">





and didn't see any consistent difference in times...

/t 

>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 6:38 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>Here is something...
>
>This takes long (2+ seconds):
>
>http://ExcaliburFilms.com/Show
>_Movies_Image
>..cfm,'236','335')"" onmouseover=""window.status='See Box 
>Art'; return true
>"" onmouseout=""window.status=''""">
>
>
>This does not (.3 seconds): (I removed the "<" before the a href)
>
>http://ExcaliburFilms.com/Show
>_Movies_Image
>..cfm,'236','335')"" onmouseover=""window.status='See Box 
>Art'; return true
>"" onmouseout=""window.status=''""">
>
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 9:29 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>This takes about 2.2 to 2.5 seconds.
>
>
>http://domain.com/Show_Movies_
>Image.cfm,'23
>6','335')"" onmouseover=""window.status='See Box Art'; return true ""
>onmouseout=""window.status=''""">
>
>
>
>This takes .2 seconds. (Removed javascript, onmouseover, onmouseout and
>replaced with "X")
>
>
>http://domain.com/Show_Movies_Image.cfm
>,'236','335')
>"" X=""window.status='See Box Art'; return true "" 
>X=""window.status=''""">
>
>
>
>I have tried various combinations with javascript, onmouseover and
>onmouseout, but it speeds up only when I have all 3 removed.
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 9:13 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>I removed the urlencodedformat and I was still over 1 second.
>
>-Original Message-
>From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 9:06 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>you have two calls to function urlencodedformat:
>
>#urlencodedformat(main_jpeg)#
>#urlencodedformat(tempPopTitle)# 
>
>could that have something to do with it?
>
>/t
>
>
>
>
>
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204945
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

did you leave the variables (#main_jpeg# and #tempPopTitle#)?

can you try this:

http://XX/DVD/#trim(URL)#"">#trim(tempTitle)#  DVD http://XX/Show_Movies_Image.cfm?Image=
#urlencodedformat(main_jpeg)#&type=DVD&title=#urlencodedformat(tempPopTi
tle)
#','236','335')"" onmouseover=""window.status='See Box Art'; return true
""
onmouseout=""window.status=''"">http://XX/gif/excal2/Files_Icon.gif""; alt=""Box Art""
hspace=""4""
vspace=""0"" border=""0"" align=""bottom"">">

vs

http://XX/DVD/#trim(URL)#"">#trim(tempTitle)#  DVD http://XX/Show_Movies_Image.cfm?Im
age=
#urlencodedformat(main_jpeg)#&type=DVD&title=#urlencodedformat(tempPopTi
tle)
#','236','335')"" onmouseover=""window.status='See Box Art'; return true
""
onmouseout=""window.status=''"">http://XX/gif/excal2/Files_Icon.gif""; alt=""Box Art""
hspace=""4""
vspace=""0"" border=""0"" align=""bottom"">">

(ie just removed "javascript:" and nothing else)

/t


>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 6:13 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>I removed the urlencodedformat and I was still over 1 second.
>
>-Original Message-
>From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 9:06 AM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>you have two calls to function urlencodedformat:
>
>#urlencodedformat(main_jpeg)#
>#urlencodedformat(tempPopTitle)# 
>
>could that have something to do with it?
>
>/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204936
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFMX interrupting javascript - MORE

[RADEMAKERS Tanguy]

you have two calls to function urlencodedformat:

#urlencodedformat(main_jpeg)#
#urlencodedformat(tempPopTitle)# 

could that have something to do with it?

/t

>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 5:46 PM
>To: CF-Talk
>Subject: RE: CFMX interrupting javascript - MORE
>
>This looped 50 times takes on average 1.2 to 1.4 seconds:
>
> 
>
>addnewline="No"
>output="http://XX/DVD/#trim(URL)#"">style=""font-size: 15px;"">#trim(tempTitle)#  color=""Navy"" style=""font-size: 15px;"">DVD href=""javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
>ge.cfm?Image=
>#urlencodedformat(main_jpeg)#&type=DVD&title=#urlencodedformat(
>tempPopTitle)
>#','236','335')"" onmouseover=""window.status='See Box Art'; 
>return true ""
>onmouseout=""window.status=''"">src=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>Art"" hspace=""4""
>vspace=""0"" border=""0"" align=""bottom"">">
>
> 
>
>This looped 50 time takes .2 to .3 seconds:
>
> 
>
>addnewline="No"
>output="http://XX/DVD/#trim(URL)#"">style=""font-size: 15px;"">#trim(tempTitle)#  color=""Navy"" style=""font-size: 15px;"">DVDsrc=""http://XX/gif/excal2/Files_Icon.gif""; alt=""Box 
>Art"" hspace=""4""
>vspace=""0"" border=""0"" align=""bottom"">">
>
> 
>
>This was removed from the second test.
>
> 
>
>href=""javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
>w_Movies_Imag
>e.cfm?Image=#urlencodedformat(main_jpeg)#&type=DVD&title=#urlen
>codedformat(t
>empPopTitle)#','236','335')"" onmouseover=""window.status='See 
>Box Art';
>return true "" onmouseout=""window.status=''"">
>
> 
>
>Jacob
>
> 
>
>-Original Message-
>From: Jacob [mailto:[EMAIL PROTECTED] 
>Sent: Thursday, April 28, 2005 8:40 AM
>To: CF-Talk
>Subject: CFMX interrupting javascript
>
> 
>
>I have a script that writes html files every so often.  Under CF 5, the
>
>script took about 4 to 5 seconds to create the .htm file.
>
> 
>
>When I tested the same script under CF MX 6.1, it takes over 
>14 seconds.
>
>Same thing with CF MX 7.
>
> 
>
>I went through the code, piece by piece and found out that if I have "
>
>javascript:" in the output for the cffile, it is slow (14 
>seconds).  If I
>
>remove javascript:", the script runs in about 5 seconds.
>
> 
>
>Is CFXM trying to interrupt javascript when it is writing a file?  Has
>
>anybody had this type of problem?
>
> 
>
>TIA
>
>Jacob
>
> 
>
> 
>
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204932
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using Java Classes rather than CFC's?

[RADEMAKERS Tanguy]

Sean,

Thanks for the answer. 

Anybody else got third party jars in their server classpath? Sound off!

/t 

>-Original Message-
>From: Sean Corfield [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, April 26, 2005 12:10 AM
>To: CF-Talk
>Subject: Re: Using Java Classes rather than CFC's?
>
>On 4/25/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote:
>> Can you tell us if you have any extra jars in your server 
>classpath? I'm
>> especially interested in third party stuff rather than in house
>> utilities or suchlike.
>
>I don't know off the top of my head what's installed on our production
>app servers... I suspect we have quite a few third party JARs. I know
>we have the Fiorano MQ JMS message hub libraries installed. We may
>have some sort of payment / authorization service JARs for the Online
>Store, possibly some Google JARs for the search appliance... not sure
>what else. For the most part we write CFC wrappers around the Java
>stuff.
>
>We place stuff in {jrun.home}/servers/lib so it is available to both
>our CF code and our Java code (and available to every instance on the
>server).
>-- 
>Sean A Corfield -- http://corfield.org/
>Team Fusebox -- http://fusebox.org/
>Got Gmail? -- I have 50, yes 50, invites to give away!
>
>"If you're not annoying somebody, you're not really alive."
>-- Margaret Atwood
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204411
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using Java Classes rather than CFC's?

[RADEMAKERS Tanguy]

Hello Sean,

This thread has raised a couple of questions in my mind which i'd
appreciate your thoughts on. 

Can you tell us if you have any extra jars in your server classpath? I'm
especially interested in third party stuff rather than in house
utilities or suchlike.

Last year i worked on a hybrid cfmx/java project where the business
logic was in EJBs and the gui and front end controller was in
cfmx/fusebox3. The java guys made us some business delegates which we
wrapped in cfcs and the whole process was reasonably painless (although
we did have some looong "discussions" between the two ends of the room).
The reason i ask is that i was looking through the various jars in cfmx
- esp. the netcomponents jar - and i saw tasty looking objects for
interacting with nntp servers, network time servers, and other things of
that kind which aren't (yet?) exposed as cfml tags. This got me thinking
about a few other things i've looked at, specifically workflow
management frameworks written in java, which could come in very handy.
Since i guess you guys push the envelope of cf usage i thought you'd be
the person to ask.

Regs,
/t

>-Original Message-
>From: Sean Corfield [mailto:[EMAIL PROTECTED] 
>Sent: Monday, April 25, 2005 10:46 PM
>To: CF-Talk
>Subject: Re: Using Java Classes rather than CFC's?
>
>On 4/22/05, Bob Jacoby <[EMAIL PROTECTED]> wrote:
>> Let me state upfront that my primary background is in java 
>so I'll admit
>> to some bias... :)
>
>Let me state upfront that my primary backgrouund is in computer
>language design and compiler writing so I'll admit to some bias... :)
>
>> However, I'm
>> not as convinced with its ability to perform complex 
>business logic and
>> integrate with other systems.
>
>We use CFMX for pretty much all of our integration work because of its
>ability to handle, out-of-the-box, web services, XML parsing, various
>protocol handling (FTP, HTTP), JMS message handling, etc. CFMX 7 runs
>on all of our primary IT systems handling all of the messaging and
>interaction between them (mostly "headless", i.e., no web interface).
>It also powers fifty applications on macromedia.com handling up to
>40,000 concurrent sessions during morning peak traffic - there's some
>pretty complex business logic behind those applications.
>
>> While I like the concept of CFCs and think
>> it's a great addition they lack of some OO capabilities 
>(polymorphism,
>> overloading methods, etc) that limit what you can do with them.
>
>CFCs have polymorphism. Overloading is highly overrated (it's useful
>for library builders but causes a lot of problems for 'end user' style
>application developers - as someone who spent eight years on the
>ANSI/ISO C++ Standards Committees I can vouch for just how complex and
>confusing the rules behind overloading are: we had a dedicated team of
>language experts trying to formulate the rules and wording for
>overloading to remove ambiguity... and we weren't entirely
>successful).
>
>> ColdFusion, for all intensive purposes, is a procedural language.
>
>So is C but Bjarne did a pretty good job of adding classes to it and
>turning it into C++. Java is also a procedural language under the hood
>in many ways (all those built-in types not being classes leads to
>procedural code!). All OO languages need some procedural machinery and
>many of them have very strong procedural roots...
>
>> Bolting on some OO capabilities is nice, but I doubt it'll ever be a
>> true OO language, and many people, myself included, don't 
>want it to be.
>
>And what is a "true OO language" in your opinion? Smalltalk perhaps?
>It certainly isn't Java any more than it would be C++... :)
>
>> I think it'd add complexity to the point where CF becomes as 
>complex to
>> write as java.
>
>As a language designer I'd say you can have simple OO languages. The
>complexity of Java has very little to do with the fact that it is an
>OO language. There are a lot of complex bells and whistles in Java -
>and Java 5 only made that "worse" in many ways (especially introducing
>subtle implicit casting via autoboxing and the weird typesafe enum
>stuff). Don't get me wrong: I like Java well enough - I've been
>programming in it for eight years now - but it's lost a lot of its
>original simplicity!
>
>> Java is a beast
>> that takes quite a bit of time to learn and truly 
>understand, let alone
>> write decent code.
>
>Amen, brother!
>
>> I personally
>> hate the fact that CF doesn't support the concept of "null".
>
>JavaCast("null","") - see the docs:
>
>http://livedocs.macromedia.com/coldfusion/7/htmldocs/0542.htm
>
>> In the end it always comes down to using the right tool for the job.
>> And apply KISS. :)
>
>Amen to that too!
>-- 
>Sean A Corfield -- http://corfield.org/
>Team Fusebox -- http://fusebox.org/
>Got Gmail? -- I have 50, yes 50, invites to give away!
>
>"If you're not annoying somebody, you're not really alive."
>-- Margaret Atwood
>
>

~~

RE: Auto-login for trusted users

[RADEMAKERS Tanguy]

If it's an intranet and everybody is on windows and using IE, then
authenticate against NT login.
If it's an intranet and you have the time/money/infrastructure to handle
certificate management, then certs are a possibility. Warn the helpdesk.
Otherwise cookies are your best bet, but:
- make them secure cookies (only submitted over ssl)
- make them time out after a while (week, two weeks)
- implement two (or more) tier security so that some functions require
the user to type in a password (even|especially) if they were
automatically logged in.

my 0.02$
/t

>-Original Message-
>From: Connie DeCinko [mailto:[EMAIL PROTECTED] 
>Sent: Monday, April 25, 2005 10:27 PM
>To: CF-Talk
>Subject: Auto-login for trusted users
>
>I've got the opposite issue...  How can I provide an automatic 
>login for
>trusted users?  I know of several methods, but what are the 
>better ones?
>Cookie, cert, validate against NT login?
> 
> 
>Constanty "Connie" DeCinko III
>Web Architect, Webmaster, Web Developer
>Lone Jet Enterprises
>Glendale, Arizona
>  www.LoneJet.com
> 
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204355
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Script timing?

[RADEMAKERS Tanguy]

Hello Damien,

I use the following custom tag to time code blocks:

-start-









//make struct
EndTime = GetTickCount();
timeStruct = StructNew();
timeStruct.StartTime = StartTime;
timeStruct.EndTime = EndTime;
timeStruct.blockName = attributes.blockName;
timeStruct.time=#Evaluate(EndTime-StartTime)#;
ArrayAppend(request.timingarray,timeStruct);



-end---

call it as:

 CFML code here ...


and cfdump request.timingArray at the bottom of your page (or in
Onrequestend.cfm)

Regs,
/t

>-Original Message-
>From: Damien McKenna [mailto:[EMAIL PROTECTED] 
>Sent: Monday, April 25, 2005 8:47 PM
>To: CF-Talk
>Subject: Script timing?
>
>Is there any way to time how long portions of code take?  I've got a
>loop that seems to take forever and I want to see where the problem is.
>Thanks.
> 
>-- 
>Damien McKenna - Web Developer - [EMAIL PROTECTED]
> 
>The Limu Company - http://www.thelimucompany.com/
>  - 407-804-1014
>#include 
> 
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204330
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfrethrow question

[RADEMAKERS Tanguy]

can you post your cftry/cfcatch block so we can have a look? 

>-Original Message-
>From: Ken Dunnington [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, April 20, 2005 5:24 PM
>To: CF-Talk
>Subject: cfrethrow question
>
>I'm trying to update some error reporting on a site I did awhile ago.
>It's a fairly messy site, and I eventually plan on refactoring the
>whole thing, but for now I just want to get more concise error
>reporting. Right now, I have one particular block that is puzzling me.
>I have a cftry/cfcatch block with a call to an external payment
>gateway (via cfhttp) that has a bad habit of timing out. In the
>cfcatch block I have it email me with a dump of #cfcatch#. Now, we
>ALSO added an error page in Application.cfm that will email me with
>#error# and a few other variables. I am not getting the #cfcatch#
>email, and when the transaction times out, the email I get says that
>it was cfmail who timed out (but how did I get the email if cfmail
>timed out?!)
>
>Should I just get rid of the try/catch block? Should I use cfthrow or
>cfrethrow in the catch block to send the error up to the main error
>page? I've never really "gotten" cfrethrow, and I'm fairly sure I'm on
>the wrong track here, so any insight would be appreciated. :)
>
>- Ken
>
>-- 
>It's a metaphor for life itself. For that matter, everything in life
>is a metaphor for life. Except life. Life is probably a metaphor for
>metaphor. -- James Lileks
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54