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 http://www.fusionlink.com
-------------------------------------------------------------
