Never heard of this before. If you're sure you're using the latest code from CVS, I would try to create a simple test case that demonstrates the problem and sending it to Doug.
On 10/26/07, Kevan Stannard <[EMAIL PROTECTED]> wrote: > > I understand that Reactor creates cached query files under > > /reactor/project/projectname/Queries > > > > I have found that for some SELECT queries and some DELETE queries Reactor > attempts to use the same query cache filename for both types of queries. > > > > For example, I have found that Reactor uses the same query cache file name > for the following two SQL statements (I have added line breaks for > readability). > > > > > > SQL 1 > > --------- > > > > SELECT > > [ContactHistoryFiles].[contactHistoryFilesID] AS [contactHistoryFilesID], > > > [ContactHistoryFiles].[contactDetailsID] AS [contactDetailsID], > > [ContactHistoryFiles].[salespeopleID] AS [salespeopleID], > > [ContactHistoryFiles].[officeCode] AS [officeCode], > > [ContactHistoryFiles].[directoryPath] AS [directoryPath], > > [ContactHistoryFiles].[filename] AS [filename], > > [ContactHistoryFiles].[originalFileName] AS [originalFileName], > > [ContactHistoryFiles].[dateAdded] AS [dateAdded], > > [ContactHistoryFiles].[addedBy] AS [addedBy], > > [ContactHistoryFiles].[dateUpdated] AS [dateUpdated], > > [ContactHistoryFiles].[updatedBy] AS [updatedBy], > > [ContactHistoryFiles].[fileRenamed] AS [fileRenamed] > > FROM [ContactHistoryFiles] AS [ContactHistoryFiles] > > WHERE [ContactHistoryFiles].[contactDetailsID] = <cfqueryparam > cfsqltype="cf_sql_integer" value="#arguments.Query.getValue(1)#" /> > > > > > > SQL 2 > > ---------- > > > > DELETE FROM > > [ContactHistoryFiles] > > WHERE [contactDetailsID] = <cfqueryparam cfsqltype="cf_sql_integer" > value="#arguments.Query.getValue(1)#" /> > > > > > > > > > > So, if SQL 1 runs first it creates a cache file for the SELECT statement. > > > > When I execute SQL 2, it re-runs the cached SELECT statement again rather > than performing a delete. > > > > > > > > Anyone encountered this before? > > Thanks > > > > > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [EMAIL PROTECTED] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
