> Ahhh... the old CF Aussie list to the rescue again (I Hope). > > Have an admin interface which list a heap of records. Has an option to > delete a record. It then returns the list of records again... now > normally the list would return minus the record that was deleted, > unless... (and heres my problem) the server it is running on has queries > being cached.... > > Is there anyway I can tell coldfusion not to cache queries for my app or > for specific queries as the coldfusion server admins don't want to turn > off the query caching. ;)
I do a lot of large query caching for one of my app's due to slow db access and I needed to update the query in memory (ie application, session scope etc) from time to time (updates, deletes, etc) so I wrote a java tag to do this as QofQ sadly lacks this feature even in CF7. This approach is a lot more efficient then clearing the cached query and then running the retrieval from the db again as im pulling the data out of an oracle rbd legacy system. More then happy to pass on if your interested. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
