Re: [ACFUG Discuss] HTML email generated by CF
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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Saxon Sent: Wednesday, September 05, 2007 3:11 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF I've had two cases with users and Outlook 2003. Others report no problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tepfer, Seth Sent: Wednesday, September 05, 2007 1:53 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF Is this happening consistently to all users of Outlook, or just to particular users? Outlook has the ability to turn off links in emails, though for the life of me I cannot find the checkbox. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Saxon Sent: Wednesday, September 05, 2007 1:43 PM To: ACFUG Subject: [ACFUG Discuss] HTML email generated by CF I realize that this is probably an Outlook/Microsoft issue but I've not been able to find a solution elsewhere, so I thought someone on this list might have an idea. Using CF, we generate an HTML email that ties to a calendar application. In a few random cases, users of Outlook 2003 report that they are unable to click the links in the email because hovering over the email link reveals outbind://83-011 Instead of the full URL as it does on other clients. Any ideas? Thanks, Rob - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] HTML email generated by CF
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 clients (I have only tested in Outlook 2003 in cached Exchange mode), the full URL must always be used for the HREF value. I suppose it could be a bug, I just have never thought to question it. shrug Troy Jones Dynapp Support Team 678-528-2952 _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Saxon Sent: Thursday, September 06, 2007 12:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF I have a BASE HREF=. with the rest of the absolute path. It seems to work in other clients. Is this a bug with Outlook 2003? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Momolu Sancea Sent: Thursday, September 06, 2007 9:35 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] HTML email generated by CF Troy is right, relative links will cause that problem. On 9/5/07, Dusty Hale [EMAIL PROTECTED] mailto:[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- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Rob Saxon Sent: Wednesday, September 05, 2007 3:11 PM To: discussion@acfug.org mailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF I've had two cases with users and Outlook 2003. Others report no problem. -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]On Behalf Of Tepfer, Seth Sent: Wednesday, September 05, 2007 1:53 PM To: discussion@acfug.org mailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] HTML email generated by CF Is this happening consistently to all users of Outlook, or just to particular users? Outlook has the ability to turn off links in emails, though for the life of me I cannot find the checkbox. -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Rob Saxon Sent: Wednesday, September 05, 2007 1:43 PM To: ACFUG Subject: [ACFUG Discuss] HTML email generated by CF I realize that this is probably an Outlook/Microsoft issue but I've not been able to find a solution elsewhere, so I thought someone on this list might have an idea. Using CF, we generate an HTML email that ties to a calendar application. In a few random cases, users of Outlook 2003 report that they are unable to click the links in the email because hovering over the email link reveals outbind://83-011 Instead of the full URL as it does on other clients. Any ideas? Thanks, Rob - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @
[ACFUG Discuss] Understanding application.cfc
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 others. I just started using application.cfc (vs application.cfm) so I'm wondering if I don't fully understand how this application file works. Anyone experienced this before? Any insight is greatly appreciated. Max Immelman Cell: (404) 409-6785 or txt/pic/vid [EMAIL PROTECTED] Skype: maxlegend http://www.JustRightBaskets.com - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Understanding application.cfc
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 the tree could include one in a higher-level directory. You refer to set session vars in the webroot application.cfc, but you don't say where -- or differentiate between creating the vars and setting them. Typically, you might set up a session structure in the onSessionStart method. But depending on what you intend to keep in the session scope, actually setting the values is generally done elsewhere. If this hasn't answered your question well enough, maybe you could share some code so we can see better what you're trying to do. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance with Page Explosion
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 is what I think is going on. It's pretty certain that it's the latter: no TITLE. Otherwise, the error message would refer to the lack of an EVENT. But EVENT could simply be an empty struct. Since the code you included doesn't go into how the EVENT is retrieved (it's just getEvent() or getNextEvent()), there's no way for us to know exactly what's up. Could you try dumping the EVENT object to see if the TITLE is always there? I'm guessing that the event.title variable is the first instance of an EVENT attribute within the page. You could try commenting it out and see if the error occurs again, this time with a reference to whatever the next EVENT property referenced in the page is. What seems most likely is that getEvent() is not returning the struct you're expecting. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance with Page Explosion
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 event = QueryNew(title) cfset event.title = No Event Found But, again, that seems very hacky. I did get this to happen (once) by removing the id parameter from the url: That means that getNextEvent() could be my problem. The getNextEvent method is trying to get the next event from now out of the database: cffunction name=getNextEvent access=public maxrows=1 returnType=query output=false hint=Gets the next event by date cfquery name=q datasource=#instance.dsn# username=#instance.username# password=#instance.password# select* fromugevents where eventstart = cfqueryparam value=#Now()# cfsqltype=CF_SQL_TIMESTAMP LIMIT 1 /cfquery cfreturn q /cffunction I have to assume that my SQL for this could be way off. I'll try a dump, too. Thanks. Leif On 9/6/07, Tom McNeer [EMAIL PROTECTED] wrote: It's pretty certain that it's the latter: no TITLE. Otherwise, the error message would refer to the lack of an EVENT. But EVENT could simply be an empty struct. - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Running a system command from ColdFusion
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 Development
NIEHS ITSS Contractor
Lockheed Martin Information Technology
919-361-5444 ext 311
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 4:21 PM
To: discussion@acfug.org
Subject: re: [ACFUG Discuss] Running a system command from ColdFusion
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)
Mischa
Uppelschoten ext
10 To
Mischa.Uppelsch Web Site discussion@acfug.org
[EMAIL PROTECTED]cc
m
Sent by: Subject
[EMAIL PROTECTED] re: [ACFUG Discuss] Running a
system command from ColdFusion
09/06/2007 04:17
PM
Please respond
to
[EMAIL PROTECTED]
.org
: 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 @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
re: [ACFUG Discuss] Running a system command from ColdFusion
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)
Mischa
Uppelschoten ext
10 To
Mischa.Uppelsch Web Site discussion@acfug.org
[EMAIL PROTECTED]cc
m
Sent by: Subject
[EMAIL PROTECTED] re: [ACFUG Discuss] Running a
system command from ColdFusion
09/06/2007 04:17
PM
Please respond
to
[EMAIL PROTECTED]
.org
: 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 @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
re: [ACFUG Discuss] Running a system command from ColdFusion
: 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 @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
[ACFUG Discuss] Running a system command from ColdFusion
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 command.
I tried this:
cfset variables.plsql = exec DBMS_WM.GoToWorkspace('edsWorkspace')
cfquery name=gotoWorkspace datasource=emstraining.1
#variables.plsql#
/cfquery
and I get an invalid SQL statement error. Anyone know if this can be
done, and how?
Thanks!
--
Ed Szwedo
Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955 (Voice)
919-685-3395 (Fax)
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
RE: [ACFUG Discuss] Running a system command from ColdFusion
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
you update the row to edsWorkspace, the trigger executes the dbms_wm
procedure.
...I'll have to do some research on this, but I think you might can set
the default workspace based on the oracle user and so if your CF DSN
user is x then the workspace will be 1 and when the dsn user is y then
the workspace could be 2.
hth.
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 4:10 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Running a system command from ColdFusion
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 command.
I tried this:
cfset variables.plsql = exec DBMS_WM.GoToWorkspace('edsWorkspace')
cfquery name=gotoWorkspace datasource=emstraining.1
#variables.plsql# /cfquery
and I get an invalid SQL statement error. Anyone know if this can be
done, and how?
Thanks!
--
Ed Szwedo
Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955 (Voice)
919-685-3395 (Fax)
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
Re: [ACFUG Discuss] Assistance with Page Explosion
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 hint=Gets the next event by date cfquery name=q datasource=#instance.dsn# username=#instance.username# password=#instance.password# Be sure to always var scope variables in a function. After the opening cffunction tag, you need: cfset var q = / -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance with Page Explosion
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 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 event = QueryNew(title) cfset event.title = No Event Found But, again, that seems very hacky. I did get this to happen (once) by removing the id parameter from the url: That means that getNextEvent() could be my problem. The getNextEvent method is trying to get the next event from now out of the database: cffunction name=getNextEvent access=public maxrows=1 returnType=query output=false hint=Gets the next event by date cfquery name=q datasource=#instance.dsn# username=#instance.username# password=#instance.password# select* fromugevents where eventstart = cfqueryparam value=#Now()# cfsqltype=CF_SQL_TIMESTAMP LIMIT 1 /cfquery cfreturn q /cffunction I have to assume that my SQL for this could be way off. I'll try a dump, too. Thanks. Leif On 9/6/07, Tom McNeer [EMAIL PROTECTED] wrote: It's pretty certain that it's the latter: no TITLE. Otherwise, the error message would refer to the lack of an EVENT. But EVENT could simply be an empty struct. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance with Page Explosion
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 too? Ugh. I believe that my hack has prevented the condition for now, as I am not getting errors every hour. We'll see if that holds up. Leif On 9/6/07, bananachunks [EMAIL PROTECTED] wrote: 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 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 event = QueryNew(title) cfset event.title = No Event Found But, again, that seems very hacky. I did get this to happen (once) by removing the id parameter from the url: That means that getNextEvent() could be my problem. The getNextEvent method is trying to get the next event from now out of the database: cffunction name=getNextEvent access=public maxrows=1 returnType=query output=false hint=Gets the next event by date cfquery name=q datasource=#instance.dsn# username=#instance.username# password=#instance.password# select* fromugevents where eventstart = cfqueryparam value=#Now()# cfsqltype=CF_SQL_TIMESTAMP LIMIT 1 /cfquery cfreturn q /cffunction I have to assume that my SQL for this could be way off. I'll try a dump, too. Thanks. Leif On 9/6/07, Tom McNeer [EMAIL PROTECTED] wrote: It's pretty certain that it's the latter: no TITLE. Otherwise, the error message would refer to the lack of an EVENT. But EVENT could simply be an empty struct. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance with Page Explosion
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 come from those. You can make the error do away by assigning a default title like this just before the cfmodule tag, but that might just uncover another error: cfscript s = structNew(); s.title = 'Default Title'; structAppend(event, s, false); /cfscript !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# Lastly, is this something you are observing directly or something you are seeing in logs or from complaining members? If you aren't observing this directly you may find even more debugging information by tossing a try/catch around the cfmodule and emailing yourself more information about the error when it occurs. Knowing what URL was passed in may help you debug. You'd do that like this: cftry !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# cfcatch cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Whoops - something broke type=html cfdump=#url#cfdump=#cgi#/cfmail /cfcatch /cftry That code should email you a dump of the URL variables in case a malformed URL is causing it - and the CGI scope in case a bot or crawler is causing it. -Cameron On 9/6/07, Leif Wells [EMAIL PROTECTED] wrote: All, As some of you may know, I am not a full time ColdFusion developer, but sharing this problem may result in some public humiliation for me as I am not well versed in ColdFusion best practices. I have an important page on the Adobe User Group of Atlanta and Adobe Flash Platform User Group of Atlanta sites that is exploding on me and I do not know why. The site itself is basically an extension of Ray Camden's BlogCFC that I created earlier this year to assist in running the groups. The page that is causing the problem is: http://www.afpugatlanta.org/ug/event.cfm?id=659B534A-1372-FB90-298BE097A2ED4769mode= The error message I am getting (intermittently) is: Element TITLE is undefined in EVENT. Which references this line of code: !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# 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 is what I think is going on. Let me share with you the top of the file so you can see if there is something I am doing wrong (I am pretty sure that you'll find different things wrong, and although constructive criticism is welcomed, I really need to slove this problem): cfsetting enablecfoutputonly=true cfprocessingdirective pageencoding=utf-8 cfset presenter1 = cfset presenter2 = cfset headerimagename = default !--- cfif url.mode is not cfset mode = url.mode cfelse cfset mode = /cfif --- !--- TODO: Create functionality for two sponsors --- cftry cfif StructKeyExists(url, id) cfset event = application.blog.getEvent(url.id) cfelse cfset event = application.blog.getNextEvent() /cfif cfset location = application.blog.getLocation(event.locationfk) cfif event.presenter1fk NEQ cfset presenter1 = application.blog.getPresenter(event.presenter1fk) /cfif cfif event.presenter2fk NEQ cfset presenter2 = application.blog.getPresenter(event.presenter2fk) /cfif cfset sponsor1 = application.blog.getEventSponsor(event.sponsor1fk) cfif FileExists(ExpandPath(#application.imageroot# mailer/header_ #DateFormat(event.eventstart , mmddyy)# .jpg)) cfset headerimagename = #DateFormat(event.eventstart, mmddyy)# /cfif cfcatch /cfcatch /cftry I hope someone can assist me with this. Thanks in advance for reviewing my stuff. Let me know if more information is required. Leif Leif Wells Manager, Adobe User Group of Atlanta http://www.augatlanta.org/ Manager, Adobe Flash Platform User Group of Atlanta http://www.afpugatlanta.org/ [EMAIL PROTECTED] - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform
Re: [ACFUG Discuss] Assistance with Page Explosion
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 bothers me the most about that change is the fact that the AUGAtlanta site had the same exact code on it as the AFPUGAtlanta site, but the AFPUGAtlanta site was the one that kept kicking up the error. It makes me think that there may have been an underlying SQL problem or MySQL problem. As for how I was seeing the error, Ray's BlogCFC, the software my code is extending, has a site error catcher that sends me an email to me when there are errors. Even so, I was probably the one who kept hitting the error the most. Thanks, again, to you and Tom for taking a look at my problem. Leif On 9/6/07, Cameron Childress [EMAIL PROTECTED] wrote: 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 come from those. You can make the error do away by assigning a default title like this just before the cfmodule tag, but that might just uncover another error: cfscript s = structNew(); s.title = 'Default Title'; structAppend(event, s, false); /cfscript !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# Lastly, is this something you are observing directly or something you are seeing in logs or from complaining members? If you aren't observing this directly you may find even more debugging information by tossing a try/catch around the cfmodule and emailing yourself more information about the error when it occurs. Knowing what URL was passed in may help you debug. You'd do that like this: cftry !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# cfcatch cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Whoops - something broke type=html cfdump=#url#cfdump=#cgi#/cfmail /cfcatch /cftry That code should email you a dump of the URL variables in case a malformed URL is causing it - and the CGI scope in case a bot or crawler is causing it. -Cameron On 9/6/07, Leif Wells [EMAIL PROTECTED] wrote: All, As some of you may know, I am not a full time ColdFusion developer, but sharing this problem may result in some public humiliation for me as I am not well versed in ColdFusion best practices. I have an important page on the Adobe User Group of Atlanta and Adobe Flash Platform User Group of Atlanta sites that is exploding on me and I do not know why. The site itself is basically an extension of Ray Camden's BlogCFC that I created earlier this year to assist in running the groups. The page that is causing the problem is: http://www.afpugatlanta.org/ug/event.cfm?id=659B534A-1372-FB90-298BE097A2ED4769mode= The error message I am getting (intermittently) is: Element TITLE is undefined in EVENT. Which references this line of code: !--- Call layout custom tag. --- cfmodule template=../tags/layout.cfm title=#event.title# 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 is what I think is going on. Let me share with you the top of the file so you can see if there is something I am doing wrong (I am pretty sure that you'll find different things wrong, and although constructive criticism is welcomed, I really need to slove this problem): cfsetting enablecfoutputonly=true cfprocessingdirective pageencoding=utf-8 cfset presenter1 = cfset presenter2 = cfset headerimagename = default !--- cfif url.mode is not cfset mode = url.mode cfelse cfset mode = /cfif --- !--- TODO: Create functionality for two sponsors --- cftry cfif StructKeyExists(url, id) cfset event = application.blog.getEvent(url.id) cfelse cfset event = application.blog.getNextEvent() /cfif cfset location = application.blog.getLocation(event.locationfk) cfif event.presenter1fk NEQ cfset presenter1 = application.blog.getPresenter(event.presenter1fk) /cfif cfif event.presenter2fk NEQ cfset presenter2 = application.blog.getPresenter(event.presenter2fk) /cfif cfset sponsor1 = application.blog.getEventSponsor(event.sponsor1fk) cfif FileExists(ExpandPath(#application.imageroot# mailer/header_ #DateFormat(event.eventstart , mmddyy)# .jpg)) cfset headerimagename = #DateFormat(event.eventstart, mmddyy)# /cfif cfcatch /cfcatch /cftry I hope someone can assist me with this.
RE: [ACFUG Discuss] Understanding application.cfc
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 are tied to applications, that could explain your problem. If you were thinking that somehow the use of application.cfc overrides use of application.cfm, that is true, but only if they're both in the SAME directory. Hope that's it for you. /charlie _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Immelman Sent: Thursday, September 06, 2007 2:33 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Understanding application.cfc 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 others. I just started using application.cfc (vs application.cfm) so I'm wondering if I don't fully understand how this application file works. Anyone experienced this before? Any insight is greatly appreciated. Max Immelman Cell: (404) 409-6785 or txt/pic/vid mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Skype: maxlegend http://www.JustRightBaskets.com http://www.JustRightBaskets.com - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
