For the moment, it seems caching that query helped. I'm not getting any errors.
I wish I'd seen that earlier.
Thanks for your help G..
-Jeff
> >Add cfdebug to your URL parameter and it will pop up the AJAX
> debugger.
> >
> >On Thu, Nov 20, 2008 at 5:51 PM, Jeff F <[EMAIL PROTECTED]>
> wrote:
> >
> >>
>
> Logs don't help. They just point to that getmodels.cfc.
>
> I'm wondering if my cfc is at fault. It's querying a rather large
> table. Possibly taking too long?? I'm going to add
> CachedWithin="#CreateTimeSpan(1,0,0,0)#" to see if that helps.
>
>
> <cffunction name="getmodels" access="remote" returnType="query">
> <cfset var data="">
> <cfquery name="data" datasource="#THIS.dsn#" >
> SELECT distinct model
> FROM #THIS.table#
> WHERE approved = <cfqueryPARAM value = "Y"
> CFSQLType = "CF_SQL_VARCHAR">
> ORDER BY model
> </cfquery>
> <cfreturn data>
> </cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315744
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
