Re: [ACFUG Discuss] HTML email generated by CF

2007-09-06 Thread Momolu Sancea
Troy is right, relative links will cause that problem. On 9/5/07, Dusty Hale [EMAIL PROTECTED] wrote: I use outlook 2003 and by default it turns links off for security unless the sender is on the junk email safe list. Don't know if this info helps you? Dusty -Original Message-

RE: [ACFUG Discuss] HTML email generated by CF

2007-09-06 Thread Rob Saxon
Thanks, Troy. I'll test it and see. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Troy Jones Sent: Thursday, September 06, 2007 1:07 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF While I am unsure of other mail

[ACFUG Discuss] Understanding application.cfc

2007-09-06 Thread Max Immelman
If I set session vars in the webroot application.cfc (only 1 used across entire website), are these session vars available to every folder off the root? I'm having issues accessing session vars across an entire website. Available to some folders (and their sub folders) but unavailable to

Re: [ACFUG Discuss] Understanding application.cfc

2007-09-06 Thread Tom McNeer
Max, Application.cfc (the cap A is recommended, by the way) works the same as application.cfm, in that when CF processes a request, it looks up the directory tree until it finds an Application.cfc. You can include one Application.cfc inside another, however, so an Application.cfc lower down in

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Tom McNeer
Leif, On 9/6/07, Leif Wells [EMAIL PROTECTED] wrote: The error message I am getting (intermittently) is: Element TITLE is undefined in EVENT. Obviously, this means that somehow either the event object is not getting created or that there is no title property in the object. Or at least that

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Leif Wells
Thanks, Tom, for confirming what I was thinking. The thing that is driving me crazy is that this is a very intermittent error. I can not seem to get it to occur consistently no matter what I try. Right now I am trying a hack locally at the top of the page to avoid the problem alltogether: cfset

RE: [ACFUG Discuss] Running a system command from ColdFusion

2007-09-06 Thread Gurevich, Gerry (NIH/NIEHS) [C]
Is this something you could run from a command line? If so, then you can set it all up in a batch file to trigger it and also direct output to another file (maybe). Then you would use cfexecute to kick off the batch file. Gerry Gurevich Application

re: [ACFUG Discuss] Running a system command from ColdFusion

2007-09-06 Thread Szwedo . Ed
Worth a shot, but no. Same error. I'm pretty sure it's choking on the Exec keyword. ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-685-3395 (Fax)

re: [ACFUG Discuss] Running a system command from ColdFusion

2007-09-06 Thread Mischa Uppelschoten ext 10
: cfset variables.plsql = exec DBMS_WM.GoToWorkspace('edsWorkspace') SWAG: throw in a PreserveSingleQuotes? /m - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @

[ACFUG Discuss] Running a system command from ColdFusion

2007-09-06 Thread Szwedo . Ed
I would like to run an Oracle system command from ColdFusion. My research revealed a way to execute PL/SQL with a cfset tag as shown below. cfset variables.plsql = declare x number; begin := 0; end; cfquery name=q datasource=yourDSN #variables.plsql# /cfquery But I need to run an exec

RE: [ACFUG Discuss] Running a system command from ColdFusion

2007-09-06 Thread Fennell, Mark P.
Why cfstoredproc no worky on this? If we must kludge ...try execute immediate dbms_wm.gotoworkspace('x') ...using cfexecute to run a shell script or bat file that runs sqlplus, connects, execs the command and exits sqlplus. ...create a trigger on a table that is one column and one row and when

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Tom McNeer
Lief, You should definitely spin up a test page that calls both methods and dump the results to see what's up. I don't see a problem with your SQL right off. The one thing I do see is: cffunction name=getNextEvent access=public maxrows=1 returnType=query output=false

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread bananachunks
What happens if there are NO upcoming events. The query returns 0 records, thus no event.title gets created, but is then called there after. Just a guess. On 9/6/07, Leif Wells [EMAIL PROTECTED] wrote: Thanks, Tom, for confirming what I was thinking. The thing that is driving me crazy is

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Leif Wells
Yeah, I've been looking at that, but I don't see that there is a way right now for no events to be found (as I have events in the database that are this month, thus should be found). Perhaps the problem lies in a break down in communication with the database? But wouldn't I get an error there

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Cameron Childress
Leif, are you catching the errors? I can generate an error page by altering the id int he URL to be a bad id: http://www.afpugatlanta.org/ug/event.cfm?id=thisiddoesnotexistmode= I'm pretty sure the error is going to be in (or casued by) one of the CFC's you are calling, since the event seems to

Re: [ACFUG Discuss] Assistance with Page Explosion

2007-09-06 Thread Leif Wells
Thanks, Cameron, for your advice and for returning to Atlanta. I, for one, missed you. I added a QueryNew() to the mix like the StructNew() you have suggested below. I believe that has resolved the problem for now, as I have not received an error since uploading the change. The thing that

RE: [ACFUG Discuss] Understanding application.cfc

2007-09-06 Thread Charlie Arehart
Max, it works just like application.cfm, so if there was only one in a root dir, that should apply to all subdirs. But I say, *should*, because if there is an application.cfm in a directory, that will create a new application scope for that directory and its subdirectories. And since session vars