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