Not only the exact SQL but also spaces and tabs makes a difference. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm
----- Original Message ----- From: "Bob Keleher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:00 PM Subject: Re: [CFTALKTor] CF cachedwithin question > > But when each of you indicate that a changed set of SQL will "replace" > > (Bob's words) or "purge" (the book's words) the previously cached query, > > that's a mistaken assertion. > > > > The new SQL will simply create a new instance of a cached result. > > Thank you Charlie. It never occured to me that there could be multiple > instances of the same query (I don't think the documentation makes that > clear). But thinking about it, yes, that makes a lot of sense. I have this > mental image of a queries name and other attributes and its SQL being > concatenated to form a key - if the key exists, use the associated results, > otherwise create a new instance. > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Bob Keleher" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marius Milosav" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
