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
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
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
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
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
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
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