Log That Keeps Track of Scheduled Tasks

2010-12-10 Thread Asaf Peleg
Hi, I'm using CF8 and I have several scheduled tasks that run. I'm investigating an issue that looks like the scheduler sometimes fails to execute files. I'm making this assumption b/c the application.log didn't record any errors and I didn't get an email from my tasks that it failed (I

Restricting CFM file access

2010-10-01 Thread Asaf Peleg
Hi, I have a ColdFusion server running over IIS on a Win2k3 machine and I wanted to know how to restrict someone from running a CFM file unless it is executed locally or within my firewall. For instance, imagine someone executes http://mywebsite.com/test.cfm in their browser. Is there

Re: Restricting CFM file access

2010-10-01 Thread Asaf Peleg
Thanks Everyone, I appreciate the quick responses. Regards, Asaf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive:

cfstoredproc timeout

2010-04-29 Thread Asaf Peleg
Hi, I want to limit the total execution time of a stored procedure being called from Coldfusion using cfstoredproc to 90 seconds. With cfquery there is a parameter timeout, but there is no equivalent in cfstoredproc. Can anyone think of an alternative to accomplishing this. The trick is,

Re: Strange Behavior Between ColdFusion Database

2009-11-05 Thread Asaf Peleg
Hi Guys, Thanks for all your advice. It turns out what I thought was the cause of the problem was just a red herring. This query was joining on a few tables and recently one of the tables it was joining on had grown two or three fold causing the result set of the query to grow exponentially.

Issue with cfcontent,cfheader and SSL and IE

2009-11-05 Thread Asaf Peleg
Hi everyone, We recently purchased a SSL certificate for our website and we are not experiencing an issue with downloading dynamically generated xls, csv files we generate as reports for our clients when using IE. The issue does not happen at all in Firefox, only IE. I have posted an

Strange Behavior Between ColdFusion Database

2009-11-04 Thread Asaf Peleg
Hi Everyone, I am running ColdFusion 8 with SQL Server 2005. I recently decided to take a direct query against the database and simply move it into a stored procedure instead. So before I was doing a cfquery I am now doing a cfstoredproc instead. After I made the change, I logged onto my

Re: Issues using CFHTTP

2009-10-22 Thread Asaf Peleg
Thanks Barney, This definitely sent me down the right path. Appreciate the input. Thanks, Asaf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Issues using CFHTTP

2009-10-21 Thread Asaf Peleg
Hi everyone, My websites has different types of profiles that our end users log into that follows a simply hierarchy that goes as follows. Administrator - Super Users - End Users Where all Super Users are managed by the Administrator and each Super User manages a subset of all End Users.

Dynamic External Javascript Sheet

2009-08-03 Thread Asaf Peleg
I'm looking for a way to attach an external javascript sheet that includes dynamic coldfusion code. Obviously, a ColdFusion file must end with the .cfm extension to be processed by the server and as I have found out through research an external javascript sheets needs to end with a .js

ColdFusion Report Builder and Excel Output

2009-07-08 Thread Asaf Peleg
Hello, I've recently been messing around with ColdFusion Report Builder because of it's ability to easily output the report in different formats. To my dismay, reports that look good in PDF HTML get formatted very poorly in excel. Data gets pushed into non-sequential cells and cell