Re: New Security Issue with CF

2013-01-05 Thread John M Bliss
Another: http://blogs.coldfusion.com/post.cfm/a-new-security-advisory-for-coldfusion-is-now-available On Fri, Jan 4, 2013 at 7:55 PM, Eric Bourland e...@ebwebwork.com wrote: Claude, thank you. That's really helpful information and gives me perspective. Eric -Original Message-

Re: cfquery results--memory resident?

2013-01-05 Thread Ben Conner
That's what I suspected. Much appreciated. --Ben On 1/4/2013 6:40 AM, Dave Watts wrote: A question came up recently with one of my client developers who is potentially returning a large # of rows from a query. The question was whether the result set is stored in memory or spooled to

Re: cfquery results--memory resident?

2013-01-05 Thread Russ Michaels
Actually there are ways to step through a result set using database functions so that you do bot store huge resultsets in memory, if you google it then you will find some examples. 2 simple solutions are. 1. Dont query all the data at all, instead provide a search form to get at specific

Re: Email attachment problem

2013-01-05 Thread Rob Voyle
Thanks Guys Does CFsleep pause the server, which would impact other users, or just the page. My prefernce would be for a page pause with hour glass indicating when the mail was sent, followed by a confirmation page. It seems though that the simplest ideal would be Russ' and set up a schedule to

Re: Email attachment problem

2013-01-05 Thread Dave Watts
Does CFsleep pause the server, which would impact other users, or just the page. It doesn't pause the entire server, but pausing the page does impact other users. CF has a set number of threads handling requests. You can control this number in the CF Admin. Whatever that number is set to,

Re: cfquery results--memory resident?

2013-01-05 Thread Claude Schnéegans
2. Only query the primary keys, and then loop over that list grabbing x records at a time and doing a new query to get all rows for those keys. This is a pretty good method. I tested it on a database containing about 45 records with a seach template. I give a very loose criterion on

Re: cfquery results--memory resident?

2013-01-05 Thread Russ Michaels
Glad it helped. Also dont forget u.can cache the original primary key query too. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Jan 5, 2013 10:39 PM, wrote: 2. Only query the primary keys, and then