even whitespace inside sql statement must be the same! so mind those tabs/spaces in your code formatting...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dave Watts wrote: >> What if at the end of the process I ran the query using the same query name >> and no caching. Would that actually get rid of the cached query? >> > > That won't work, but you can flush a single query from the cache by > rerunning the query with only one change - set CACHEDWITHIN to > CreateTimeSpan(0, 0, 0, 0). Everything else about the query must > match, including the SQL. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4