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=thisiddoesnotexist&mode= > > 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-298BE097A2ED4769&mode= > > > > 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 > > 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 -------------------------------------------------------------
