Thanks, Matthew, I'll check it out. I'm using the tag once a day to import 17 csv files from the ftp directory where our information supplier dumps them and turn them into queries so they can be inserted into a SQL7 database.
That's all its used for. But with all the trouble it's given me, I wish I'd done the project another way 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
