If I understand what you're doing ... I don't think is a caching issue, but simply a matter of how your query is built, the app logic, or business rules or something like that.
I think you'll want to figure out an application logic that suits your new needs ... For example, if it were me, I might build an application that had each telemarketer login, grab the 50 phone numbers and tag the DB that these records are currently checked out. Then when the next TM logs in, he gets the next 50 records that are not checked out, and checks them out. As each record is called, it gets checked back in, maybe with some disposition code that allows the record to be recued up for another call (no answer or busy signal), put on "do not call", "sale made," ... whatever rules suit your needs. H. > -----Original Message----- > From: Burcham, Steve [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 30, 2003 1:03 PM > To: CF-Talk > Subject: Query Caching > > I have a 'Telemarketing' application, don't worry we only call existing > customers to update there profile information for the new sales process, > that caches a list of the first 50 customers based on the search criteria. > This works great for now, but we are adding a second person to make calls > at > the same time. Are both of the "Telemarketers" going to get the same > record > set and if so is there a way around this. > > Thank you. > > Steve Burcham > Webmaster - Field Support Team > RDO Equipment Co. > Phone (701) 239-8755 > <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
