Mike, Might be best to put a cflock around the tag in this case as well to prevent multiple accesses to the csv file. The main advantage to this tag is that its CFML and not executing an external dll which might help remove a layer of potential issues.
In the case of the CFX tag, you'd want a cflock as well to ensure that problems don't occur if the tag isn't thread-safe. Matt > -----Original Message----- > From: Michael Kear [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 19, 2002 9:20 AM > To: CF-Talk > Subject: RE: CSVtoQuery problem > > > G'day Matt, > > I notice your example code doesn't have a lock around the > tag. Several > people have said that my problem might be the absence of a > CFLOCK around my > use of the tag. What's your take on that? Should I have > CFLOCK around it? > Your example code doesn't, and nor does Nate Weiss's, who > wrote the tag I > have been using till now. > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -----Original Message----- > From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 20 November 2002 12:56 AM > To: CF-Talk > Subject: RE: CSVtoQuery problem > > Mike, > One of my coworkers just did a similar tag in CFML; not sure > how extensive > your use of the cfx tag is, but this set of tags might be helpful: > http://www.emerle.net/programming/index.cfm > > Regards, > > Matt > > > -----Original Message----- > > From: Michael Kear [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 19, 2002 7:41 AM > > To: CF-Talk > > Subject: RE: CSVtoQuery problem > > > > > > No I haven't. That was suggested by Robin Hilliard too, and > > I'm wondering > > if that is the problem. What puzzles me is why the tag > broke when the > > system booted, after working fine for 2 weeks already. > > Would locking have > > solved that do you think? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > -----Original Message----- > > From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 19 November 2002 10:27 PM > > To: CF-Talk > > Subject: CSVtoQuery problem > > > > Have you got cflock s around the cfx? > > > > Justin > > > > > Date: Tue, 19 Nov 2002 18:28:25 +1100 > > > >From: "Michael Kear" <[EMAIL PROTECTED]> > > > Subject: Anyone have any ideas why this happens? > CSVtoQuery problem > > > Message-ID: <[EMAIL PROTECTED]> > > > > > > Does anyone else have any idea why my CSVtoQuery tag might > > be crashing the > > > CF Server? > > > > > > > > > OR even if it's the custom tag that's causing the problem? > > > > > > To recap .... Here's the story so far .... > > > > > > > > > I installed Nate Weiss's CSVtoQuery custom tag on my staging > > > server and used > > > it successfully for a couple of weeks. > > > I deployed the application and installed the tag on the > > production server, > > > where it worked happily for two weeks. > > > When next the Sysadmin booted the server, last Friday, the CF > > > server refused > > > to work. Every time anyone called a .cfm page, it called for a NT > > > authorisation. (So far as we know, no one has changed > any folder > > > structure or permissions structure on the NT) > > > > > > When we changed the name of the custom tag to something > > else, the Cfserver > > > worked ok again (except for that app of course) > > > > > > > > > The tag is called once a day in a scheduled task at 7am. The > > > system reboot > > > was at 3am and CF crashed from that moment. > > > > > > > > > > > > So what I'm wondering is .... > > > > > > Is Nate's tag buggy? > > > > > > Why would it work ok for a couple of weeks, then only > crash when the > > > NTServer is rebooted? > > > > > > I'm not sure what would cause the whole CF server to demand NT > > > authentication, and then stop doing it when the custom tag > > is renamed. > > > > > > SO therefore I 'm not sure if the remedy for this problem > > is to get rid of > > > the custom tag, or whether the problem lies somewhere else. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
