The weird bit about this, James, is that there is no error message. That's how come it went unnoticed for so long. The entire template runs as designed, except that this tag doesn't work. (The next part of the job is to compare the results of the tag with records in a SQL table and update if they're different. Since there was no difference, no updating went on and the old values were retained.
I can't think why there was no error message. I wrote another template to CFDUMP the results of the query, and the it contained only the column headings. (Yes, I know I know - there's a logic error in the rest of the template, but I can fix that ok. It's finding out how come this doesn't work) I can CFDUMP the CSV file after it's read in using CFFILE, so there are definitely files for the tag to read. Puzzling huh. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Silva Sent: Thursday, 27 February 2003 5:19 PM To: CFAussie Mailing List Subject: [cfaussie] RE: CFX_CSVToQuery tag just stopped working ... huh? Michael, is there any error you can show us? I've been using it for uploaded CSVs (on demand - not scheduled) for a while now without any problems. Although, it REALLY doesn't like it when you point it at a CSV which is currently locked by another app (i.e. excel). Is there any chance that it's trying to open locked files? Since it's in a schedule im guessing the first thing it does is try to open up a bunch of files that haven't been processed yet. Can you delete these files by hand? _______________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: www.gruden.com _______________________ > Does anyone have any idea where I should go looking for the reason this > custom tag CFX_CSVToQuery just stopped working? > > On 29 January, the daily update job I do on a bunch of CSV files just > stopped happening. The server hasn't been restarted, hiccupped in any > way in all that time, the tag was running for 8 weeks prior to that > without flaws. No one's even logged into the console of that server > between Jan 26 and today, so its nothing to do with the Sysadmins > changing something. We had a major upheaval in our system configuration > but it ran happily for 2 weeks after that, so I don't think that's the > reason. > > I have reinstalled the custom tag from the CF administrator, and that > didn't fix it. I've also restarted the server, but that didn't fix it > either. > > Anyone have any ideas where else to go looking? > > We're using CF5.0, and the tag is CFX_CSVToQuery.dll --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
