Re: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Derrick Peavy
Ajas: I am not an expert on how CF actually executes, but I am pretty darn sure that the assumption you have is wrong. cfoutputgetSomething.col1 br / getSomething.col2 br / getSomething.col3 br / /cfoutput Is not re-executing the query. Once the query is run once, assuming the query is

Re: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Ajas Mohammed
Thanks Teddy and Derrick. Good to know that I was wrong in my assumption. I felt cfoutputgetSomething.col1 br / getSomething.col2 br / getSomething.col3 br / /cfoutput is an overkill but apparently not. Thanks, Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be,

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
Ajas, given your experience with CF, I'm a little confused how to reply. If this was a brand new user, I'd say that they have things backward and even then still misunderstood. First, the main difference is that the code in blue would execute once for each query result, whereas the code in red

RE: [ACFUG Discuss] cfdocument error

2010-02-04 Thread Charlie Arehart
Is this 8.01, Howard? Since you refer to images, if you may be processing them with CFIMAGE, there's a hotfix for image processing specifically related to problems with the resulting files, and it may be connected to your problem. See: http://kb2.adobe.com/cps/403/kb403411.html And note that

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
I offered my reply before seeing yours here, Derrick. Doh. But thanks for the confidence that I'd have something to offer. :-) As to your last point, I don't know. I mean, sure, those who move to more OO-like development will tend to consider options where query results are generated in a CFC

[ACFUG Discuss] Dealing With Spiders/Bots/Crawlers

2010-02-04 Thread Bob Hendren
I'm at an odd crossroads here. Up until now, I've kept my application off-limits to search engines. I've used a couple of techniques found on Ben Nadel's blog for giving them short sessions and such. Been working well. With respect to human users, I've been VERY diligent about using

Re: [ACFUG Discuss] cfdocument error

2010-02-04 Thread Frank
I've experienced a few cfdocument errors in the past... There are two things you can try that have helped me. One is to increase the heap size of the JVM that runs CF. If you have a complex document or one with multiple images, it can easily run out of space. The other is to move all the

RE: [ACFUG Discuss] cfdocument error

2010-02-04 Thread Wes Byrd
Ah... well, that explains my issues as well. I installed CF8.01 on a 64 bit server and applied the cumulative hot fix #4 thinking it was cumulative. I see however that the hot fix #71557 (CFImage and Image functions update) was not included in the Cumulative Hot Fix 4

RE: [ACFUG Discuss] cfdocument error

2010-02-04 Thread Troy Jones
In fact, yes, I have and currently am. I'd love to see an answer to this too. [cid:image001.jpg@01CAA4DB.5C2A7580] ___ Troy Jones | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext.

Re: [ACFUG Discuss] a very strange sql error that only happens when using CF

2010-02-04 Thread Dusty Hale
I did end up re doing the entire query in a cfquery tag instead of the connection string. I also used the queryparam tags like below. Seems to have resolved the error and hopefully prevents SQL injection too. Thanks On Wed, Jan 27, 2010 at 5:30 PM, Teddy R. Payne teddyrpa...@gmail.comwrote:

[ACFUG Discuss] getPageContext() and low-level internals

2010-02-04 Thread Clarke Bishop
Has anyone here ever used getPageContext() to get the low-level specifics of an HTTP request? Some of the CFWheels guys need to use this to extend the framework. This works for normal form submissions: getPageContext().getRequest().getParameterMap() But, it just returns null for

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
Wow, I had sent this a long time before it arrived (sent at 10:12) well before Ajas replied to Derrick and Teddy. Sorry. Don't know why it got held up (as did a few messages of mine to the list, which all arrived around 12). Odd. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On