Running into some odd behavior, that maybe someone can give me insight on. On CF8, connecting to MS SQL, I'm seeing some very odd situations, whereby my query results are being cached, even though I haven't coded them to be. I run a template, that dumps query results, and get 23 values back. I go into SQL Enterprise Manager, adjust a record, run the query in Query Analyzer, and get 22 records back. I refresh my template and get the 23 records previous. The data has changed. If I adjust the query, like by adding an additional column, and refresh the template then I will get the correct 22 records back. Remove the additional column and I'll get the correct 22 records.
I was banging my head against a wall, for several hours, over an Ajax call to a paging query, before opening Firebug and discovering the same type of issue. Am I missing something? I've never had this type of issue before on an uncached query, so I am at a loss. Any suggestions? -- Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
