Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Earl, George
We need to be able to manually run scheduled tasks that take longer to complete than our server timeout setting. By 'manually run' I mean by entering the URL for a scheduled task into the address bar of our browser or by clicking on links to a scheduled task (because we have limited access to

Re: ColdFusion cfftp and a secure (SFTP) server.

2009-10-28 Thread Pete Freitag
On Tue, Oct 27, 2009 at 3:29 PM, Ian Skinner h...@ilsweb.com wrote: Can ColdFusion communicate with a SFTP server with it's cfftp... tag? Yes as of CF8, just add secure=true when you open the connection. Here's a simple example: cfftp action=open server=#server# connection=ftpSession

Re: GetHTTPRequestData().content bytearray

2009-10-28 Thread Pete Freitag
Hi Jessica, Try cfset xmlString = GetHTTPRequestData().content.toString(UTF-8) -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Oct 23, 2009 at 9:36 PM, Jessica Kennedy

Re: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread James Holmes
You could cfschedule a new single run of the template with the chosen timeout. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/28 Earl, George george.e...@ssa.gov: We need to be able to manually run scheduled tasks that take longer to complete than our

RE: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Robert Harrison
Add CFSETTING to the page to override the server time out... cfsetting requesttimeout=54000 !--- sets timeout limit to 15 hours --- Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022

Re: SQL Join help needed

2009-10-28 Thread daniel kessler
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on passport_listing_id) 2 - my original join that was working except i

Re: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Dave Watts
I understand that the timeout setting for scheduled tasks overrides the server timeout setting but I assume that works only when the task is run by the CF scheduler or by running it manually from within the CF Administrator, is this correct? Yes. When you run any CF URL directly, CF has no

RE: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Rick Faircloth
A couple of options come to mind... - use cfsetting requesttimeout = X on the task page before the code... that should override setting in administrator - that's the only way I can think of to override the administrator default - use cfthread to run your tasks in the browser - cfthread

re: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Jason Fisher
You can put requestTimeout=[seconds] right into the URL, IIRC. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: SQL Join help needed

2009-10-28 Thread daniel kessler
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on

Re: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Cameron Childress
On Wed, Oct 28, 2009 at 8:41 AM, Earl, George george.e...@ssa.gov wrote: If we run a scheduled task manually as described above is cfsetting\requestTimeout in the code our only recourse for overriding the server timeout setting? You can also drop it in the URL like

Re: SQL Join help needed

2009-10-28 Thread daniel kessler
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on

RE: SQL Join help needed

2009-10-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Daniel, You didn't post a link to the data. Steve -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Wednesday, October 28, 2009 8:47 AM To: cf-talk Subject: Re: SQL Join help needed OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id

Re: SQL Join help needed

2009-10-28 Thread daniel kessler
And here's the page with the data: http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 I seem to be having trouble posting today, so sorry if this shows up a bunch of times. ~| Want to reach the ColdFusion

RE: SQL Join help needed

2009-10-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Daniel, Try this: SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.fname) fname ,coalesce(b.lname, c.lname) lname

Re: Generating Documentation CF9

2009-10-28 Thread Jeremy Rottman
I have to have something setup wrong then. When I use the run.cfm below, it generates the documents, but they do not contain any of the information about the cfc's I have written. Here is my run.cfm cfscript colddoc = createObject(component, ColdDoc).init(); base =

RE: Scheduled tasks timeout vs. server timeout

2009-10-28 Thread Earl, George
I asked: If we run a scheduled task manually as described above is cfsetting\requestTimeout in the code our only recourse for overriding the server timeout setting? Thanks, everyone. We'll use ?requestTimeout=[seconds] appended to the URL for the scheduled task until we can get the

Re: SQL Join help needed

2009-10-28 Thread daniel kessler
Sorry about the multiple posts. I waited hours for the others to go through and they didn't, then all at once. That worked GREAT! Thank you very much. However, I don't really see any differences from my attempts and yours except that you did the joins on the FROM and I did it on the WHERE.

Re: Child Threads

2009-10-28 Thread Stefan Richter
Thanks Barney. What may be a good workaround for the child threads problem? Could I hit another CFM script via cfhttp from within my first thread and have tat CFM spawn another thread, or is that still consider a child thread then? Basically I have 2 or 3 long running processes (image

Re: Child Threads

2009-10-28 Thread Barney Boisvert
It sounds like that's a sequential-parallel process, not a parallel-parallel one? I.e. you have to convert the PDF to image before you can slice the image up, but you CAN post-process the images in parallel. Can you not do this (in psuedo-code) imageArray = pdfToImage(myPdf); threadArray = [];

Re: Generating Documentation CF9

2009-10-28 Thread Mark Mandel
Well since you told me that your folder structure starts with /com, and you are expandPath()'ing on /org... I'm not surprised ;o) Mark On Thu, Oct 29, 2009 at 3:43 AM, Jeremy Rottman rottm...@gmail.com wrote: I have to have something setup wrong then. When I use the run.cfm below, it

Re: Unable to load CFX C++ on CF 64 bit

2009-10-28 Thread Brad Roberts
Hi Jack, Did you ever find a solution for this? I'm getting the same error on our 64 bit box. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Unable to load CFX C++ on CF 64 bit

2009-10-28 Thread Rick Root
You can't take a C++ CFX tag from a 32 bit system and install it on a 64 bit system. You'll probably need to get a 64 bit version of the tag *OR* switch to something else. Rick On Wed, Oct 28, 2009 at 6:34 PM, Brad Roberts b...@agentblaze.com wrote: Hi Jack, Did you ever find a solution