More problems with hourly digests?
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
FW: More problems with hourly digests?
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
OT: what if the next CF...
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 dependencies on remote
Hourly Digests down again?
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
Hello Martin, select user_name, snip cfif fldCount LT listLen(fldList),/cfif!--- there must be a better way to do this --- 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?
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
RE: CF Studio Edits Not Being Saved?
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
HTML and digests
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: gt; have searched their Site and cannot find any step by step - links are showing up as a full html a tag: Visit A HREF=http://training.figleaf.com; target=_blankhttp://training.figleaf.com/A/ 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
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
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?
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 WebLogic
-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: BEA licenses BlueDragon for WebLogicr
-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 WebLogicr
-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=45587forumid=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: Asp calling ColdFusion
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?
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
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
-Original Message- Subject: Digital Signing a SOAP Request From: John Wilker [EMAIL PROTECTED] Date: Mon, 27 Feb 2006 15:48:07 -0700 snip 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. snip 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
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
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
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=44685forumid=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
-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
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=44075forumid=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
-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?
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
RE: Calling Oracle Stored Procedures from CF
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: cfquery name=selRandomQuestionIDs datasource=#datasourceName# BEGIN selRandomQuestionIDs(); END; /cfquery 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 cfstoredproc iso cfquery /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
Calling Oracle Stored Procedures from CF
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 cfstoredproc iso cfquery /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: MX7 CFHTTP : connection failure with Proxy
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 : CFHTTP METHOD=POST URL=http://cgiserver/cgi-bin/mro/perlFile.pl; proxyServer=myproxy result=strXMLFile cfhttpparam name=strOutputTo type=formfield value=Screen cfhttpparam name=strCurrentUrl type=formfield value=http://cfmServer/cfmFile.cfm; cfhttpparam name=strMasterDwgtype=formfield value=123445 cfhttpparam name=strMasterRevtype=formfield value=D cfhttpparam name=strDwgInRev type=formfield value=REVISION cfhttpparam name=strToolNumbers type=formfield value=123445 cfhttpparam name=strDwgServertype=formfield value=wwt cfhttpparam name=strOverlay type=formfield value=FALSE /CFHTTP 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
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=43478forumid=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 !---new primary key--- 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?
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: cfimport and application.cfm
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 cfimport prefix=\ui\ taglib=\/system/ui\ | xargs sed -i.bak -e 1icfimport prefix=\ui\ taglib=\/system/ui\ Execute from the root of your cf site. Will add cfimport prefix=ui\ taglib=/system/ui 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
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: script language=JavaScript!-- javascript:window.history.forward(1); //--/script /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
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?
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
IIRC, you need to look into the content-disposition header, iso the content-type one cfheader name=Content-Disposition value=attachment;filename=whatever_you_want.pdf /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=42580forumid=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
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
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
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
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
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: form validation utilizing database field types/sizes/etc
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=42228forumid=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: CF-Talk: Digest almost every hour
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
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=42115forumid=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
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=42114forumid=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
RE: CFMX6.1 on WebLogic 7, weird web services call error
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=42115forumid=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: Full server/database/schema/table name syntax for Oracle.
-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=42032forumid=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
anyone here from nmha.org?
-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 cf-talk@houseoffusion.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: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: [SOT] Finding which files in a site aren't used anymore
the first obvious gotcha i can see here is including files dynamically: cfloop index=afileName list=#aListOfFileNames# cfinclude template=#afileName#.cfm /cfloop 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=42023forumid=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
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=41987forumid=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 cfscript 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(); /cfscript = === 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...
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=41929forumid=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?
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
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=41882forumid=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
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=41851forumid=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
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=41839forumid=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!
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
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=41634forumid=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
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=41599forumid=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: retrieve ID from db insert
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=41103forumid=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: clearing connection pool/expiring connections
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=41145forumid=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
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 cftransaction isolation=serializable - 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=41103forumid=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
RE: retrieve ID from db insert
-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: Poor performing Oracle Query
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=41091forumid=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: 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: cfstoredproc procedure=insert_game datasource=[your_datasource_name] cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=fsnep_login value=#cookie.fsnep_login# null=No cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbvarname=g_list value=#form.g_list# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=budget value=#form.budget# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_month value=#form.the_month# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_num_people value=#form.the_num_people# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_weeks value=#form.the_weeks# null=No cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=newid /cfstoredproc and then do: cfcookie name=fsnep_bargain_hunt_gi_id value=#newid# /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=41103forumid=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: CFQUERY NAME=add_item DATASOURCE=esmart 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, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY 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
FW: CF-Talk: Digest every hour
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: cfstoredproc procedure=insert_game datasource=[your_datasource_name] cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=fsnep_login value=#cookie.fsnep_login# null=No cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbvarname=g_list value=#form.g_list# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=budget value=#form.budget# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_month value=#form.the_month# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_num_people value=#form.the_num_people# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_weeks value=#form.the_weeks# null=No cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=newid /cfstoredproc and then do: cfcookie name=fsnep_bargain_hunt_gi_id value=#newid# /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=41103forumid=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: CFQUERY NAME=add_item DATASOURCE=esmart 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, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY 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: reverse compliment a sequence
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=40706forumid=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 cfoutput#ReplaceList(ACTG,C,G,A,T,G,C,T,A)#/cfoutput 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
Well, i was going to suggest using cfoutput#ReplaceList(ACTG,C,G,A,T,G,C,T,A)#/cfoutput 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=40706forumid=4#209447 cfset dna = actg / cfset t = structNew() / cfset t.c = g / cfset t.c = c / cfset t.a = t / cfset t.t = a / cfset result = createObject(java, java.lang.StringBuffer) / cfloop from=1 to=#len(dna)# index=i cfset result.append(t[mid(dna, i, 1)]) / /cfloop cfoutput#result.toString()#/cfoutput 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
-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=40571forumid=4#209060 quote 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) /quote 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
-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=40571forumid=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: cfquery name=anonplsqltest datasource=trademak declare nextid number; begin select s.nextval into nextid from dual; end; /cfquery 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 cfquery name=anonplsqltest datasource=trademak declare nextid number; begin select s.nextval into nextid from dual; end; /cfquery doesn't throw an error. but it doesn't return anything either: cfdump var=#anonplsqltest# 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: session variables or multiple pages
By default, CF uses cookies to hold the session key, so you are running into the same basic problem. Solution is to use cfapplication ... setclientcookies=No 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=40614forumid=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
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 /cfstoredprocedure unless you use cftransaction. /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=40594forumid=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: Get New Record ID in ORACLE
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 /cfstoredproc 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 cftransaction 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
/cfstoredproc, 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 /cfstoredprocedure unless you use cftransaction.
/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
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=40571forumid=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 cfloop collection=#cgi# item=header cfquery name=baseinsert datasource=trademak insert into t (id,name) values(s.nextval,'#header#') /cfquery !--- sleeep --- cfset thread = createObject(java, java.lang.Thread) cfset thread.sleep(1) /cfloop 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 cfquery 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
RE: Get New Record ID in ORACLE
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=40571forumid=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: CF Google desktop search
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=40529forumid=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=entryentry=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
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: cfquery ... insert into foo (a,b,c,pk) values (A,B,C, mysequence.nextval) /cfquery /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=40571forumid=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: Get New Record ID in ORACLE
-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=40571forumid=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: cfquery name=nextval datasource=trademak select s.nextval into newid from dual /cfquery fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905: missing keyword This code: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery works just fine. So i am assuming that you insert a new row like this: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery 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
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=40571forumid=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
FW: Get New Record ID in ORACLE
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=40571forumid=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 cfquery 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
-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=40594forumid=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. snip 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
RE: Get New Record ID in ORACLE
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 cfloop collection=#cgi# item=header cfstoredproc procedure=t_insert datasource=trademak cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=newname value=#header# cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=myNewId /cfstoredproc cfoutput#myNewId#: #header#br/cfoutput /cfloop 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
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
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: cfoutputisNumeric(NaN)? - #isNumeric(NaN)#/cfoutput br cfoutputNaN gt 5? - #(NaN gt 5)#/cfoutput br br cfsetting myNumber = NaN... cfset myNumber = NaN br cfoutputisNumeric(myNumber)? - #isNumeric(myNumber)#/cfoutput br cfoutputmyNumber gt 5? - #(myNumber gt 5)#/cfoutput 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: cfif (not(isNumeric(myField)) or (myField gt ListGetAt(rule,2,:))) 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: Little OT but know one else to ask...
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: CF Error weirdness
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: detecting back button for page refresh
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---
HTML
BODY ONLOAD=handleBackButton()
FORM NAME=backtrack
INPUT TYPE=HIDDEN NAME=isBack VALUE=No
/FORM
SCRIPT LANGUAGE=JAVASCRIPT
!--//
var isBackDefault=No;
var isBack;
function handleBackButton(){
isBack = (isBackDefault != document.backtrack.isBack.value);
document.backtrack.isBack.value=Yes;
document.backtrack.isBack.defaultValue=Yes;
}
function isBackButtonUsed(){
return isBack;
}
--
/SCRIPT
form
input type=button value=how did I get here?
onclick=(isBackButtonUsed())? alert('Back button was used'):alert('Page
was loaded normally')
/form
/BODY
/HTML
-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: 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 ~| 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
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: 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
-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:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
ge.cfm?Image=
#urlencodedformat(main_jpeg)#type=DVDtitle=#urlencodedformat(
tempPopTitle)
#','236','335') onmouseover=window.status='See Box Art';
return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This looped 50 time takes .2 to .3 seconds:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/fontimg
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This was removed from the second test.
a
href=javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
w_Movies_Imag
e.cfm?Image=#urlencodedformat(main_jpeg)#type=DVDtitle=#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: CFMX interrupting javascript - MORE
did you leave the variables (#main_jpeg# and #tempPopTitle#)?
can you try this:
cffile action=append file=#trim(complete_filename)# addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=popupBoxArtDVD('http://XX/Show_Movies_Image.cfm?Image=
#urlencodedformat(main_jpeg)#type=DVDtitle=#urlencodedformat(tempPopTi
tle)
#','236','335') onmouseover=window.status='See Box Art'; return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box Art
hspace=4
vspace=0 border=0 align=bottom/a
vs
cffile action=append file=#trim(complete_filename)# addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Image.cfm?Im
age=
#urlencodedformat(main_jpeg)#type=DVDtitle=#urlencodedformat(tempPopTi
tle)
#','236','335') onmouseover=window.status='See Box Art'; return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box Art
hspace=4
vspace=0 border=0 align=bottom/a
(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
i ran this a bunch of times :
cf_timer blockname=withjavascript
cfloop index=i from=1 to=100
cffile action=append file=/tmp/java.htm addnewline=No
output=
a
ref=javascript:popupBoxArtDVD('http://domain.com/Show_Movies_Image.cfm
,'23
6','335') onmouseover=window.status='See Box Art'; return
true
onmouseout=window.status=''
/cfloop
/cf_timer
cf_timer blockname=withoutjavascript
cfloop index=i from=1 to=100
cffile action=append file=/tmp/java.htm addnewline=No
output=
a
ref=X:popupBoxArtDVD('http://domain.com/Show_Movies_Image.cfm,'236','3
35')
X=window.status='See Box Art'; return true
X=window.status=''
/cfloop
/cf_timer
cfdump var=#request.timingArray#
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):
cffile action=append file=d:\java.htm addnewline=No output=a
hrefjavascript:popupBoxArtDVD('http://ExcaliburFilms.com/Show
_Movies_Image
..cfm,'236','335') onmouseover=window.status='See Box
Art'; return true
onmouseout=window.status=''
/cfloop
This does not (.3 seconds): (I removed the before the a href)
cffile action=append file=d:\java.htm addnewline=No output=a
hrefjavascript:popupBoxArtDVD('http://ExcaliburFilms.com/Show
_Movies_Image
..cfm,'236','335') onmouseover=window.status='See Box
Art'; return true
onmouseout=window.status=''
/cfloop
-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.
cfloop index=i from=1 to=100
cffile action=append file=d:\java.htm addnewline=No output=
a
ref=javascript:popupBoxArtDVD('http://domain.com/Show_Movies_
Image.cfm,'23
6','335') onmouseover=window.status='See Box Art'; return true
onmouseout=window.status=''
/cfloop
This takes .2 seconds. (Removed javascript, onmouseover, onmouseout and
replaced with X)
cfloop index=i from=1 to=100
cffile action=append file=d:\java.htm addnewline=No output=
a
ref=X:popupBoxArtDVD('http://domain.com/Show_Movies_Image.cfm
,'236','335')
X=window.status='See Box Art'; return true
X=window.status=''
/cfloop
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
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:
cfset timer = gettickcount()
cfloop index=i from=1 to=100
cfset line = a
ref=javascript:popupBoxArtDVD('http://domain.com/Show_Movies_
Image.cfm,'23
6','335') onmouseover=window.status='See Box Art'; return true
onmouseout=window.status=''
cffile action=append file=d:\java.htm addnewline=No output=line
/cfloop
cfoutput#gettickcount()-timer#/cfoutput
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):
cffile action=append file=d:\java.htm addnewline=No output=a
hrefjavascript:popupBoxArtDVD('http://ExcaliburFilms.com/Show
_Movies_Image
.cfm,'236','335') onmouseover=window.status='See Box
Art'; return
true
onmouseout=window.status=''
/cfloop
This does not (.3 seconds): (I removed the before the a href)
cffile action=append file=d:\java.htm addnewline=No output=a
hrefjavascript:popupBoxArtDVD('http://ExcaliburFilms.com/Show
_Movies_Image
.cfm,'236','335') onmouseover=window.status='See Box
Art'; return
true
onmouseout=window.status=''
/cfloop
-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.
cfloop index=i from=1 to=100
cffile action=append file=d:\java.htm addnewline=No output=
a
ref=javascript:popupBoxArtDVD('http://domain.com/Show_Movies_
Image.cfm,'23
6','335') onmouseover=window.status='See Box Art'; return true
onmouseout=window.status=''
/cfloop
This takes .2 seconds. (Removed javascript, onmouseover, onmouseout and
replaced with X)
cfloop index=i from=1 to=100
cffile action=append file=d:\java.htm addnewline=No output=
a
ref=X:popupBoxArtDVD('http://domain.com/Show_Movies_Image.cfm
,'236','335')
X=window.status='See Box Art'; return true
X=window.status=''
/cfloop
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
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:
cfset timer = gettickcount()
cfloop index=i from=1 to=100
cfset tmpURL = www.mysite.com
cfset temptitle = hello
cfset temppoptitle = hello2
cfset main_jpeg = dot.gif
cfset line = a href=http://XX/DVD/trim(tmpURL)font
color=Navy
style=font-size: 15px;trim(tempTitle)/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
ge.cfm?Image=
urlencodedformat(main_jpeg)type=DVDtitle=urlencodedform
at(tempPopTit
le)','236','335') onmouseover=window.status='See Box
Art'; return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
cffile action=append file=d:\java.htm addnewline=No
output=#line#
/cfloop
cfoutput#gettickcount()-timer#/cfoutput
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:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
ge.cfm?Image=
#urlencodedformat(main_jpeg)#type=DVDtitle=#urlencodedformat(
tempPopTitle)
#','236','335') onmouseover=window.status='See Box Art';
return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This looped 50 time takes .2 to .3 seconds:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/fontimg
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This was removed from the second test.
a
href=javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
w_Movies_Imag
e.cfm?Image=#urlencodedformat(main_jpeg)#type=DVDtitle=#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
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:
cfset timer = gettickcount()
cfloop index=i from=1 to=100
cfset tmpURL = www.mysite.com
cfset temptitle = hello
cfset temppoptitle = hello2
cfset main_jpeg = dot.gif
cfset line = a href=http://XX/DVD/trim(tmpURL)font
color=Navy
style=font-size: 15px;trim(tempTitle)/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
ge.cfm?Image=
urlencodedformat(main_jpeg)type=DVDtitle=urlencodedform
at(tempPopTit
le)','236','335') onmouseover=window.status='See Box
Art'; return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
cffile action=append file=d:\java.htm addnewline=No
output=#line#
/cfloop
cfoutput#gettickcount()-timer#/cfoutput
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:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/font a
href=javascript:popupBoxArtDVD('http://XX/Show_Movies_Ima
ge.cfm?Image=
#urlencodedformat(main_jpeg)#type=DVDtitle=#urlencodedformat(
tempPopTitle)
#','236','335') onmouseover=window.status='See Box Art';
return true
onmouseout=window.status=''img
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This looped 50 time takes .2 to .3 seconds:
cffile action=append file=#trim(complete_filename)#
addnewline=No
output=a href=http://XX/DVD/#trim(URL)#font color=Navy
style=font-size: 15px;#trim(tempTitle)#/font/A nbsp;font
color=Navy style=font-size: 15px;DVD/fontimg
src=http://XX/gif/excal2/Files_Icon.gif; alt=Box
Art hspace=4
vspace=0 border=0 align=bottom/a
This was removed from the second test.
a
href=javascript:popupBoxArtDVD('http://ExcaliburFilms.com/Sho
w_Movies_Imag
e.cfm?Image=#urlencodedformat(main_jpeg)#type=DVDtitle=#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: Get file size on UNIX?
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: Get file size on UNIX?
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: Using Java Classes rather than CFC's?
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: Script timing?
Hello Damien, I use the following custom tag to time code blocks: -start- !--- timer custom tags to calculate the elapsed time --- cfswitch expression=#thistag.executionmode# cfcase value=start cfparam name=request.timingArray default=#ArrayNew(1)# cfparam name=attributes.blockName default=unnamed block CFSET StartTime = GetTickCount() /cfcase cfcase value=end cfscript //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); /cfscript /cfcase /cfswitch -end--- call it as: cf_timer blockname=fooBlock CFML code here ... /cf_timer 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] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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: Auto-login for trusted users
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 http://www.lonejet.com/ 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: Using Java Classes rather than CFC's?
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours
RE: cfrethrow question
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
