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 *
> > from ugevents
> > 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
-------------------------------------------------------------
