oddness! I do not see the original post of this thread, only the reply. Maybe the server is hanging out at CFUnited :( lol CF uses three pieces of information to identify a cached query. 1) the name attribute in CFQUERY 2) the datasource attribute in CFQUERY 3) the SQL as Isaac mentioned, could be something else you are caching or the SQL is not actually changing.
DK On 6/30/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > > I've set this up on our site and I've noticed some weird > > behaviour with it. > > > (*) Users performing different queries are getting the > > same results. ( Ie. I do a search for 'c++' which returns > > 100 records. Another user does an any any search and gets > > back the same records. ( btw the any any should return in > > the 2000+ range ). > > > I thought the cachedwithin only ran on queries that were > > identical, it seems to be running the cached query > > everytime the search is processed and ignoring the fact > > that the searches are different. > > That's the way it's designed... Check the debugging output to make > sure CF is executing different sql syntax and make sure you're not > using any other caching methods around/for the html content. I believe > <cfcache> for instance might cause this sort of behavior if it's > mis-implemented. (Although I'll admit I haven't implemented it myself, > so I'm guessing based on what I know of it.) > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
